Operation Manual

516
USING DREAMWEAVER
Preparing to build dynamic sites
Last updated 3/28/2012
Find a file’s physical path with the virtual path
If you work with an ISP, you don’t always know the physical path to the files you upload. ISPs typically provide you
with an FTP host, possibly a host directory, and a login name and password. ISPs also specify a URL to view your pages
on the Internet, such as www.plutoserve.com/jsmith/.
If you know the URL, then you can get the file’s virtual path—it’s the path that follows the server or domain name in
a URL. Once you know the virtual path, you can get the file’s physical path on the server using the
MapPath method.
The MapPath method takes the virtual path as an argument and returns the file’s physical path and filename. Here’s
the method’s syntax:
Server.MapPath("/virtualpath")
If a file’s virtual path is /jsmith/index.htm, then the following expression returns its physical path:
Server.MapPath("/jsmith/index.htm")
You can experiment with the MapPath method as follows.
1 Open an ASP page in Dreamweaver and switch to Code view (View > Code).
2 Enter the following expression in the page’s HTML code.
<%Response.Write(stringvariable)%>
3 Use the MapPath method to obtain a value for the stringvariable argument.
Here’s an example:
<% Response.Write(Server.MapPath("/jsmith/index.htm")) %>
4 Switch to Live view (View > Live View) to view the page.
The page displays the physical path of the file on the application server, for example:
c:\Inetpub\wwwroot\accounts\users\jsmith\index.htm
For more information on the MapPath method, consult the online documentation that comes with Microsoft IIS.
Use a virtual path to connect to a database
To write a DSN-less connection string to a database file located on a remote server, you must know the physical path
to the file. The following example is a typical DSN-less connection string for a Microsoft Access database:
Driver={Microsoft Access Driver (*.mdb)};
DBQ=c:\Inetpub\wwwroot\accounts\users\jsmith\data\statistics.mdb
If you don’t know the physical path of your files on the remote server, you can get the path by using the MapPath
method in your connection string.
1 Upload the database file to the remote server and make a note of its virtual path—for example,
/jsmith/data/statistics.mdb.
2 Open an ASP page in Dreamweaver, then open the Databases panel (Window > Databases).
3 Click the Plus (+) button on the panel and select Custom Connection String from the menu.
4 Enter a name for the new connection, without spaces or special characters.
5 Enter the connection string and use the MapPath method to supply the DBQ parameter.
Suppose that the virtual path to your Microsoft Access database is /jsmith/data/statistics.mdb; the connection string
can be expressed as follows if you use VBScript as your scripting language: