MySQL Connection

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
marnowak
Posts: 1
Joined: Fri 26 Mar 2010 10:15

MySQL Connection

Post by marnowak » Fri 26 Mar 2010 11:27

Hi All!

I've an embrassing question. I want to use MyConnection from MySQL Access Tab in C+ Builder 6. It's all works when I want to connect to database locally. Is thera any way to connect to MySQL Database from local computer to database on server? What should I write into server box to connect to database on server? I know that in PHP when I try to connect to server with webpage hosted locally- it can't be done. The parameters from hosting can be used in PHP hosted on that server. If I have from there server access like this:mysql.cba.pl what should I add before to that in order to MyConnection know that is not hosted locally but on a server.
The problem is that I want to have a webpage on server and I want to create an application to my computer, which will connect to database on server and do operations on it. I want to communicate my webpage on server with my application on local computer through MySQL.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 26 Mar 2010 12:58

To solve the problem you should set the TMyConnection.Server property to host with MySQL database.
Also you can use HTTP tunneling. You can find detailed information about it in the "Network Tunneling" topic of MyDAC Help.

Post Reply