Setting up linked server with a MySQL Database

• Molly Weierbach

  SSCommitted

  Points: 1530

  More actions

  November 6, 2013 at 9:05 am

  #279735

  I'm trying to set up a linked server with an outside vender. I'm using SQLSRVR 2008 R2, the ODBC connection tests fine but when I got to open the tables I get this error? Any thoughts

  Cannot initialize the source object of the OLE DB provider "MSDSQL" for linked server "name". (Microsoft error 7303)

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 7, 2013 at 3:53 pm

  #1664951

  It could be anything. Very hard to tell without more information.

  See if this article helps: http://www.sqlservercentral.com/articles/Linked+Servers/73794/

  -- Gianluca Sartori