#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2002
    Location
    Malaysia
    Posts
    47
    Rep Power
    12

    Error In Connecting From VB To MySQL { Redhat }


    Hi there,

    I am actually trying to use a VB program (window) to connect to a MySQL database (linux).
    I had granted the permission for the mysql to allow connection from my PC but I still kept getting
    the same error message below.

    Tools that I had Used :
    -----------------------------
    1. Visual Basic 6
    2. MySQL 4.0.13
    3. MyODBC-3.51.06
    4. Linux Red Hat Advanced Server
    5. Window XP

    Steps that I had taken :
    ------------------------------
    1. Run the following command
    GRANT ALL ON *.* TO gilabean@192.168.0.100 IDENTIFIED BY 'gilabean'
    2. Try to connect by running the VB program.

    The funny thing is that I tried it on another server and it works perfectly fine but when I tried it
    on this server, it just couldn't connect to it and kept getting an error for that.

    I would be grateful if anyone can point to me where's my fault because I kept on getting the same error
    message when I tried to connect to the MySQL server on the particular IP.

    ***********************************************************************
    * Run Time error '-2147467259 (80004005)' *
    * [MYSQL][ODBC 3.51 Driver]Can't connect to MySQL server on '192.168.0.100' (10054) *
    ***********************************************************************


    Cheers,
    Żnut
  2. #2
  3. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    Question 1) You were able to connect to the mysql server on another machine, but not the one that you are currently trying from. Did you use the same program to try and connect with?
    Question 2) Can you see the server? i.e. can you ping it?
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2002
    Location
    Malaysia
    Posts
    47
    Rep Power
    12
    Hi onslaught,

    answer 1. Yep, I'm using the same program to connect. I just change the ip of the server. That's it.

    answer 2. Yeah, I can see the server and I can even ssh into it.

    Till now I still haven't get the answer why I can't connect to the live server. I don't even have any idea on what's wrong too~ LoL.


    cheers,
    Żnut
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    What is being logged in the MySQL error log? Are you granting wildcard access or are you host masking?

IMN logo majestic logo threadwatch logo seochat tools logo