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