View Single Post
  #2 (permalink)  
Old February 11th, 2004, 05:14 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,038, Level: 100
Points: 72,038, Level: 100 Points: 72,038, Level: 100 Points: 72,038, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,080
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

When you say Remote Server, are you referring to a machine in your network? If so, you can use a UNC path. e.g. \\MyMachine\MyShare\MyFile.mdb.

If your remote server is reached over FTP, you're in trouble ;) You can't really expect DW to understand a connection string that is supposed to run on another machine reached over FTP. In that case, I suggest you use a local connection string that points to a local database for development time. This allows you to test and use the database on your local machine. You can use a hardcoded path (e.g. C:\Databases\MyFile.mdb) or fake a path and use Server.MapPath to get the real path.

The advantage of the second method is that your local string could be the same as the remote string, so you don't have to change anything when you sync your site.
With a different local string, you have to make sure you are not accidentally overwriting the remote version.

You may want to check out this thread for more ideas.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote