KevPerkins
asked on
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.
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.
snoyes_jw
Make sure it's the right port too.
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.
The article I wrote at http://www.vbmysql.com/articles/security/sshtunnel.html#part5 could be used to help get around the firewall.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.