Link server error The provider did not give any information about the error
Hi!
We have a test server (win 2003) in which MSSQL server is installed.In my system (win XP)I installed MYSQL server ,MY sql odbc driver.Now all I want is to create a linked server on MSSQL server so that data on Both server can be in sync.When even a new record in inserted in MSSQL it should be replicated to MYSQL srvr tabl immeditely. To setup the linked server I followed the steps given in this URL
http://developer.infi****/index.php?ID=6&article=6.
After completing the setup when I try to create any trigger or table it's giving this error Error 7399: OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
Can anybody please suggest what to do?
Sougata
Subject
Written By
Posted
Link server error The provider did not give any information about the error
August 05, 2009 12:26AM
November 07, 2009 03:38AM
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.