Good Afternoon


Is it possible to set up a linked server in sqlsever2005 using a dot net
provider driver?

In particular can I link (linked server)to mysql using the .net provider for
mysql version 5.1.3?


If this is not possible, is there another way of using the .net provider to
expose
date(read only) from mysql, may be using custom data source .net assemley,
or some such thing.


I would like to be able to write querys and views in sequal that pull data
from mysql

ie
select * from mysql_sometableorother




thanks


David Hills




--
Thanks



David Hills

David (David (AT) discussions (DOT) microsoft.com) writes:
A linked server requires an OLE DB provider.

If all you have is a .Net Provider, you can implement CLR functions that
access the MySQL or whatever that way.




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx