Hi. I am trying to find info on how to configure a Linked Server to a MySQL database using SQL Server's Enterprise Manager. I need to know what to put into the various fields; particularly on the 'General' tab. On the Linked Server's General tab I tried putting a DSNless ODBC string in the Provider String :
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=xxserver;Port=3306;DATABASE=xxdatab ase;UID=xxUserID;PWD=xxpswd;Option=131072;DS=dbo;" . This string works fine when I use it for ASP pages connecting to MySQL databases. In the Enterprise Manager I see a listing of the tables for the database I put in, but I get errors when querying, etc. Also, I am not seeing a Schema when I use some "sp" procedures to "see" the MySQL meta data.