I am going to kill mysql

[Paul]

Hi

I did the following in an effort to connect to mysql using VB.net on a
windows XP pro machine.
I made reference to and used the import statement as follows :

Imports Microsoft.Data.Odbc

I then created my connection with the following :

Dim objConnection As New
OleDbConnection("driver={MySql};uid=root;pwd=;serv er=127.0.0.1;database=dbnr
gplc;OPTION=17923")

but I keep getting the folowing error :

An OLE DB Provider was not specified in the ConnectionString. An example
would be, 'Provider=SQLOLEDB;'.
Any ideas as to where I am going wrong ??

Thanks for the help so far.

[William F. Robertson, Jr.]

Create a file with the extension .udl. Try to open it. It will open with
the little "connection wizard" (I can't remember what the real name of it
is.) Set up all your connection information, test the connection, and save.

Then open the UDL file with notepad and that will be the connection string
to use.

HTH,

bill
"Paul" <paul@themedialounge.com> wrote in message
news:OFoB2$pWDHA.1812@TK2MSFTNGP11.phx.gbl...

> Hi
>
> I did the following in an effort to connect to mysql using VB.net on a
> windows XP pro machine.
> I made reference to and used the import statement as follows :
>
> Imports Microsoft.Data.Odbc
>
> I then created my connection with the following :
>
> Dim objConnection As New
>

OleDbConnection("driver={MySql};uid=root;pwd=;serv er=127.0.0.1;database=dbnr

> gplc;OPTION=17923")
>
> but I keep getting the folowing error :
>
> An OLE DB Provider was not specified in the ConnectionString. An example
> would be, 'Provider=SQLOLEDB;'.
> Any ideas as to where I am going wrong ??
>
> Thanks for the help so far.
>
>

[Alvin Bruney]

Mysql uses its own providers which are oledb. You need to set references to
bytefx and sharpziplib and then do the imports thing. That will make
namespaces available to your code. All of them start with MYSQL.... etc.

[url]http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#MySQLNETNativeProvider[/url]


"Paul" <paul@themedialounge.com> wrote in message
news:OFoB2$pWDHA.1812@TK2MSFTNGP11.phx.gbl...

> Hi
>
> I did the following in an effort to connect to mysql using VB.net on a
> windows XP pro machine.
> I made reference to and used the import statement as follows :
>
> Imports Microsoft.Data.Odbc
>
> I then created my connection with the following :
>
> Dim objConnection As New
>

OleDbConnection("driver={MySql};uid=root;pwd=;serv er=127.0.0.1;database=dbnr

> gplc;OPTION=17923")
>
> but I keep getting the folowing error :
>
> An OLE DB Provider was not specified in the ConnectionString. An example
> would be, 'Provider=SQLOLEDB;'.
> Any ideas as to where I am going wrong ??
>
> Thanks for the help so far.
>
>

[Kevin Spencer]

OLE DB and ODBC are 2 different technologies. You imported the Odbc library,
but used the Oledb library in your code. If you need to use ODBC, use the
ODBC library classes.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
[url]http://www.takempis.com[/url]
Complex things are made up of
lots of simple things.

"Paul" <paul@themedialounge.com> wrote in message
news:OFoB2$pWDHA.1812@TK2MSFTNGP11.phx.gbl...

> Hi
>
> I did the following in an effort to connect to mysql using VB.net on a
> windows XP pro machine.
> I made reference to and used the import statement as follows :
>
> Imports Microsoft.Data.Odbc
>
> I then created my connection with the following :
>
> Dim objConnection As New
>

OleDbConnection("driver={MySql};uid=root;pwd=;serv er=127.0.0.1;database=dbnr

> gplc;OPTION=17923")
>
> but I keep getting the folowing error :
>
> An OLE DB Provider was not specified in the ConnectionString. An example
> would be, 'Provider=SQLOLEDB;'.
> Any ideas as to where I am going wrong ??
>
> Thanks for the help so far.
>
>

[Paul]

Is there no way that I can connect to mysql using ODBC?


"Kevin Spencer" <kevin@takempis.com> wrote in message
news:exuqHiqWDHA.656@tk2msftngp13.phx.gbl...

> OLE DB and ODBC are 2 different technologies. You imported the Odbc

library,

> but used the Oledb library in your code. If you need to use ODBC, use the
> ODBC library classes.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> .Net Developer
> [url]http://www.takempis.com[/url]
> Complex things are made up of
> lots of simple things.
>
> "Paul" <paul@themedialounge.com> wrote in message
> news:OFoB2$pWDHA.1812@TK2MSFTNGP11.phx.gbl...

> > Hi
> >
> > I did the following in an effort to connect to mysql using VB.net on a
> > windows XP pro machine.
> > I made reference to and used the import statement as follows :
> >
> > Imports Microsoft.Data.Odbc
> >
> > I then created my connection with the following :
> >
> > Dim objConnection As New
> >

>

OleDbConnection("driver={MySql};uid=root;pwd=;serv er=127.0.0.1;database=dbnr

> > gplc;OPTION=17923")
> >
> > but I keep getting the folowing error :
> >
> > An OLE DB Provider was not specified in the ConnectionString. An example
> > would be, 'Provider=SQLOLEDB;'.
> > Any ideas as to where I am going wrong ??
> >
> > Thanks for the help so far.
> >
> >

>
>

[Kevin Spencer]

Of course there is. You just use the ODBC library classes
(System.Data.Odbc), not the OleDb (System.Data.Oledb) classes.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
[url]http://www.takempis.com[/url]
Complex things are made up of
lots of simple things.

"Paul" <paul@themedialounge.com> wrote in message
news:uuaTnMzWDHA.3404@tk2msftngp13.phx.gbl...

> Is there no way that I can connect to mysql using ODBC?
>
>
> "Kevin Spencer" <kevin@takempis.com> wrote in message
> news:exuqHiqWDHA.656@tk2msftngp13.phx.gbl...

> > OLE DB and ODBC are 2 different technologies. You imported the Odbc

> library,

> > but used the Oledb library in your code. If you need to use ODBC, use

the

> > ODBC library classes.
> >
> > --
> > HTH,
> >
> > Kevin Spencer
> > Microsoft MVP
> > .Net Developer
> > [url]http://www.takempis.com[/url]
> > Complex things are made up of
> > lots of simple things.
> >
> > "Paul" <paul@themedialounge.com> wrote in message
> > news:OFoB2$pWDHA.1812@TK2MSFTNGP11.phx.gbl...

> > > Hi
> > >
> > > I did the following in an effort to connect to mysql using VB.net on a
> > > windows XP pro machine.
> > > I made reference to and used the import statement as follows :
> > >
> > > Imports Microsoft.Data.Odbc
> > >
> > > I then created my connection with the following :
> > >
> > > Dim objConnection As New
> > >

> >

>

OleDbConnection("driver={MySql};uid=root;pwd=;serv er=127.0.0.1;database=dbnr

> > > gplc;OPTION=17923")
> > >
> > > but I keep getting the folowing error :
> > >
> > > An OLE DB Provider was not specified in the ConnectionString. An

example

> > > would be, 'Provider=SQLOLEDB;'.
> > > Any ideas as to where I am going wrong ??
> > >
> > > Thanks for the help so far.
> > >
> > >

> >
> >

>
>