Database Connection strings in web.config

Discussion in 'ASP.NET / ASP.NET Core' started by Takeshi Eto, Sep 11, 2004.

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

    Takeshi Eto DiscountASP.NET Staff

    You can find the full server path in the Account Information of your control panel.

    DiscountASP.NET
    http://www.DiscountASP.NET
     
    Takeshi Eto, Sep 11, 2004
    #1
  2. infinitedes

    infinitedes

    I like to use web.config files for database connection strings
    However I'm not sure how to access my database on discountasp:

    Provider=Microsoft.Jet.OLEDB.4.0;Data source=D:\Inetpub\WWWroot\03Fall\hallo\database\MusicStore.mdb;
    </font id="limegreen">
    worked when my site was hosted on another server but I'm not sure
    </font id="brown">

    Owen
     
    infinitedes, Sep 11, 2004
    #2
  3. infinitedes

    infinitedes

    So let me get this straight the path would be like
    e:\web\infinitedes\htdocs\_database\MusicStore.mdb


    Owen
     
    infinitedes, Sep 15, 2004
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    if your database is in the _database directory.

    quote:Originally posted by infinitedes

    So let me get this straight the path would be like
    e:\web\infinitedes\htdocs\_database\MusicStore.mdb


    Owen
    </blockquote id="quote"></font id="quote">

    B.

    DiscountASP.NET
    http://www.DiscountASP.NET
     
    Bruce, Sep 15, 2004
    #4
  5. Bruce

    Bruce DiscountASP.NET Staff

    Add this line

    myConn.open

    after this

    myConn = New OleDbConnection (DSN)

    quote:Originally posted by infinitedes

    I got an error when I tried using the physical path as suggested:
    Here is the code to my configuration file to connect to the database
     
    Bruce, Sep 24, 2004
    #5
  6. infinitedes

    infinitedes

    I got an error when I tried using the physical path as suggested:
    Here is the code to my configuration file to connect to the database
     
    infinitedes, Sep 24, 2004
    #6
  7. infinitedes

    infinitedes

    OK that problem is fixed but now I have another problem:


    Unrecognized database format 'e:\web\infinitedes\htdocs\_database\MusicStore.mdb'.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.OleDb.OleDbException: Unrecognized database format 'e:\web\infinitedes\htdocs\_database\MusicStore.mdb'.

    Source Error:

     
    infinitedes, Sep 26, 2004
    #7
  8. Bruce

    Bruce DiscountASP.NET Staff

    2 possible problems associated with this error

    1) The database file is corrupted during upload (yes. this happens sometime with access).

    Try download the db back to your computer and try open it with Access

    2) The DB is created with an older version of MS Access.


    quote:Originally posted by infinitedes

    OK that problem is fixed but now I have another problem:


    Unrecognized database format 'e:\web\infinitedes\htdocs\_database\MusicStore.mdb'.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.OleDb.OleDbException: Unrecognized database format 'e:\web\infinitedes\htdocs\_database\MusicStore.mdb'.

    Source Error:

     
    Bruce, Sep 27, 2004
    #8
  9. Dillon

    Dillon

    Thank you very much for all you help I will try it. I post the outcome .

    Dillon.
     
    Dillon, May 10, 2008
    #9
  10. fyz

    fyz

    Hi, </o:p>
    </o:p>
    I had similiar problems several days ago, and it turned out to be my mdb file's corruption. Ifinally tired a utility called Advanced Access Repair to repair my Access MDB file. It works rather well for me.Hope this can help in the future.</o:p>
    </o:p>
    Alan</o:p>
     
    fyz, May 10, 2008
    #10
  11. phusit2008

    phusit2008

    phusit2008, Jul 12, 2008
    #11
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