Home » Infrastructure » Windows » ODBC Weirdness!
ODBC Weirdness! [message #664165] Wed, 05 July 2017 23:19 Go to next message
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 #664166 is a reply to message #664165] Thu, 06 July 2017 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I recently was upgraded to a 64bit Windows 7 PC.
From what?

Did you install an Oracle client for the new Windows?

Re: ODBC Weirdness! [message #664167 is a reply to message #664166] Thu, 06 July 2017 00:41 Go to previous messageGo to next message
HeyMoe
Messages: 9
Registered: July 2014
Location: Australia
Junior Member
From a 32bit Windows 7.

Yes, Oracle client installed on new machine.


Re: ODBC Weirdness! [message #664168 is a reply to message #664167] Thu, 06 July 2017 00:45 Go to previous messageGo to next message
HeyMoe
Messages: 9
Registered: July 2014
Location: Australia
Junior Member
Or just ignore this bit "I recently was upgraded to a 64bit Windows 7 PC."
Re: ODBC Weirdness! [message #664169 is a reply to message #664168] Thu, 06 July 2017 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why if this may be the root of the problem?
Do you see ODBC Windows drivers? Or no drivers at all, confirm?
If no drivers (as you told) then the problem is at Windows level and not Oracle one.

Re: ODBC Weirdness! [message #664187 is a reply to message #664165] Thu, 06 July 2017 06:54 Go to previous message
EdStevens
Messages: 863
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

Previous Topic: how to automatically start wls Forms and reports services forms 11g winodows server 2008
Next Topic: sqloader load multiple file into 1 table
Goto Forum:
  


Current Time: Thu Dec 14 08:00:56 CST 2017

Total time taken to generate the page: 0.02575 seconds