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