A Unified Communication Blog
Get Adobe Flash player

Just have a small incident at a customer.
The customer was using an 32 bit application called Microsoft XAL which I have installed on a Windows 2008 x64 bit server TS Server.
The application uses a SQL database which is located on a remote server.
The program is connecting to the SQL server with an ODBC system DSN.
When I created and tested the System DSN on the server, then it connected to the SQL Server just fine, but the application couldn’t connect to the server.

After some time I found in the x64 bit version of Windows 2008 and Vista there is a 32bit ODBC Data Source Administrator which is I located in %systemroot%sysWOW64 and is called odbcad32.exe.When you run this version instead of the one from Administrative tools the you can create a 32 bit DSN which can be used by 32 bit programs.

25 Responses to ODBC in Windows 2008, x64

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Search

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 71 other subscribers

Follow me on Twitter