MySQL Forums
Forum List  »  Connector/ODBC

VBSCRIPT execution gives the error [MySQL][ODBC 3.51 Driver]Access denied for user '[username]'@'%' to database 'databasename'
Posted by: pavan tasgfr
Date: August 29, 2013 04:17AM

I Have a VB script which will download the data from MYSQL server with version 5.6.
Previosuly it used work properly but when we upgraded from 5.5 to 5.6 it is giving the error.

When I am executing the vbscript it is giving the following error:

[MySQL][ODBC 3.51 Driver]Access denied for user '[username]'@'%' to database '[databasename]'.

The connection string i am using is as follows:

Conn.Open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=***.***.**.***;DATABASE=[databasename]; UID=[username];PASSWORD=[password]; OPTION=3"

I also used the drivers {MySQL ODBC 5.1 Driver} and {MySQL ODBC 5.2a Driver} instead of 3.51 but still it gives the error.
is there any connection string or driver issue.

Options: ReplyQuote


Subject
Written By
Posted
VBSCRIPT execution gives the error [MySQL][ODBC 3.51 Driver]Access denied for user '[username]'@'%' to database 'databasename'
August 29, 2013 04:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.