64 bit 2003 2008 - missing ODBC drivers

Question

I've been searching for a solution for this for some time and the solutions we find on the web don't seem to help.

We have both a 2003 and a 2008 enterprise version server and both of them once the OS's have been installed don't seem to have the ODBC drivers. The only thing displayed under the System-DSN is the SQL driver.

Both servers are 64bit.

There's almost nothing installed on these systems - but for some reason both display a SQL driver when trying to add another connection thought the ODBC manager.

Any thoughts on what we need to get those in place?

Here's a screenshot of one of our other 32 bit 2003 systems with the number of drivers it displays:

and here's the 08 with it's drivers:

I can't believe this is too hard of a task and that we can't seem to find any direction on this.

Answer 1

Hello,

Several of the drivers are really outdated; who e.g. uses still dBase?

If you need a 64 bit data provider, you have to install it.

And I am sure, on your new 64 bit machine there will be also some 32 provider available, just open the corresponding ODBC Admin from:

C:\Windows\SysWOW64\odbcad32.exe

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

hi plz check the below given link. it ma help o uot.

http://support.citrix.com/article/CTX124569

Answer 3

I was actually going to post about this very scenario. It seems like the 64 bit drivers are in place, but the 32 bit aren't. And the application we use seems to want to use the 32 bit. So when we create an ODBC, it complains about this key:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC

not having a valid file associated with it.

ERROR:
Error accessing available odbc datasources. - Cannot open HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources: Windows error 2 occurred.The system cannot find the file specified.

Inside that key (HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC) - there are no values.

This key seems to not have any values either:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ODBC

This however does contain the drivers and the ODBC sockets we created:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC

Any way to be able to load the 32 bit drivers and create the appropriate ODBC sockets? Since it seems like the application tries to use the 32 bit drivers instead of the 64 bit.

Thanks much

Answer 4

Hello,

That's a misunderstanding on your side, on a 64 Bit machine the Wow6432 node contains the 32 bit provider.

See my reply before, if you open C:\Windows\SysWOW64\odbcad32.exe you will see the 32 bit provider.

32 Bit application can only use 32 bit provider, 64 bit application only 64 bit provider.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing