When connecting to databases on a 64 bit Windows machine you can receive the error "ODBC Driver Manager - Data source name not found and no default driver specified", like this example from CX-Supervisor:
This can be caused if you created a File DSN by launching the ODBC Manager from the Start menu. When you do this you're running the 64 bit version of the tool and 32 bit applications don't work with DSNs created in the 64-bit ODBC Manager, and will fail with the error above.
Solution
Create your File DSN using the 32 bit ODBC Manager using these steps:
- Open a Run window (by pressing Windows+R)
- Browse for file
C:\Windows\SysWOW64\odbcad32.exe
- Press OK to launch the 32 bit ODBC Driver Manager
- Create your DSN file as required. This DSN file will be compatible with 32 bit applications