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
MS SQLSERVER 2005 linked server connection to MYSQL
mysql .net provider
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
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