MySQL Forums
Forum List  »  Microsoft SQL Server

SQL Server 2000 to MySQL Databases
Posted by: David Stone
Date: February 11, 2009 01:52PM

Ok we are trying to link two databases and their tables we are following the steps in I have successfully linked up the databases, but what I have a problem with is in Page 8 in the above link was to set up a trigger that when one table gets changed the linked server would also change.

When I tried this I got this error and got stumped?

SQL Server Enterprise Manager Error reads:

[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: [MySQL][ODBC 3.51 Driver] Optional feature not supported]
[Microsoft][ODBC SQL Server Driver][SQL Server] The operation could not be performed because the OLE DB provider ‘MSDASQL’ was unable to begin a distributed transaction.

Edited 1 time(s). Last edit at 02/11/2009 01:54PM by David Stone.

Options: ReplyQuote

Written By
SQL Server 2000 to MySQL Databases
February 11, 2009 01:52PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.