Remote connection

[SpookyDescendant]

Hi,

could someone help me? I don't understand how to make remote connection to database server?

[Banfa]

We will need more infomation about the platform and the database server to be able to help.

[radhakrishna]

if u want to access remore database then just u have to write database link query to that remote database.

[SpookyDescendant]

I use ADO components to connect to a local database. And it works well.
Now I want to connect to a remote database server (MS SQL Server 2000). So should I use ADOConnection in the same manner as to the local connection? Or maybe should I configure something?

[Banfa]

Do you mean DAO? Assuming that you do my understanding of DAO is that you open an mdb file. It does not matter if that file is local or on a remote server, just put in the path name to the file.

\\ServerName\\p ath\\File.mdb

You may need to set up a DSN (data Source name) in the ODBC section of Control Panel and use it.