path to db problem

I'm having a problem getting the path to a database to work correctly.

In order for a DB to be updatable, my WPP has created a DB folder on my site that is write enabled. The virtual path to the directory is silvestri/DB. However, the program itself is located below the WWWROOT directory. (We're on a Win 2003 server).

I can't seem to get the path to the db file correct. If I put the db file into the db folder I can't set the path to it in the Common.asp file. Here's what the line looks like in the Common.asp file:

strDataBasePath = ""&strDBpathCorrection&"LiveSupport.mdb"

However, if I move LiveSupport.mdb to the DB directory and change the path to the db to

strDataBasePath = ""&strDBpathCorrection&"/db/LiveSupport.mdb",

I get an error in the browser that says:

'c:\inetpub\virtual\silvestri\WWWROOT\db\LiveSupport.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/chat/common.asp, line 159

Here are the locations of the relative files & folders.

The virtual path to my DB directory is: silvestri/DB. The Physical path is: C:\inetpub\virtual\silvestri\DB.

The virtual path to the program is:
silvestri/chat.

The physical path is:
C:\inetpub\virtual\silvestri\WWWROOT\chat.

I appreciate your help.

Mike Keeney

TYSON wrote: Try Removing Server.Mappath() from the connection string and use your physical path instead.

That's exactly what I was thinking too even though the original question didn't actually say it was using Server.MapPath().