How do I configure connection string for Access DB for _database folder?

[crajan]

I have converted the personal web site starter kit to use the Access database.
My question is, in 2005, the database is kept in the App_Data folder, while on discountasp.net, the folder for your database should be "_database"...

I have not figured out a way to configure the connection string in web.config to point to the right place.
The default connection string is:




<add name="Personal" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|personal.mdb;" providerName="System.Data.OleDb"/>


<add name="PersonalAccessProvider" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|ASPNetDB.mdb" providerName="System.Data.OleDb"/>


and the |DataDirectory| points to App_Data.


I have not seen a way in 2005 to use Server.Mappath, or any other explicit way to code the path for the custom location.


Has anyone come accross this? And how do you configure it?


I just want to configure the connection strings to point to the databases in the _database folder....

[bruce]

you can put your access DB in the App_data directory.

or

change the connection string to use full path to the database. You should be able to find the full path to your site root in the Account info / edit section.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[crajan]

Thanks!


I have actually not found a way to hardcode a full path to the database in web.config in 2005 - it keeps giving me errors, and perhaps I am missing something.


But using the App_Data folder will definitely do then, and should eliminate the need to change configurations (I hope...)