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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
ClausMoeller
Posts: 2
Joined: Sun 01 Mar 2009 08:26

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

Post by 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?

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

Post by 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.

ClausMoeller
Posts: 2
Joined: Sun 01 Mar 2009 08:26

Post by 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?

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

Post by 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.

Post Reply