MySQL

[Mothra]

Im wanting to try useing MySQL as a database for an app and Im wondering what to use to connect to it. I havent started yet but, Id like to have at least a general idea of how before I go through getting, installing and settting up MySQL. Can anyone point me in the right direction?

 

[Derek Stone]

Youll connect to the database using an instance of the System.Data.Odbc.OdbcConnection class, assuming you have version 1.1 of the .NET Framework installed. If this is not the case, please read this article: Exploring MySQL in the Microsoft .NET Environment.

 

[Mothra]

MySQL...

Hey thanks. Ill look into it. Just off hand, do you (or anyone for that matter...) think that MySQL would be a better option than the MSDE that ships with VS .NET? Mainly, Im just interested in useing the best free DB.

 

[Derek Stone]

Use MSDE. The SQL Server ADO.NET provider is a number of times better than the OleDB or Odbc ones.

 

[git]

Im using for a disconnected mode the mysqldirect driver from corelab.

works almost the same as the SQLdriver for ms sql.

regards git

 

[bungpeng]

Originally posted by git
Im using for a disconnected mode the mysqldirect driver from corelab.

works almost the same as the SQLdriver for ms sql.

Can you give more information about it? because I am also using mySQL, I am interesting with it

TQ

 

[git]

you can find information at:

http://www.crlab.com/

regards hilmar

 

[bungpeng]

I see.... it is third party Data Access Component...

TQ

 

[Mothra]

Back to the MSDE for a sec...

Does the MSDE need to be installed on the target PCs (users computer) to work or will it just need the runtime files to handle it?

 

[git]

you just need the dll... no msde needed to redistribute it to the clients..

regards git

 

[Mothra]

Thanks!