Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to a remote mysql server

Status
Not open for further replies.

RedCoder

Programmer
Jun 16, 2006
2
TR
How can I connect to a remote MySql server by entering the IP of remote system in runtime?
 
If you use a native MySQL C/C++ interface, you specify the host address at connection time. If you're using ODBC, then it's probably a matter of setting a registry value before connecting. If you're using a C++Builder component, then there would be a property you could set before connecting.
 
Thanks for your help. But let me explain in more detail.
I'm using Borland C++ and MySQL 5.0 server + ODBC Connector 3.51. ODBC has an alias of localhost. The host information is saved at that alias. When I connect to MYSQL server on localhost, I use that alias and enter no IP (Unfortunately). I can't even change the host information during design time in Borland. I'm trying to connect that server by entering the IP address of MySQL server on a remote computer. I think the solutions are limited and one of that is creating a new alias from C++(I dunno HOW?) and the second one is building a client-server application and connecting to the MySQL server directly from the server-side of my application but again I dunno HOW? Can you please help me in this case now? Thanks for your read...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top