The program can’t start because VCRUNTIME140.dll is missing from your computer

If you are trying to install Microsoft Access Database Engine 2016 Redistributable, under certain circumstances you might get the below error message: The program can’t start because VCRUNTIME140.dll is missing from your computer. Try reinstalling the program to fix this problem. As it can be figured out from the error message, VCRUNTIME140.dll refers to the … Read more…

Internal Query Processor Error: The query processor could not produce a query plan

OK folks, it did happen a few days ago to get this error message: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. I was trying to execute the following query: SELECT * FROM dbo.tbl1WHERE tbl2ID=(SELECT id FROM dbo.tbl2 WHERE Code=’Code1′)AND tbl3ID=(SELECT id FROM dbo.tbl3 WHERE Code=’Code2′) … Read more…

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

There are some times where database applications give the above error when trying to convert strings to the datetime format in SQL Server. This error is related to the default language and consequently the dateformat used by the corresponding SQL Server login. There are two approaches for avoiding/resolving this issue. The first approach is to … Read more…