Hi , I do installed the mySQL ODBC 3.1 to my server running on SQL Server 2000. And I able to create the ODBC connection to the mySql database and it is OK. Now , I like to create the remote server link on the Sql Server 2000 itself to connect to MySql using remote server. Can I know what is the provider string I should enter ? And what is the "location" means in the set up screen for remote server ? What is the full query I should put in in order to select the data from MySql using the Sql 2000 analyzer ? Many Thanks ..