Re: : problem using mysql odbc with windows and access

Idclauzel@xxxxxxx wrote:

> Hi,
>
> I am testing MySQL, I am using actually Microsof Access 2000 and Windows  2000
> I create a database from Access to MySQL with the migration toolkit,  worked 
> fine. 
> I try to attach a MySQL table with Access using ODBC. 
> I  installed mysql-connector-odbc-3.51.12 
>
> In the connection dialog, Access  is asking for "Mysql ODBC 3.51 Driver" 
> in the list given by Windows there is  "Mysql Connector/ODBC 3.51" 
>
> when I try the connection I have the error  message: 
>
> [MySQL][ODBC 3.51 Driver] Could not find driver {MySQL ODBC  3.51 Driver} in 
> System information. (#0) 
>
> If I try to change the name in  the .dsn file using the second name I have an 
> other error message:  
>
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable  et 
> nom de pilote non spécifié (#0) 
>
> What should I do? As you noticed I am  french and the second message comes 
> from my microsoft product which is installed  in french! 
> Many Thanks in advance
> Dominique Clauzel
> Grenoble, France
>
>
>  
1. Try to use a regular DSN for this (not a File DSN).
2. You should be using a patched version from; 
ftp.mysql.com/pub/mysql/hidden/connectors/odbc as a fix for 
SQLDriverConnect has not been published yet.

The reason why the driver looks for itself under certian circumstances 
is because it wants to know what its setup library (thats the gui bits) 
is. It does not assume to be using the specific one we have made for it.

--
Peter Harvey, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified?  www.mysql.com/certification



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx