Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Posts
    2

    Unhappy Unanswered: Can't Connect to MySQL with ODBC Driver

    I've been trying to set up my own server as the development server on my own computer. The problem I'm having is that I cannot seem to connect to the database. I'm trying to connect my current computer to my database.

    Basically what I am saying is that the computer I am using will be the database and I want to connect to myself really. I'm am running on Windows XP (I know, but I'll change later after development) with IIS.

    If any other information is required, please feel free to ask me.

    Thanks for your help.

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: Can't Connect to MySQL with ODBC Driver

    Originally posted by Ralex
    I've been trying to set up my own server as the development server on my own computer. The problem I'm having is that I cannot seem to connect to the database. I'm trying to connect my current computer to my database.

    Basically what I am saying is that the computer I am using will be the database and I want to connect to myself really. I'm am running on Windows XP (I know, but I'll change later after development) with IIS.

    If any other information is required, please feel free to ask me.

    Thanks for your help.
    1-Try connecting directly with the mysql client

    See: http://www.mysql.com/doc/en/mysql.html

    2-Set up users and permissions if needed

    See: http://www.mysql.com/doc/en/Adding_users.html

    3-Test your users/permissions with step 2

    4-Once you can connect with the client, try via ODBC

    Hope this helps.

  3. #3
    Join Date
    Jun 2003
    Location
    New Hampshire
    Posts
    11

    Cool ODBC Driver

    Hi;

    Are you running MySQL on the local machine?
    Which version of MySQL are you running?
    Did you create some sample databases?
    If the database is on a remote machine, can you resolve it?
    It lives on port 3306 , is that port listening?

    I would like to help you out..

    Bartock

  4. #4
    Join Date
    Jun 2003
    Posts
    2
    1. Yes
    2. V3.23.56
    3. Yea, two test databases
    4. Can't resolve cuz it's on local machine
    5. How do I check if port 3306 is listening?


    Thanks, I appreciate your help.

  5. #5
    Join Date
    Jun 2003
    Location
    New Hampshire
    Posts
    11

    Cool MySQL fun

    1. Yes
    Good- that works
    2. V3.23.56
    Good build - no problems with that one.
    3. Yea, two test databases
    How did you create them? did you use the mysql> prompt?
    4. Can't resolve cuz it's on local machine
    Okay....running locally that makes things a little less complicated.
    5. How do I check if port 3306 is listening?

    Ecch....Windoze... ( I MUCH prefer UNIX, but you work with what you have right??)

    If you drop to a command prompt and type the following:

    netstat -an | more

    Scroll through ( enter -> line by line , spacebar -> page by page) until you see something along the lines of the following:


    TCP 127.0.0.1:3306 127.0.0.1:1694 ESTABLISHED

    let me know.

    Email me at brtok at yahoo dot com if you like .

    Cheers..

    G

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •