Connecting to MySQL dbase

[Guest]

Hi I am in the process of porting a MySQL dbase over to Microsoft SQL2000 and
am building a .NET app that will interface with the SQL2000 dbase. Anyhow
some of the tables are quite large and thinking it may be easiest just to
connect to MySQL read each table into a dataset and then write it to the SQL
2000 database. I already have the table structure in 2000 setup. Just
wondering if there is any information how to do this, can one use the ODBC
data adapter?
Thanks.

 

[Angel J. Hernández]

Hi there... I suggest you to use MySQL's ODBC Driver which u can download
here...
http://dev.mysql.com/downloads/connector/odbc/3.51.html

or MySQL's OLEDB Provider which is here
http://solutions.mysql.com/other/related-sites/?item=142

Then create a DTS and import your data into SQL

If u need connectivity to MySQL from .NET apps. The .NET DataProvider is
here
http://dev.mysql.com/downloads/connector/net/1.0.html

Hope this might help you,

Regards,