Devart Forums

Good Morning

Can I use the MySQLDirect .NET Data Provider to create a linked server connection from Microsoft SQL server 2005 to a MYSQL Database running on Linux Red hat.

I've installed the MySQLDirect .NET Data Provider on the MS SQLServer
machine, but it does not show up in the list of available providers in the linked server objects provider list. (from microsoft sqlserver management studio )

incidentally, it is visable and useable, from visual studio 2005 on the same machine.

Prehaps there is a better way of exposing the mysql tables from within
the microsoft sqlserver management studio than using linked servers
these days?

If it is possible has anyone a connection syntax example?

thanks




David Hills

As I know, Linked Server points to an external data source that can be accessed by OLE or ODBC. MySQLDirect .NET is ADO.NET data provider and has nothing to do with OLE or ODBC. Please describe where it is visible in Visual Studio 2005 with regard to linked servers.

Hello Alexey

Thanks for your response

As regrads to it being visable in visual studio as regards linked servers, its not. All I ment by this was that I'd installed the mysql .net provider correctly and I had connectivity to the mysql database.

I guess your answer then means NO , as its an ado.net provider.

Can you wrap it, to make it usable as an oledb provider?


or is the a OLEDB provider for MYSQL some where I can use?

I've tried one from Cherry Systems but it would not work, also
there seems to be an issue for the 4 part nameing convention used
by SQL server.

thanks for your help

Regards

David Hills

No, unfortunately MySQLDirect .NET cannot be wrapped such way.
As for OLE DB providers for MySQL, there are some, but I am not sure they will suit your needs. Try to search MySQL AB site.