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:
DSN Name: MYSQLDSN
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."

Win2000AdvSvr
MSSQL2000
MYSQL4.0.2

Many thanks for any suggestions getting MSSQL to Link with MYSQL