Facing problem in making linked server

• Saqib-215297

  SSC Enthusiast

  Points: 147

  More actions

  March 10, 2005 at 7:50 am

  #74899

  Hi to all,

  I am trying to make a Linked server of Mysql running on the same machine having MS sql server.

  I am using the following script:

  sp_addlinkedserver @server ='192.168.1.11' ,

  @srvproduct = 'MSDASQL' ,

  @provider ='MSDASQL' ,

  @datasrc = 'demomatch' ,

  @location ='192.168.1.11' ,

  @provstr = 'Driver={MySQL ODBC 3.51 Driver}' ,

  @catalog = 'demomatch'

  go

  I can c the the new linked server made in the linked server list but when I click on the tables, I receive error:

  error 7399: ole db provider 'MSDASQL' reported an error. Data source name not found and no default driver specified

  Any help?

  Regards

• Saqib-215297

  SSC Enthusiast

  Points: 147

  More actions

  March 10, 2005 at 7:59 am

  #546376

  Sorry to post the topic here instead of posting in "Replication Topics". 

  I guess u guys will ignore this mistake 

  I will Repost it in Replication topics , Please forgive me for this  

  Thx