ODBC Connector to MySQL server

[Roman B.]

We have an access 2007 DB which resides on our server. we have apporx 10
users who connect to the db on a daily basis. I need to connect one of the
tables via ODBC to an external offsite MySQL server via ODBC. I've done this
with one workstation and a test DB and it works great. Whats the best way to
do this so I don't have to go around to all the workstations setting up odbc
connections to the outside server? I would like to have the DB connected all
the time via ODBC and just have the clients connect to the DB.

any help is much appreciated.

R

 

[Arvin Meyer MVP]

Actually, the best way to do it without setting up a DSN on each workstation
is to use a DSNless connection. See Carl Prothman's site for an extensive
listing of connection strings:

http://www.carlprothman.net/Default.aspx?tabid=81

 

[Stefan Hoffmann]

hi,

Actually, the best way to do it without setting up a DSN on each workstation
is to use a DSNless connection. How-to:

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

See Carl Prothman's site for an extensive listing of connection strings:

http://www.carlprothman.net/Default.aspx?tabid=81

or more specific

http://connectionstrings.com/mysql#31



mfG
--> stefan <--