[AccessD] ODB connection

Doug Steele dbdoug at gmail.com
Thu Feb 28 09:26:04 CST 2013


As an alternative, you could use a DSN-less connection with code:

http://www.accessmvp.com/DJSteele/DSNLessLinks.html

(That's a different Doug Steele, not me!)

Doug


On Thu, Feb 28, 2013 at 7:19 AM, Jim Dettman <jimdettman at verizon.net> wrote:

>
>  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
>


More information about the AccessD mailing list