[Microsoft][ODBC Driver Manager] Data source name not found and no default driv

澳洲大头

problem:
dsn setup in odbc manager not working in php.

solution:
In a 64 bit windows server operating system, there are TWO odbc managers. When you pull up the usual menu for the odbc / dsn system, it is for the 64 bit odbc manager, and 32 bit applications (vb 6.0) will not work using these dsn's.

This is where the 32 bit odbc manager is:

C:\Windows\SysWOW64\odbcad32.exe