SQL Server Performance

Remote Server

Discussion in 'General DBA Questions' started by travistan, Oct 2, 2006.

  1. travistan New Member

    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 ..
  2. ghemant Moderator

    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
  3. satya Moderator

    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.

Share This Page