Problems conecting ASP pages with mysql in another server

[vanunes]

I was developing using my IIS and mysql server in the same machine.

Now that i want to transport everything to the production server i am having some problems...

My connetion string was:
ObjConn.ConnectionString = "DRIVER={MySQL ODBC 3.51 DRIVER}; SERVER=127.0.0.1;DATABASE=proc;" and it worked fine.

Now that I have de mysql in another server I tried this:
ObjConn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=banco.uniriotec.br;DATABASE=proc;UID=vanessa;PWD=password; OPTION=3"

And the following problem occurs:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Access denied for user: 'vanessa@200.143.194.59' (Using password: YES)

People who created the database for me, may have forgotten to give some kind of access?

Please, someone help me!

[andrevr]

Hi.

You haven't said, but if the the MySQL on the new server is a later version, there could be an issue with the way passwords are stored. The new server comes with an update script which will store the password with the correct encoding. I ran into this issue just on a local machine... Took a careful read of the online documentation to sort out.