Can't connect to database

Databases
1

Hi everyone.
I have a connection to my database.If my database doesn’t require a password everything works well, the Connection is made.
This is my connection without password:
Conn.Open “Driver={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=Database;Uid=xxx;OPTION=3;”

Once I put a password to my username for my database it stops working.
This is my connection with password:
Conn.Open “Driver={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=Database;Uid=xxx;Pwd=xxx;OPTION=3;”

the error message I get is:
The connection cannot be used to perform this operation.It is either closed or invalid in this context.

Anyone has a clue how to fix this ?
Thanks!

2

What server-side language are you using?

3

I’m using classic ASP and MySQL

4

Are you able to connect to the database using the same username and password via the MySQL command line?

5

Yes I’m able to connect to mysql database with the MySQL command line.