RE: : problem using mysql odbc with windows and access

Dominique Clauzel wrote:
> 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"

Which list?  Add/Remove programs?
That's just a descriptive name, not the ODBC driver name.

If you want the installed driver's name, look in:
 Control Panel -> Administrative Tools -> Data Sources (ODBC), or
 Start -> Run: "odbccp32.cpl"

> [MySQL][ODBC 3.51 Driver] Could not find driver {MySQL ODBC  3.51 Driver} in
> System information. (#0)

Not sure why the ODBC driver would be "looking for itself".

Seems there's a superfluous space character between "ODBC" and "3.51" though,
perhaps that's your problem?

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

Probably because "MySQL ODBC 3.51 Driver" is the correct ODBC driver name and
you're using "Mysql Connector/ODBC 3.51"..


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