MySQL Forums
Forum List  »  Microsoft SQL Server

Linked server using OLE db
Posted by: Bruno De Grauwe
Date: March 21, 2005 07:35AM


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?


Options: ReplyQuote

Written By
Linked server using OLE db
March 21, 2005 07:35AM
March 29, 2005 12:08PM
June 23, 2005 03:05AM
June 23, 2005 03:06AM

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.