Connect sql server remotly with ADO Delphi

I want to create an application which will connect to a remote sql server through Internet with adoconnection of Delphi. Is it possible?
Who is Participating?
You'll need to know the url path to the site and the user name and password to access the site and database.
I'm about to do this myself, in the next couplse of weeks, but essentially, the process is the same as accessing SQL Server over a corporate network.  The site should have a fixed IP address and you should be able to map a DSN to that site and to where the database is located.  Once you have done that, then you'll need to use that along with the rest of the ConnectionString data (including a user name and password) to access the database.
 I am doing this now.  The easiest way to do it is to have the remote system use a VPN to connect to the home site.  This way you can use the database just like you would if you were at the site.  The beauty of this approach is that it is secure and you do not need to do any custom programming.

  You must keep in mind that remote database access is limited by connection speed.
...and unchanging IP adress (which is a must essentially).
Which means you must have Static IP adress.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.