vb mySQL connection problems in windows xp

[nadaness]

Hello everyone,

Currently I am working on an application in vb 6(in windows xp) that needs to update a mysql database on the same computer. With the previous build of mySQL, there were no problems connecting to the database. Now however, with the current build I have run into a snag.

If I create a user account with a password, my vb app cannot connect using that account. In fact the error message is that it cannot even find a mysql database on the computer.

If I create a user account that does not have a password, then my app can connect and update the database correctly.

More interesting notes:
--mySQLAdmin connects fine.
--I can open up a command line and connect to the database with an account that has a password, as well as one that does not.
--I am currently using the wrapper class found in this website at http://www.freevbcode.com/ShowCode.asp?ID=6366

Since the database is only going to run on a single computer, in a closed network, I can continue without having the password, but it would be better if I could fix this problem.

Thanks for your help in advance.

[ReportMan]

Hello

Can you post the connection string that you are using in the VB application?

[jiml001]

newer versions of MYSQL use longer password encryption. See

http://dev.mysql.com/doc/mysql/en/old-client.html