How to path the application to an Access database

Discussion in 'Databases' started by mooddoc, Jan 31, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi,

    This is the first time I am trying to deploy this application outside my server.

    I created an application that uses an access database called democrm.mdb

    I use the following path using Data Source=e:\web\crm42com000\htdocs\democrm\DemoCRM.mdb;Jet OLEDB:Database Locking Mode=1;Mode=16' />

    I uploaded the application to DASP server and can approach it from the web just fine ( the first login page that is )
    When I try to enter my username and password I get an error like:
    'Unable to connect to database. Disk or network error.'

    The darabase is in my application folder ( called 'democrm' )

    I can't figure out how to point the application to use that databse.

    Here is the web.config part I think is the problem:
    add key='CookieEncryptionKey' value='3046E24D-9B7B-44D5-A74B-256A3AB4BBB0' />
    <add key='URLEncryptionKey' value='3046E24D-9B7B-44D5-A74B-256A3AB4BBB0' />
    <add key='DatabaseDemoCRM.mdb1' value='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\web\crm42com000\htdocs\democrm\DemoCRM.mdb;Jet OLEDB:Database Locking Mode=1;Mode=16' />
    <add key='DefaultPageUrl' value='Contacts/ShowContactsTablePage.aspx' />
    <add key='SignInPageUrl' value='Security/SignIn.aspx' />
    <add key='SignedOutPageUrl' value='Security/SignOut.aspx' />
    My guess is that the 'Data Source' syntax is not correct, but I have no idea what else to try

    HELP!!!!!!

    Post Edited (mooddoc) : 1/31/2009 7:07:52 PM GMT
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    many potential problems... I recommend reupload the database file and see if it works.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. did you get this resolved?if so how?
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page