[mapserver-users] RE: ODBC connections 32 vs 64 bit

[Johan Forsman]

If I recall correctly a 32-bit application can only see 32-bit ODBC sources, so you must use the 32-bit ODBC utility (C:\Windows\SysWOW64\odbcad32.exe) to define the source. I have this scenario on my 64-bit Vista workstation. From Access 2007 I can only see the 32-bit version of my Oracle ODBC source, not the 64-bit version of the source. Access 2007 is a 32-bit application.

Hope that helps,
Johan.

From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Friday, September 24, 2010 9:51 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] ODBC connections 32 vs 64 bit

Question:  I am trying to connect to a MDB on a local drive....everything testing on my local computer.
I have a 64 bit windows 7 machine....
There are two locations to create ODBC connections:  This article says a bit http://support.microsoft.com/kb/942976

32 bit      \Windows\SysWoW64\odbcad32.exe
64 bit       \Windows\System32\odbcad32.exe

Does it matter if the ODBC connection is done on 32 or 64 bit?  Is there a difference?
When I try and create an ODBC connection on 64 bit there are no drivers displayed?  Very confusing

Thoughts?

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100924/8ab1eb9d/attachment.htm>