By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,401 Members | 803 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,401 IT Pros & Developers. It's quick & easy.

Remote connection

P: 6
Hi,

could someone help me? I don't understand how to make remote connection to database server?
Sep 19 '06 #1
Share this Question
Share on Google+
4 Replies


Banfa
Expert Mod 5K+
P: 8,916
We will need more infomation about the platform and the database server to be able to help.
Sep 19 '06 #2

P: 3
if u want to access remore database then just u have to write database link query to that remote database.
Sep 20 '06 #3

P: 6
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?
Sep 20 '06 #4

Banfa
Expert Mod 5K+
P: 8,916
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\\path\\File.mdb

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

Post your reply

Sign in to post your reply or Sign up for a free account.