MySql

  • Thread starter Thread starter Rafael Flórez
  • Start date Start date
R

Rafael Flórez

hello all :)

Quite a simple question for you .net veterans.

Naturally I am using the language c#, and now I want to sue the database
MySQl.

Unfortunately at this point I got all confused, I have connected to a MsSQL
DB, and an Access DB no problem, however I cant seem to find out how I
connect to a mySQL DB?

I would like a native connection and not use MyODBC if possible and would
appreciate some source code and tips on any third party drivers I may need
to install.

Thanks for your time
 
It's been a while since I did this, but you'll have to use myODBC.

If you're desperate I may be able to dig out some sample source code from
the bowels of our version control system, but it was an experiment we
abandoned. Unless you absolutely have to use mySQL I cannot recommend
strongly enough that you go with MSDE.

Go to google.com and search on mysql and "connection string" and you'll see
more message threads than you can shake a stick at. What you want will be in
there.

HTH,

Adam.
 
gani answered with the correct solution. MySQLDriverCS is an excellent
solution. It is fast. However, if you want to be able to use the drag and
drop style database tools that VS .NET offers, you may consider spending
$100 on the Core Labs MySQLDirect.Net solution at http://crlab.com/mysqlnet/
..

Neal
 
Back
Top