Hi All

I am having problems setting linking to a MYSQL from MSSQL (both installed on same machine).

I can connect to a MySQL database (called 'test') via the command line MYSQL and also with the MySQL Control Centre.

I have MyODBC with the following data:
Description: MySQL ODBC 3.51 Driver DSN
Host: localhost
User: root
PW: root
Port: 3306

Clicking "test data source" indicates that the datasource works okay.

Now, in MSSQL Enterprise I try to create a linked server. I select:
Microsoft OLE DB Provider for ODBC Drivers

1) I am assuming that this will work with MyODBC

I enter a Provider String of:
Driver={mySQL};Server=localhost;Option=0;Database= test

2) What am I missing here?

When I click on my linked server I get:
"Error 7399: OLE DB provider 'MSDASQL' reported and error. The provider did not give any information about the error."


Many thanks for any suggestions getting MSSQL to Link with MYSQL