• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 964
  • Last Modified:

Connect sql server remotly with ADO Delphi

Hello,
I want to create an application which will connect to a remote sql server through Internet with adoconnection of Delphi. Is it possible?
0
kyriakos70
Asked:
kyriakos70
  • 2
4 Solutions
 
8080_DiverCommented:
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.
0
 
developmentguruPresidentCommented:
 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.
0
 
senadCommented:
...and unchanging IP adress (which is a must essentially).
0
 
senadCommented:
Which means you must have Static IP adress.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now