MS Access DB Conn Strings

Discussion in 'Databases' started by white54503, Dec 14, 2005.

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

    white54503

    My website utilizes one Access database, queried from the rootsite (default.aspx) and an admin console in a subdirectory (/admin). The query strings that worked on my dev machine no longer properly query the database; instead the parser returns the error, ''c:\windows\system32\inetsrv\db\AspDotNetStorefront.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides,' this the same for both query from the admin subdirectory and the store root. What's form should my MS Access DB Conn strings take? The [email protected] people pointed me in the direction of a knowledge base article providing sample source code for the query, but I can't make heads or tails of it, and besides don't know what to do with it. Any help / suggestions enthusiastically appreciated.
     
    white54503, Dec 14, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    apparently, you got the path wrong.

    I am not sure how you specifed the path but you need to change it to point to the location of the database on the server. The path to the root can be found in the account information section in the control panel.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Dec 14, 2005
    #2
  3. joelnet

    joelnet

    It is recommened you use the Server.MapPath function. This should allow the same code to work under multiple configurations.


    Joel Thoms

    DiscountASP.NET
    http://www.DiscountASP.NET
     
    joelnet, Dec 14, 2005
    #3
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