Virtual / Physical Paths...

[BucketManXL]

How can I change this virtual path to a physical path?

<%
Dim conn, ConnectString

ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("database/db.mdb") & ";Persist Security Info=False"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnectString
%>

[glenngv]

You are already doing it when you use Server.MapPath().

[BucketManXL]

I want to use E:\blah\blah

When I do, I get an error, and it says somthing about physical and virtual paths... I forget what it says

[oracleguy]

Originally posted by BucketManXL
How can I change this virtual path to a physical path?

<%
Dim conn, ConnectString

ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\blah\blah\db.mdb;Persist Security Info=False"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnectString
%>

Would be using a physical path.

[BucketManXL]

Excelente!

Thanks!

[whammy]

You're better off using a virtual path, however... just keep that in mind.

I tend to avoid using physical paths whenever possible!!!

If you have to change hard drives, etc. then you'll have to update the physical path, whereas you wouldn't have to with the virtual path, as long as the directory structure remains the same.

[glenngv]

You usually put your db folder, that contains the database, just above the web root directory. See discussion here (http://www.codingforums.com/showthread.php?s=&threadid=33092).

[d000hg]

My host has the structure:
|
--DB
|
--wwwRoot

But I can't use the path like ..\..\etc because it tells me I'm trying to get beyond the root. If I use the path like "d:\db\..." It tells me I must use a virtual path. How can I fix this please?