MySql as lkinked server to MS SQL Server 2000

• gwardell

  SSC Journeyman

  Points: 89

  More actions

  January 28, 2008 at 6:35 pm

  #71072

  Hi,

  I folowed the procedures in this post: http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx To add a linked server for MySQL, problem is it's for MS SQL 2005, not 2000.

  It added OK but when I open the Query Designer and try to build a query like I have with other SQL Server linked servers it doesn't work. I get this error:

  ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider 'UNKNOWN' reported an error.

  [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Unspecified error]

  [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Table 'valleydb.tables' doesn't exist]

  [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowse

  Also, trying to open the Table node under the linked server returns this error:

  ---------------------------

  SQL Server Enterprise Manager

  ---------------------------

  Error 7399: OLE DB provider 'UNKNOWN' reported an error.

  Table 'valleydb.tables' doesn't exist]

  OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowset::GetRowset returned 0x80004005: ].

  ---------------------------

  OK

  ---------------------------

  I'm a bit at a loss as to how to proceed since I've only used MS products, SQL Server and Jet, as a linked servers before, and of course they worked.

  It seems to be finding the MySql server, but having a problem retrieving the schema.

  Gary