RE: Connecting to MySQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jorge Serrano [MVP VB] (NOQUIEROSPAMwebmaster_at_NOQUIEROSPAMportalvbNOSPAM.com.NOQUIEROSPAM)
Date: 11/09/04


Date: Tue, 9 Nov 2004 11:29:08 -0800

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 Provider
http://www.microsoft.com/downloads/details.aspx?displaylang=en&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

"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
>
>
>



Relevant Pages

  • Re: List of DB drivers.
    ... If I use MySql: ... but when refer to the parent object type: SqlConnection etc ... ... How can I search drivers in ODBC, Ole DB, ADO.NET? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: List of DB drivers.
    ... For MySql: Isn't any MySql for ODBC (Ole DB, ... How can I search drivers in ODBC, Ole DB, ADO.NET? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: connect to mySQL
    ... you need a native MySQL driver dll and use interop to call its functions. ... > How can I directlly connect to mySQL server from C# without an ODBC ... connecting through ODBC means I have to include mySQL ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: connect to mySQL
    ... There are a few .net providers that you can use for MySql. ... > How can I directlly connect to mySQL server from C# without an ODBC ... connecting through ODBC means I have to include mySQL ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: ODBC logging via ISS Internet Scanner
    ... Here is a synopsis of the situation: I want ISS ... I have a ODBC connection to this MySQL ... > Check out Yahoo! ...
    (Security-Basics)