Demo on how to connect to a MySQl server on the internet

Demo on how to connect to a MySQl server on the internet

Postby ClausMoeller » Sun 01 Mar 2009 08:41

I have downloaded a trial to see if the components can help us build a Delphi application with direct access to a MySql database on our internet homepage server.
It works fine on a local MySQl database on the PC. But I have not found out how to connect to a server on the internet. Is there a demo?
ClausMoeller
 
Posts: 2
Joined: Sun 01 Mar 2009 08:26

Postby Shalex » Mon 02 Mar 2009 07:59

Yes, you can connect to your MySql database through the Internet. You can do it either with the help of dotConnect for MySQL (managed code) or with MyDAC (unmanaged code). Using dotConnect for MySQL, you need to set a global IP address of your host where MySql server is placed, a port that is opened for MySql server connections, and a login information in the connection string of the MySqlConnection object. If you encounter any difficulties, please let us know.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Postby ClausMoeller » Thu 05 Mar 2009 20:22

Unfortunately the web-server provider has not opened for access except for via localhost. Do you have any ideas?
ClausMoeller
 
Posts: 2
Joined: Sun 01 Mar 2009 08:26

Postby Shalex » Fri 06 Mar 2009 08:26

Please refer to our article: http://www.devart.com/dotconnect/mysql/docs/?Using.html , the Network Tunneling section. Probably connection through HTTP tunnel will suit your needs.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL