Re^2: DBI Module, 32-bit Perl on 64-bit Windows 7: ODBC Connection confusion

UPDATE 2:

I should add for completeness that I do have a 64-bit version of strawberry perl on this system, and I can't recally, but I *might* have been using that to test my code inadvertently, not the 32-bit perl like originally posted. I didn't realize that it was ambiguous until I remembered the dev strawberry install, so sorry for that confusion.

To be clear, both 32-bit and 64-bit now work fine, but I can't vouch for which way I was testing it for the results of my original post. Apologies.

UPDATED:

After reading a bit more carefully, and reading the links, I think I understand the post, but am still confused by the behavior of the system. If I'm understanding correctly, my perl install is 32-bit, so I'd think I'd have to use 32-bit drivers, which would have been registered in %WINDIR%\SysWow64\odbcad32.exe . But the opposite was true -- it didn't work until I registered them in the 64-bit app (%windir%\system32\odbcad32.exe).

Likewise, my R install is 64-bit, but I used the 32-bit drivers (registered in %WINDIR%\SysWow64\odbcad32.exe).

Either I'm fundamentally NOT getting this (likely), or this is seriously weird.

------------------------------------------

Wow, thank you very much! That helped a ton! A good explanation of a very confusing situation...

Matt

Comment on Re^2: DBI Module, 32-bit Perl on 64-bit Windows 7: ODBC Connection confusion

Replies are listed 'Best First'.
Re^3: DBI Module, 32-bit Perl on 64-bit Windows 7: ODBC Connection confusion by mvaline (Friar) on Feb 08, 2011 at 05:23 UTC
According to KB942976, system DSNs are stored in `HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI`. Registry redirection is enabled for this key, meaning that system DSNs for 64-bit and 32-bit applications are separated and only visible in the corresponding version of ODBCAD32. User DSNs are stored in `HKEY_CURRENT_USER\Software\ODBC\ODBC.INI` for which registry redirection is not enabled. Consequently, both versions of ODBCAD32 see all user DSNs. If you had created a 32-bit system DSN and Perl couldn't use the DSN, it must be the case that the DBI module was pulling the registry key from the 64-bit registry and using the 64-bit SQL Server ODBC Driver. Can you provide the actual error you received?	[reply] [d/l] [select]
Re^4: DBI Module, 32-bit Perl on 64-bit Windows 7: ODBC Connection confusion by mpettis (Beadle) on Feb 08, 2011 at 05:37 UTC
i'll try to recreate tomorrow -- away from work and that env now...	[reply]