16 aprilie 2012 16:57
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.
17 aprilie 2012 06:31
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:
17 aprilie 2012 11:05
hi plz check the below given link. it ma help o uot.
17 aprilie 2012 13:31
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:
not having a valid file associated with it.
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:
This however does contain the drivers and the ODBC sockets we created:
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.
17 aprilie 2012 17:04
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.
- Marcat ca răspuns de KJian_ 23 aprilie 2012 06:02