Invalid Column Name issue in Classic ASP

While running classic ASP application , we come across below errors quiet often
- Invalid Column name
-Procedure does not exist
-DataSource is not valid
-Connection error

If you resolve one error by commenting and another error is coming OR you find that connection string is pointing to correct DSN mapped to correct database server but still error coming up , below is the solution.

Sit straight and tight 😊😊

May be, you are trying to search for ODBC driver in windows search and updating here.

This location may not be the one you ASP application is referring.Hence the DSN you have given is not picked by your application but different DSN of other ODBC driver.
So lets try to navigate to other hidden ODBC path using below run command.
%windir%\SysWOW64\odbcad32.exe

Here is the location of the correct odbc path,

Try to update your DSN with correct database server details using above exe and it will work for sure,