By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,189 Members | 2,167 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,189 IT Pros & Developers. It's quick & easy.

connect to mySQL

P: n/a
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 16 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.
------------------------

http://www.sevenobjects.com/
http://crlab.com/mysqlnet/
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 16 '05 #2

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

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

regards
Ansil
Trivandrum

"Brian Brown" wrote:
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.
------------------------

http://www.sevenobjects.com/
http://crlab.com/mysqlnet/
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 16 '05 #3

P: n/a
Ansil MCAD wrote:
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
--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Nov 16 '05 #4

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

"Jassim Rahma" <jr****@hotmail.com> schrieb im Newsbeitrag
news:Oe**************@TK2MSFTNGP10.phx.gbl...
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 16 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.