MySQL Provider Error

Hello all

Windows XP SP1

I'm trying to connect to a local MySQL database through VBScript (also tried JScript and ASP, same result)

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

Having the same problem with MySQL and VB6.
Found that everything works OK if using Office 2000 or XP. Problem only occurs with Office 97. Also, if you load Office 2000, then uninstall it and install Office 97 again, it still keeps working.
There must be something in Office 2000 or XP that allows the Provider to be recognized, and it stays there even if you unistall either 2000 or XP.
Do you have any new helpful information? It would be greatly appreciated. Also, if I figure it out, I'll let you know.