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?