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

Discussion in 'ASP.NET Starter Kits' started by crajan, Aug 16, 2006.

  1. crajan

    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....
     
    crajan, Aug 16, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    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
     
    Bruce, Aug 16, 2006
    #2
  3. crajan

    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...)
     
    crajan, Aug 16, 2006
    #3

Share This Page