Remote connection attempt locks up Delphi

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tjn006
Posts: 10
Joined: Tue 06 Mar 2012 16:48

Remote connection attempt locks up Delphi

Post by tjn006 » Fri 07 Sep 2012 00:20

Hello!

I am trying to connect to a remote database. I have tried to follow the instructions but I am confused with where to put what. I have a jpg file with a screen capture of the settings I can send to anyone who is interested with the detailed info.

Here are the settings:

The URL is: https://173.199.145.60

Host Name: Host.Homeschooldiploma.com
Database name : homescho_ultimate

When I use these settings and put in my password, Delphi Locks Up. I don't get any error message. I have to kill Delphi from the Task manager to continue.

Please help me fill in the blanks...:-)

Thanks in advance!

Tom Nesler

AndreyZ

Re: Remote connection attempt locks up Delphi

Post by AndreyZ » Fri 07 Sep 2012 08:08

Hello,

It is impossible to connect to the 173.199.145.60 server directly, your server does not allow this (maybe your firewall blocks connections to MySQL server). Also, check the exact port that your MySQL server listens to, maybe you are trying to use a port that MySQL doesn't listen to.
I have checked that your server allows HTTP connections to the 80 port, so you can use HTTP tunneling to connect to it. For this, you need to deploy the tunnel.php script (that is supplied with MyDAC) to your server. The tunnel.php script allows access to the database server to use HTTP tunneling. The script must be available through the HTTP protocol. You can verify if it is accessible with a web browser. For more information, please read the "Network Tunneling" article in the MyDAC documentation.

Post Reply