32bit ODBC DSNs on 64bit Windows
I've been having 'fun' with a 32 bit application running on a 64bit Windows server which I need to connect to Microsoft SQL Server via an ODBC connection. What I didn't know was that when you choose "Administrative Tools -> Data Sources (ODBC)" then you can only see and maintain 64bit ODBC datasources (not that it tells you this of course!).
To see maintain 32bit ODBC datasources, you need to run:
c:\windows\syswow64\odbcad32.exe
This makes an identical looking dialog appear, but all the system and user DSNs are 32bit.
I'm blogging this for future reference and to hopefully save someone else some pain!
- Posted in:
- Windows
