MySQL database connectivity

[Steven Caliendo]

Hi,

I have a MySQL database on a remote server that I need to connect to. I
can't seem to figure out what the connectionstring should be? I've searched
through the help files, but all I can find is information for SQL server.

Thanks,

Steve

 

[Hermit Dave]

try looking for www.mysql.com

you do have links to download mysql drivers

you fight find some info on www.sourceforge.com as well

HTH

HD

 

[Michael Pearson]

Look at this page:
http://www.able-consulting.com/ADO_Conn.htm

spefically at
http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#MySQLNETNativeProvider

Enjoy!

Michael
(Please note that I do not work for able-consulting.com, they just have a
very handy resource out there for all of us to use)

 

[Mark Fox]

You have to get a MySQL data adapter component. do a
google search for "mysql ado.net"

 

[Joe Gass]

That's right you need to install myOdbc on the webserver (from
www.mysql.com)
Then use a connection string like

driver={MySQL ODBC 3.51
Driver};server=127.0.0.1;uid=yourUsername;pwd=yourPassword;database=yourData
base;OPTION=16834;
or
driver={MySQL};server=127.0.0.1;uid=yourUsername;pwd=yourPassword;database=y
ourDatabase;OPTION=16834;

depending on the myodbc version

I have used Microsoft.Data.Odbc to access the db in .net version 1.0 (you
have to download this too)
or System.Data.Odbc if you are using version .net 1.1 (included in 1.1
framework)

HTH

 

[Ben Roberts]

Have a look at www.sevenobjects.com/mysql.aspx

Regards

 

[dryer]

I've had great luck with ByteFX's MySQL data provider library, check it out at:
http://www.bytefx.com/dotdata.aspx


After that, connection is as easy as:
string connstrg = "Server=localhost;Database=mydatabase;User
ID=myuserid;Password=mypassword";
m_dbconn = new MySqlConnection(connstrg);
m_dbconn.Open();

dryer