Troubleshooting Archives

Troubleshooting

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

November 16, 2017

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…

Error Messages, SQL Server, SQL Server Development, SQL Server Troubleshooting, Troubleshooting

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

Artemakis Artemiou

December 15, 2012

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…

Troubleshooting, Visual Studio 2008

Machine Debug Manager – Windows Vista

Artemakis Artemiou

December 15, 2008

Recently I have installed Service Pack 1 for Visual Studio 2008.My machine runs Windows Vista SP1. During the installation process I was prompt with a warning message that the Machine Debug Manager service was still running. For completing the installation process on the safe side I had to stop this…

SQL Server, Troubleshooting

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

Artemakis Artemiou

October 17, 2008

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.…

Cookies