Connecting to MySQL

[Jeremy Dillinger]

I am trying to design a program that will use data from a MySQL database.
Currently all the data is being used with PHP scripts from a website. I am
also trying to build a software solution that can use the same data. I have
gone through all the data connectors in Visual Basic.net and none of them
have the options for connecting to MySQL. Does anybody know how I would go
about doing this? Thanks in advance!

Jeremy

 

[Will Gillen]

Jeremy --

From what I have read, and the little experimentation that I have done with
..NET and MySQL, it appears that MySQL doesn't fully support OleDB (yet).
So, I would research the ODBC provider for .NET:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataodbc.asp

You can't build Stored Procs in MySQL (from my experience, anyone help me
out here..)
But you can build a DataFactory class in .NET for accessing MySQL with ODBC,
and possibly use "prepared statements"...

-- Will G.

 

[Ken Tucker [MVP]]

Hi,

.Net class for connecting to mysql databases.
http://dev.mysql.com/downloads/connector/net/1.0.html

Ken
----------------------
I am trying to design a program that will use data from a MySQL database.
Currently all the data is being used with PHP scripts from a website. I am
also trying to build a software solution that can use the same data. I have
gone through all the data connectors in Visual Basic.net and none of them
have the options for connecting to MySQL. Does anybody know how I would go
about doing this? Thanks in advance!

Jeremy

 

[Guest]

Hi Jeremy,

you can connect your .NET programs with MySql without problems.

You have two different ways.

One of them is connecting it through of ODBC.
If you have .NET Framework 1.0, you'll have to install ODBC .NET.
For .NET FW 1.1 it isn't necessary.
ODBC .NET Data Provide
http://www.microsoft.com/downloads/...FamilyID=6CCD8427-1017-4F33-A062-D165078E32B1

The other way is connecting with OleDb.
For this, you need the correct APIs (or drivers) to do it.

MySQL recomends the next free drivers (there are a lot of drivers, but they
aren't free):
ODBC
http://dev.mysql.com/downloads/connector/odbc/3.51.html
OleDb
(Beta)
http://dev.mysql.com/downloads/connector/net/1.0.html
(Beta and external Open Source development)
http://sourceforge.net/projects/mysqldrivercs/

for more information:
http://dev.mysql.com/downloads/

I hope that helps.

Kind Regards,

Jorge Serrano
MVP VB.NET