Reg Query and ODBC DSN's 1

[briangriffin]

Windows Server 2008 R2 Datacenter

I'm trying to pull a list of DSN's into my application using reg query:

reg query "hklm\software\obdc\odbc.ini"

I can see the DSN's I want at that location in the registry, but the query is returning the DSN list from this location:

HKLM\Software\Wow6432Node\ODBC\ODBC.INI

This query returns the same DSN's as the first query:

reg query "hklm\software\Wow6432Node\obdc\odbc.ini"

Those are also the same DSN's shown when launching the 32 bit ODBC Administrator. When using the 64 bit ODBC Administrator the proper DSN's are shown.

I've never used reg query before, but I'm at a loss as to this behavior. What am I missing?

TIA.

 

[kmcferrin]

You are running a 32-bit application on a 64-bit system, and the registry redirection feature is kicking in and catching your calls from the 32-bit application to the registry and redirecting it to the WOW6432Node that exists for 32-bit compatibility. If you query from a 64-bit tool (or perhaps using native PowerShell) then you should be able to get what you're looking for. Here's another solution:

http://support.microsoft.com/kb/948698

________________________________________
CompTIA A+, Network+, Server+, Security+
MCTS:Windows 7
MCSE:Security 2003
MCITP:Server Administrator
MCITP:Enterprise Administrator
MCITP:Virtualization Administrator 2008 R2
Certified Quest vWorkspace Administrator

 

[briangriffin]

Bingo, the /reg:64 switch works perfectly and is sufficient for this application. Thanks for your quick reply.