[AccessD] ODB connection

Jim,

Thanks for posting this info.

I ran into the same issue when our first "Windows 64 bit" PC came in the
door last fall.

It took several hours of digging/experimenting/hair pulling before we
found the info that we needed.

Brad 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Thursday, February 28, 2013 9:20 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] ODB connection


 If your on a 64 bit OS, you need to use the ODBC applet in the sysWOW
folder.

 The one in:

 C:\Windows\System32\ODBCad32.EXE is a 64 bit version and any DSN there
won't be seen by 32 bit apps (which 2007 is).

 This is the one the gets launched from control panel.

 The one you need to use is:

 C:\Windows\syswow64\ODBCad32.EXE, which is the 32 bit version.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Thursday, February 28, 2013 10:06 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] ODB connection

I have set up some ODBC connections through the control panel using
Windows
7. When I look for these connections in Access 2007 (external data ODBC)
I
don't see them. Do I have to set them up in access also?
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.