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

Accessing a Database Remotely Via a VPN Connection

I need to be able to access a database that resides on a remote machine. I have already successfully set up a VPN connection on my machine, which is fully functional.

How do I go about connecting, programmatically to the remote database? I am hoping that a simple modification to the ConnectionString would do the trick. So in the following snippet:

conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source=C:\Test\Data\Users.mdb";

I would change the code following the Data source to reflect the full path informtion for the remote database. Is this correct? What would a proper connection string look like?

Thanks!

- nhc
0
nh_capricorn
Asked:
nh_capricorn
1 Solution
 
cookreCommented:
I'd use MapDrive() then just use that drive letter in the connection string.
0
 
gregoryyoungCommented:
Access databases have some issues working over networks ... you could either map the drive or use a full path "\\machine\directory\file.mdb"

if you are going to be running JET over the network I would recommend looking at a few alternatives

1) use remoting to provide a central data broker (i.e. only one macine connects to the database and proxies the data through remoting to the clients) this would also add the benefit of not needing to be able to access the drive where the database lives to access data (i.e. you could put it on the internet etc without opening a huge security hole)
2) use MSDE as its free and much morre stable.

0
 
nh_capricornAuthor Commented:
Thanks everyone!

I need to consider both suggestions before I make a final decision. Once that's done, I'll award the points accordingy.

- nhc
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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