| ODBC Weirdness! [message #664165] |
Wed, 05 July 2017 23:19  |
 |
HeyMoe
Messages: 9
Registered: July 2014
Location: Australia
|
Junior Member |
|
|
I recently was upgraded to a 64bit Windows 7 PC.
When I went to check ODBC connection information via Control Panel/Admin Tools, there is no ODBC Connection tab!
I then run ODBCAD32.exe from c:/windows/system32, and the 'User DSN' tab does show a list of data sources I need, BUT the 'Drivers' tab is empty.
When I try and Configure on of the listed sources, I get this error message "Oracle OCDB driver could not be found".
If I run ODBCAD32.exe from c:/windows/SysWOW64, it too shows the list of sources, but this time the 'Drivers' tab is populated.
The main outcome from all this is the application I use that requires these ODBC connections, fails to connect to the databases.
In the Windows registry, should I see the connections listed as /system32/xxxx or /SysWOW64/xxxx
Any help would be appreciated.
Thanks.
[Updated on: Wed, 05 July 2017 23:37] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: ODBC Weirdness! [message #664187 is a reply to message #664165] |
Thu, 06 July 2017 06:54  |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
On Win7, the 32-bit odbc admin and the 64-bit odbc admin are completely separate, and their "repositories" are completely separate. The 32-bit admin will not show 64-bit drivers, and vice versa. The 32-bit admin will not show DSNs created under the 64-bit admin, and vice versa.
Quote:
In the Windows registry, should I see the connections listed as /system32/xxxx or /SysWOW64/xxxx
It depends on if you are looking for connections defined under the 32-bit admin or the 64-bit admin. What are you seeing on your system?
BTW, don't expect consistency or sanity from Microsoft on this. I once thought that the mere existence of the \SysWOW64 tree in the registry was clear evidence of having a 64-bit system. After all, there's no reason for such a branch on a 32-bit system. Well, I was proven wrong. Mind you, not all 32bit Win7 has it, but some do. And when I tried to find out (from various MS support forums) why, the best I could get was a shoulder shrug.
I think it is also a nice touch (sarcasm) that in spite of MS hating the command line, that is the only way to get to the 32-bit odbc admin. There is no option under the control panel, and no indication that the odbc admin that is accessed through the control panel is only for 64-bit drivers.
[Updated on: Thu, 06 July 2017 06:56] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
