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

Connecting to MySQL

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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/de...emdataodbc.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.
"Jeremy Dillinger" <je*****@hotmail.com> wrote in message
news:eR**************@TK2MSFTNGP10.phx.gbl...
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

Nov 21 '05 #2

P: n/a
Hi,

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

Ken
----------------------
"Jeremy Dillinger" <je*****@hotmail.com> wrote in message
news:eR**************@TK2MSFTNGP10.phx.gbl...
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

Nov 21 '05 #3

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

"Jeremy Dillinger" wrote:
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

Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.