Provider cannot be found error

[Peak]

Hello all

Windows XP SP1

I'm trying to connect to a local MySQL database through ASP (VBScript, also
tried JScript, same result). IIS is on the same machine.

connect = Server.CreateObject("ADODB.Connection");
connect.Open("Provider=MySQL; Data Source=localhost; Initial Catalog=test;
User ID=root");

I get "Provider cannot be found. It may not be properly installed".
Yet I can successfully connect to the database through sqlyog, Data Sources
(ODBC) and winmysqladmin.

Also tried different names for Provider both with and without the "{}", same
result. The DSN is set to "MySQL" in Data Sources (ODBC)

Any clues?
--
Regards
Peter Akerstrom
Network & Communication

[Ray at]

Take a look at the sample OLEDB connection string for MySQL here.
[url]http://www.connectionstrings.com/[/url] Yours is different from that, although I
cannot say that that means yours is wrong, but it is worth looking at and
trying. Also, did you install the MySQL OLEDB drivers (which I assume
exist)? Those other tools you're talking about may use ODBC.

Ray at work

"Peak" <peak.delete.this@europe.com> wrote in message
news:%CjGb.26$zf2.81@news1.global-one.fi...

> Hello all
>
> Windows XP SP1
>
> I'm trying to connect to a local MySQL database through ASP (VBScript,

also

> tried JScript, same result). IIS is on the same machine.
>
> connect = Server.CreateObject("ADODB.Connection");
> connect.Open("Provider=MySQL; Data Source=localhost; Initial Catalog=test;
> User ID=root");
>
> I get "Provider cannot be found. It may not be properly installed".
> Yet I can successfully connect to the database through sqlyog, Data

Sources

> (ODBC) and winmysqladmin.
>
> Also tried different names for Provider both with and without the "{}",

same

> result. The DSN is set to "MySQL" in Data Sources (ODBC)
>
> Any clues?
> --
> Regards
> Peter Akerstrom
> Network & Communication
>
>

[Foo Man Chew]

Once I installed MyOLEDB from [url]http://www.mysql.com/downloads[/url] I can
successfully use this connection string:

conn.open
"Provider=MySQLProv;Server=SQLBOX;Database=test;ui d=root;pwd=;port=3306"




"Peak" <peak.delete.this@europe.com> wrote in message
news:%CjGb.26$zf2.81@news1.global-one.fi...

> Hello all
>
> Windows XP SP1
>
> I'm trying to connect to a local MySQL database through ASP (VBScript,

also

> tried JScript, same result). IIS is on the same machine.
>
> connect = Server.CreateObject("ADODB.Connection");
> connect.Open("Provider=MySQL; Data Source=localhost; Initial Catalog=test;
> User ID=root");
>
> I get "Provider cannot be found. It may not be properly installed".
> Yet I can successfully connect to the database through sqlyog, Data

Sources

> (ODBC) and winmysqladmin.
>
> Also tried different names for Provider both with and without the "{}",

same

> result. The DSN is set to "MySQL" in Data Sources (ODBC)
>
> Any clues?
> --
> Regards
> Peter Akerstrom
> Network & Communication
>
>

[Peak]

Thanks Foo Man Chew, finally it works!
/Peter

"Foo Man Chew" <foo@man.chew> wrote in message
news:uONkMipyDHA.1272@TK2MSFTNGP12.phx.gbl...

> Once I installed MyOLEDB from [url]http://www.mysql.com/downloads[/url] I can
> successfully use this connection string:
>
> conn.open
> "Provider=MySQLProv;Server=SQLBOX;Database=test;ui d=root;pwd=;port=3306"
>
>
>
>
> "Peak" <peak.delete.this@europe.com> wrote in message
> news:%CjGb.26$zf2.81@news1.global-one.fi...

> > Hello all
> >
> > Windows XP SP1
> >
> > I'm trying to connect to a local MySQL database through ASP (VBScript,

> also

> > tried JScript, same result). IIS is on the same machine.
> >
> > connect = Server.CreateObject("ADODB.Connection");
> > connect.Open("Provider=MySQL; Data Source=localhost; Initial

Catalog=test;

> > User ID=root");
> >
> > I get "Provider cannot be found. It may not be properly installed".
> > Yet I can successfully connect to the database through sqlyog, Data

> Sources

> > (ODBC) and winmysqladmin.
> >
> > Also tried different names for Provider both with and without the "{}",

> same

> > result. The DSN is set to "MySQL" in Data Sources (ODBC)
> >
> > Any clues?
> > --
> > Regards
> > Peter Akerstrom
> > Network & Communication
> >
> >

>
>