Aliaspooryorik
ColdFusion ORM Book

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!


No comments

Leave a comment

If you found this post useful, interesting or just plain wrong, let me know - I like feedback :)

Please note: If you haven't commented before, then your comments will be moderated before they are displayed.

Please subscribe me to any further comments
 

Search

Wish List

Found something helpful & want to say ’thanks‘? Then visit my Amazon Wish List :)

Categories

Recent Posts