Skip navigation links

MySQL Forums :: Microsoft SQL Server :: SQL Server 2000 to MySQL Databases


Advanced Search

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 http://developer.infi.nl/daniel/Linking%20MySQL%20and%20MSSQL.pdf. 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


Subject Written By Posted
SQL Server 2000 to MySQL Databases David Stone 02/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.