vb mySQL connection problems in windows xp


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: vb mySQL connection problems in windows xp

  1. #1
    Join Date
    Jul 2005
    Posts
    1

    vb mySQL connection problems in windows xp

    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.

  2. #2
    Join Date
    Jul 2005
    Posts
    10
    Hello

    Can you post the connection string that you are using in the VB application?
    Regards,
    ReportMan
    Weirdo from another planet

  3. #3
    Join Date
    Aug 2005
    Posts
    1
    newer versions of MYSQL use longer password encryption. See

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center