MySQL Connection

[Roger Cantillo]

Hi:
I'm trying to make a connection to a MySQL database, but I keep getting this
error:

System.ArgumentException: Keyword not supported: 'provider'.

This is the code that fails:

objConn = New SqlConnection("Provider=MSDASQL; DRIVER={MySQL ODBC 3.51
Driver}; Server=localhost; UID=root; PWD=; database=helloworld;
Option=16387;PORT=3306;STMT=;")

Any ideas?


Roger

 

[Richard K Bethell]

Hi:
I'm trying to make a connection to a MySQL database, but I keep getting this
error:

System.ArgumentException: Keyword not supported: 'provider'.

This is the code that fails:

objConn = New SqlConnection("Provider=MSDASQL; DRIVER={MySQL ODBC 3.51
Driver}; Server=localhost; UID=root; PWD=; database=helloworld;
Option=16387;PORT=3306;STMT=;")

Any ideas?

Many problems here:

1. You can't use the SqlConnection object to connect to an ODBC database.
That object is a SQL Server specific object and can only be used to go to a
SQL Server database.
2. You can't use the ODBC driver directly as an OleDb provider. There is an
OleDb driver for MySQL - you need that, or the native .NET driver.

http://www.mysql.com/articles/dotnet/

R.

 

[Armin Zingler]

Hi:
I'm trying to make a connection to a MySQL database, but I keep
getting this error:

System.ArgumentException: Keyword not supported: 'provider'.

This is the code that fails:

objConn = New SqlConnection("Provider=MSDASQL; DRIVER={MySQL ODBC
3.51 Driver}; Server=localhost; UID=root; PWD=;
database=helloworld; Option=16387;PORT=3306;STMT=;")

Use an OleDBConnection instead.

See also: http://www.connectionstrings.com/

Group for ADO.NET related questions:
microsoft.public.dotnet.framework.adonet

 

[Eric Sabine]

Richard helped you already, but I thought I'd pass on this link.

http://www.connectionstrings.com

hth
Eric

 

[Brian Henry]

sqlconnection is for MS-SQL Server only... use OleDB connection

 

[Herfried K. Wagner [MVP]]

I'm trying to make a connection to a MySQL database, but I keep getting this
error:

System.ArgumentException: Keyword not supported: 'provider'.

This is the code that fails:

objConn = New SqlConnection("Provider=MSDASQL; DRIVER={MySQL ODBC 3.51
Driver}; Server=localhost; UID=root; PWD=; database=helloworld;
Option=16387;PORT=3306;STMT=;")

Maybe it's really "not supported", but have a look at
<http://www.connectionstrings.com>. Maybe you want to use an other data
provider:

<http://www.mysql.com/articles/dotnet/#ADO.NET>

dbProvider
<http://www.einfodesigns.com/products.aspx>

MySQLNet
<http://sourceforge.net/projects/mysqlnet>

 

[Cor]

I tried that last link but there was very few about MySQL

MySQLNet
<http://sourceforge.net/projects/mysqlnet>
--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

Cor

 

[Herfried K. Wagner [MVP]]

I tried that last link but there was very few about MySQL

ACK, there is "only" a MySQL driver for ADO.NET available...

 

[Cor]

Hi Herfried,

That last link was

Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

) and I knew it was not there but it was so thight on the others that you
could think it was.

Cor

 

[Herfried K. Wagner [MVP]]

That last link was


) and I knew it was not there but it was so thight on the others that you
could think it was.

Oh, nice joke!