Connect sql server remotly with ADO Delphi

Posted on 2009-05-01
Last Modified: 2013-11-23
I want to create an application which will connect to a remote sql server through Internet with adoconnection of Delphi. Is it possible?
Question by:kyriakos70
    LVL 22

    Accepted Solution

    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.
    LVL 21

    Assisted Solution

     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.
    LVL 22

    Assisted Solution

    ...and unchanging IP adress (which is a must essentially).
    LVL 22

    Assisted Solution

    Which means you must have Static IP adress.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Having clause with Case 2 30
    sql calculate reminders 11 52
    How to SUM hours for the same record 1 23
    find a node in VST 2 37
    Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now