MySQL Forums
Forum List  »  Microsoft Access

basic problem with initial connection
Posted by: Joe Auty
Date: June 17, 2005 01:24AM

Hello,

I'm hoping this problem will be really easy for somebody, I'm experienced with MySQL and PHP, but I'm a noob with ODBC and the connector deal.

Need to connect to my MySQL server via Access via ODBC.

1) installed the Connector on the Windows machine
2) Setup the DSN through the control panel to my server, entered my user/pass and server name, clicked test connection and it worked fine
3) Launched Access 2003, created new database
4) File menu -> Get External Data -> Link Tables
5) Set the file type to "ODBC databases"
6) Create a new DSN, select the MySQL ODBC driver, tried entering my server name and database within the Advanced section, also tried leaving this blank, saved my DSN file, says a connection cannot be made, would I like to save a non-verifiable DSN? I click yes
7) When I click OK I get the error message "cannot find driver {MySQL ODBC 3.51 Driver} in System Information

Am I doing something wrong? Why is it that my connection works within the control panel, but not within Access?

Can somebody please enlighten me?

Thanks, in advance for your time!

Options: ReplyQuote


Subject
Views
Written By
Posted
basic problem with initial connection
2658
June 17, 2005 01:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.