DNS's,  MySQL and remote database access

Posted on 2004-12-01
Last Modified: 2008-02-07
I am currently setting up a database driven website and am trying out some new software to quicken my development time. The software is called dbQwiksite (

The hosting provider uses phpMyadmin and access to the database is remote

Although the database is a MySQL database, dbQwiksite requires that I set up a DSN (usually not required for MySQL and php).
Naturally when setting up a DSN, I cannot stipulate “localhost” otherwise it simply looks on my machine for the database. I therefore asked for the IP address.

The IP address I used was

When I try to test the connection, I get the following error:

[MySQL][ODBC 3.51 Driver] can’t connect to MySQL server on ‘’ (10060)

Please advise what can be done to enable me to connect properly.
Question by:KevPerkins
    LVL 33

    Expert Comment

    Make sure it's the right port too.
    LVL 17

    Expert Comment

    If your database is behind a firewall you may be blocked, and would get that error.

    The article I wrote at could be used to help get around the firewall.
    LVL 17

    Accepted Solution


    Author Comment


    I think this firewall issue is going to cause more problems than I expected. I'm going to just develop without the DSN and then just paste the code into the site and confirfure the connections from there.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now