MS SQLSERVER 2005 linked server connection to MYSQL

MS SQLSERVER 2005 linked server connection to MYSQL

Postby dhills » Thu 22 Feb 2007 14:19

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
dhills
 
Posts: 2
Joined: Thu 22 Feb 2007 14:01

Postby Alexey » Fri 23 Feb 2007 08:38

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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

mysql .net provider

Postby dhills » Fri 23 Feb 2007 12:39

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
dhills
 
Posts: 2
Joined: Thu 22 Feb 2007 14:01

Postby Alexey » Fri 23 Feb 2007 13:09

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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL