ASP.net connect to MySql without installing DB

Question

I just want to be able to connect to a remote MySQL database on my ASP.net c# website running on localhost.

It's so I can grab some records, and insert them into my SQL server database. Do I need to download any drivers? And how do I connect and fetch records?

Thanks

Dillie-O · Accepted Answer · 2011-03-29 23:03:23Z

1

Get the ADO.Net driver for MySQL. This will allow you to connect to a MySQL database and use all of the .Net ADO standard stuff to get your data and put it elsewhere.

The added benefit about using the ADO.Net driver is that you can easily use the same data objects (DataTable, DataRow, etc.) when inserting the data into SQL Server.

answered Mar 29, 2011 at 23:03

Dillie-O

29.9k14 gold badges103 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tom Gullen Over a year ago

Thanks, I've downloaded and installed it, but using MySql.Data; gives red squiggle. Do I need to add a reference or DLL or something?

Tom Gullen Over a year ago

Ah added the DLL's manually with reference now, working, thanks!

Collectives™ on Stack Overflow

ASP.net connect to MySql without installing DB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related