server.Mappath

Say i have something like this:

VB Code:

<connectionStrings>
        <add name="DBConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Inetpub\wwwroot\Prima\App_Data\DB.mdb"; providerName="System.Data.OleDb" />
</connectionStrings>

but i want to make it with relative path like this

VB Code:

<connectionStrings>
        <add name="DBConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=~\App_Data\DB.mdb"; providerName="System.Data.OleDb" />
</connectionStrings>

but when i replace the path with the tilda '~' i get an error (exception) "'C:\WINDOWS\system32\~\App_Data\DB.mdb' is not a valid path...."

Thanks for the help :)

VB Code:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.MapPath("\Prima\App_Data\DB.mdb") & "; providerName=System.Data.OleDb"

Well now i am getting warning msg from intellisense:

Missing attribute value on attribute 'server.MapPath'

VB Code:

<add name="DBConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source==" & server.MapPath("\Prima\App_Data\DB.mdb") & "; providerName="System.Data.OleDb" />

Tnx :)

Btw, i am using VB 2005 and web.config for the purpose (if it helps at all) :)

Sorry I goofed that up a little, use your original config settings, then do a replace on the tilde with the information I gave you.

And how finally it suppose to look like? I had a couple tries but none of them wasn't succefull. Thanks in advance :)

*bump*

Nobody knows that? hah ... lol :)
Whatever ... thanks for reading it.