Page 1 of 1

MySQL Connection

Posted: Fri 26 Mar 2010 11:27
by marnowak
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.

Posted: Fri 26 Mar 2010 12:58
by Dimon
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.