I wish to run a scheduled task on a windows 2003 that executes a query on a MySQL 5.0 every 30 minutes. This task should execute a VBScript. I cannot execute a scheduled task on the MySQL server, because this feature is not implemented in version 5.0.
Now, in this script, I have to create an ADODB connection - which is normally created like this:
Set Conn = CreateObject("ADODB.Connec
tion").
However , this results in the following error: Data source name not found and no default driver specified. Ok, so I rephrase the statement like this:
DbConnStr = "DRIVER={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306; Option=4210688; Database=trendsalesdk; Uid=root; Pwd=chucknorris"
Set Conn = CreateObject("ADODB.Connec
tion", DbConnStr)
And I get the error: The remote server machine does not exist or is unavailable - which makes no apparent sense, since the connectionstring is idententical to a connectionstring used in an ASP-application running on the exact same server. Exchanging the "localhost" with the actual IP of the server does not help.
What is wrong here?
Start Free Trial
