connect to mySQL

[Jassim Rahma]

Hi,

How can I directlly connect to mySQL server from C# without an ODBC
drive? connecting through ODBC means I have to include mySQL
Connecter/ODBC in my distribution media.. I want to only distibute my
application..


Many Thanks,
Jassim Rahma

 

[Guest]

Jassim,

You can use a .net provider (e.g. System.Data.SqlClient - except for mySql).
There are a few .net providers that you can use for MySql. I have posted
the links to a couple of them below. Also you can use OleDb to access the
MySql Database too.

I hope this helps.

 

[Guest]

hi
you can check these links also
http://www.codeproject.com/cs/database/ConnectMySQL.asp

http://www.bytefx.com/DotData.aspx

regards
Ansil
Trivandrum

 

[Frans Bouma [C# MVP]]

hi
you can check these links also
http://www.codeproject.com/cs/database/ConnectMySQL.asp

http://www.bytefx.com/DotData.aspx

Don't use the ByteFX driver with MySql 4.1 (i.e. the latest stable
release). It won't work. Either use the mysql .net provider (which is
the old bytefx driver) provided by mysql themselves, or invest a few $
and go for the CoreLab MySql driver.

Frans
--

 

[cody]

you need a native MySQL driver dll and use interop to call its functions.
for example libmysql4.dll