Working with virtual directories 1

[SH4F33]

Hello.
I've been having problems locating the path of 2 virtual directories. I have a virtual directory called stock, my asp pages reside in this folder, and in this virtual directory, I have a folder called database and my access database is in there. I have another virtual directory called MoreData and there's another database in thet virtual directory. So how can I obtain the path of these databases for my connection string. I'm not working with DSN.
Thanks.

 

[DotNetGnat]

you have to use something like this...

Server.MapPath("yourdatabase.mdb")

look at this link for more connection strings...

http://www.connectionstrings.com

-DNG

 

[DotNetGnat]

so your connection string look something like this:

Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("yourdatabase.mdb")

-DNG

 

[SH4F33]

Ure da man
Thanks

 

[DotNetGnat]

great...glad to be of help...

-DNG