Linked server using OLE db
Hi,
I want to add MySQL as a linked server in my SQL Server 2000. I can do this using ODBC drivers but I need to manage this using OLE DB drivers.
After searching the i'net for hours, I found OLE DB drivers for MySQL (februaty 2001!). I installed these drivers and tried to add MySQL as linked server in SQL Server but I always get an error message:
Error 7302: Could not create an instance of OLE DB provider 'MySqlProv'. OLE DB error trace [Non-interface error: CoCreate of DSO for MySqlProv returned 0x80040154]
Any ideas?
Thanks
Subject
Written By
Posted
Linked server using OLE db
March 21, 2005 07:35AM
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.