SQL Server 2000 can connect MySQL using MyODBC
am 18.08.2005 15:13:05 von sylvain.devidal--=_alternative 0047B2BAC1257061_=
Content-Type: text/plain; charset="US-ASCII"
I've used MyODBC in SQL Server to transfert a database from SQL Server to
MySQL.
Except some types problems, SQL Server was able to create the tables and
fill most of the data.
I also tested the "OPENROWSET()" function un SQL Server, and I was able to
:
-> Read data from MySQL in SQL Server
-> Update this rowset (then MySQL data also) in SQL Server
So I think you can add it in the
http://dev.mysql.com/doc/mysql/en/myodbc-tested-applications .html page
Sylvain Devidal
Application Architect
--=_alternative 0047B2BAC1257061_=--