How do you fix this error: MySQL ODBC Access denied for user 'ODBC'@'localhost'?

I had used .mdb for my ASP applications. Since I've learned and used php, I, now, want to use ASP applications with MySql databases. However, I get some errors that I cannot figure out.

This is my code:

set conn=server.createobject("ADODB.Co开发者_开发知识库nnection")
bag="DRIVER={MySQL ODBC 3.51 Driver};UIN=aksar_isilak;PWD=741285;SERVER=localhost;DATABASE=aksarayf_isilak;OPTION=3"
conn.open bag

And when I execute it, I get this error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: YES)

C:\INETPUB\VHOSTS\ISILAK.COM\HTTPDOCS\YONETIM\../vt.asp, line 6

This is not my server, it is an hosting, I can create some ODBC connection on plesk panel, just you to know.

Thanks for any help.

Try the recommended connection string format; http://connectionstrings.com/mysql#p30 which uses username/password rather than UIN?/PWD.

Are you sure it's the correct password? Also maybe check permissions of user trying to access the specific database.

UID=user is the normal ODBC attribute, not UIN=user

Maybe your are not passing the right parameter because the message says you're trying to connect using the user "ODBC".

'localhost' is ok since you're running the app in the same server.