vb mySQL connection problems in windows xp
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.
Can you post the connection string that you are using in the VB application?
Weirdo from another planet
newer versions of MYSQL use longer password encryption. See
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL