Hi,
I really need some help accessing mysql in vbscript (I’m trying to automate tasks by adding script to scheduled tasks).
I’ve searched the Internet for days but could not find the solution.
My connection string is as follows:
Set objConnect = CreateObject(“ADODB.Connection”)
ConnectionString=“DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; PORT=3306; DATABASE=database_name; OPTION=3”
objConnect.Open ConnectionString, “username”, “password”
When I execute the script I get “provider is not specified” error. I tried various combinations of the connection string (for example using odbc 5.1 driver) but still have the same error. I tried to set Provide=mysqlprov but then I get “provider is not found” error.
I downloaded mysql drivers and added to ODBC Data Sources on my server with the name “mydatabase” (when I test it there, it works).
So I change the connection string to “DSN=mydatabase;” but still get “provider is not specified” error.
Please help, I don’t know what else to do.
By the way, the following ASP script works (the only difference is the word Server before CreateObject):
Set objConnect = Server.CreateObject(“ADODB.Connection”)
ConnectionString=“DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; PORT=3306; DATABASE=database_name; OPTION=3”
objConnect.Open ConnectionString, “username”, “password”