Sunday, 15 April 2012

Where is my ODBC driver gone?


Hello Boys and Girls,
Just finish installing some database drivers for SQLAnywhere 5.0 in my Windows 7.
I have the Professional version of Windows 7.

After the installation of the drivers I wanted to create an ODBC data source.

To my surprise when I went to the Control Panel->All Control Panel Items->Administrative Tools->Data Sources (ODBC)
and tried to add a new datasource the recently SQLAnywhere driver was not there.
The only drivers listed on the ODBC data source administrator were: SQL Server and SQL Server native client.
No trace of any drive for SQLAnywhere.








After spending 10 or 15 minutes with my friend Google I found one interesting fact:
There are two ODBC data source administrator executable (odbcad32.ex) in my Windows 7:
One is located on C:\Windows\System32 and the other is located in C:\Windows\SysWOW64






To manage a data source that connects to 64 bits driver, under a windows 7 64 bits, the odbcad32.exe located
on C:\Windows\System32

To manage a data source that connects to a 32 bit driver, under a 64 bits platform, the odbcad32.exe located on
C:\Windows\SysWOW64 should be used.

Snce I want to create a data source for the SQLAnywhere 5.0 driver which is a 32 bits I should use the odbcad32.exe located on, C:\Windows\SysWOW64
once I double click on it I was presented with the familiar ODBC data source administrator and then I clicked on "Add" I could see the SQLAnywhere 5.0
driver.







Problem solved.

 

No comments:

Post a Comment