DNS's, MySQL and remote database access

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 (www.dbqwiksite.com).

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 196.30.15.153

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

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

Please advise what can be done to enable me to connect properly.
KevPerkinsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

snoyes_jwCommented:
Make sure it's the right port too.
0
SqueebeeCommented:
If your database is behind a firewall you may be blocked, and would get that error.

The article I wrote at http://www.vbmysql.com/articles/security/sshtunnel.html#part5 could be used to help get around the firewall.
0
SqueebeeCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
KevPerkinsAuthor Commented:
Thanks.

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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.