Professional Web Applications Themes

asp.net ms-access oledb connection open error - ASP.NET General

Hi. I have an application that after using it for a while, continually forcing it to hit the database it will fail on connection open with the OLEDB "Unspecified Error" message. [OleDbException (0x80004005): Unspecified error] System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvid er() +57 System.Data.OleDb.OleDbConnection.Open() +203 I explicitly close all connections to the database when the page has finished executing. Has anyone come across this? How do I handle this? Thanks....

  1. #1

    Default asp.net ms-access oledb connection open error

    Hi.

    I have an application that after using it for a while,
    continually forcing it to hit the database it will fail on
    connection open with the OLEDB "Unspecified Error" message.

    [OleDbException (0x80004005): Unspecified error]
    System.Data.OleDb.OleDbConnection.ProcessResults(I nt32
    hr) +20
    System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
    System.Data.OleDb.OleDbConnection.Open() +203


    I explicitly close all connections to the database when the
    page has finished executing.

    Has anyone come across this?

    How do I handle this?

    Thanks.
    Mathew Guest

  2. #2

    Default Re: asp.net ms-access oledb connection open error

    The first thing I would check is the possiblity that you've exceeded the
    maximum number of concurrent connections for your Access database. If I knew
    the version, I could tell you what that number is, but you can look it up
    for yourself as well. Access is not designed for Internet use. It doesn't
    support a large number of concurrent connections.

    --
    HTH,

    Kevin Spencer
    Microsoft MVP
    ..Net Developer
    http://www.takempis.com
    Neither a follower nor a lender be.

    "Mathew Vording" <com> wrote in message
    news:008d01c3633c$2d29fd60$gbl... 


    Kevin Guest

  3. #3

    Default Re: asp.net ms-access oledb connection open error

    Hi:

    This is during testing of the application with only myself
    submitting requests. Some pages have multiple
    frames/iframes though.

    Is it possible this is a memory garbage collection issue?

    Or would it be better to just use the MSDE for this instead
    of Access (this app is aimed at only a few users)?
     
    you've exceeded the 
    database. If I knew 
    can look it up 
    use. It doesn't 

    Mathew Guest

Similar Threads

  1. Error while using OLEDB (Jet) for Access within ASP
    By Terry Murray in forum ASP Database
    Replies: 19
    Last Post: December 12th, 06:50 PM
  2. Replies: 18
    Last Post: December 12th, 01:43 AM
  3. Replies: 6
    Last Post: July 22nd, 01:40 PM
  4. Connection string - ODBC vs OLEDB and Unspecified Error
    By David R. Wheeler in forum Macromedia Dreamweaver
    Replies: 3
    Last Post: July 21st, 03:33 PM
  5. Error 711 and Error 5, Remote access connection manager service
    By Greenlee in forum Windows Networking
    Replies: 0
    Last Post: July 4th, 06:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139