server.Mappath

[TaurusDotNET]

Say i have something like this:

<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

<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

[wild_bill]

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

[TaurusDotNET]

Well now i am getting warning msg from intellisense:

Missing attribute value on attribute 'server.MapPath'

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

Tnx

[TaurusDotNET]

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

[wild_bill]

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.

[TaurusDotNET]

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

[TaurusDotNET]

*bump*

[TaurusDotNET]

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