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 ..
HI, you need to use like select columns from [server].[database].[owner].[object] and refer sp_addlinkedserver BOL for more. Hemantgiri S. Goswami ghemant@gmail.com "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami ------------------------ http://hemantgirisgoswami.blogspot.com
ODBC 3.1 is the old driver and I would suggest to use the latest on in this case to take care of such issues. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
