• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1012
  • Last Modified:

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.
0
KevPerkins
Asked:
KevPerkins
  • 2
1 Solution
 
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
 
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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now