Hi Dennis,
This page should get you started with the
right syntax.
http://dev.mysql.com/doc/refman/5.0/en/without-dsn.html
The DSN-less connection will tell you what
the various name-value pairs are. If you use the advanced option for a
file dsn setup, it will instruct you to type in one pair per line, then you can
inspect the file for syntax details once the connection checks out.
Paul
From:
owner-micronet-list lists.berkeley.edu
[mailto:owner-micronet-listlists.berkeley.edu] On Behalf Of Dennis Arrigan
Sent: Wednesday, May 10, 2006 2:38
PM
To: Micronet
Subject: [Micronet] MS ACCESS ODBC
CONNECTION TO MYSQL
I am trying to use MS ACCESS as a front end for a small
application to access a MYSQL 5.0 database through ODBC. I am trying to set up
a File DSN but can not find the correct syntax. Has anyone successfully connect
to MYSQL through MS ACCESS?
Dennis Arrigan
berkeley.edu">arriganberkeley.edu
|