Problem with Linked Server

• Shaik Ibrahim Mohd

  Newbie

  Points: 1

  More actions

  December 8, 2004 at 9:07 pm

  #163267

  I have a problem in Configuring Linked Server to MySQL Database. I downloaded ODBC Driver for MySQL and created a DSN but when i try to access it from the MSSQL its not working so any one plz guide me by giving step by step procedure to configure linked server to MySQL.

  Thanks in Advance

  Regards Ibrahim(UserID=199370)

• Marco A. Herlindo García

  SSC Enthusiast

  Points: 174

  More actions

  December 13, 2004 at 8:22 am

  #533563

  Did you use this parameters?

  sp_addlinkserver @server='server_name', @provider='MSDASQL',@datsrc='data_source'.