Unspecified 80004005

Results 1 to 2 of 2

Thread: Unspecified 80004005

  1. #1
    Shane Guest

    Default Unspecified 80004005

    I&#039m receiving an unspecified provider error when running the following code. This only happens when trying to run it more than once consecutively (ie in consecutive ASP scripts.) I&#039d appreciate any help anyone can offer.<BR><BR>strFilename = Server.MapPath("../cgi-bin/exchange.mdb")<BR>set conn = Server.CreateObject("ADODB.Connection")<BR>conn.Op en "DBQ=" & strFilename & ";DRIVER={Microsoft Access Driver (*.mdb)};"

  2. #2
    Join Date
    Dec 1969

    Default RE: Unspecified 80004005

    I see this error on my web site too. Its a concurrency problem with Access. I don&#039t know the answers to this one. My suspiction is to use one connection per page and have muliple recordsets using the same connection. In my case the web site is small with max records of 400 and my commands return fewer than 20 rows on any particular query. I would suggest going with the Microsoft OleDB Jet4.0 as your provider. Its supposed to deliver better performance. In the end, we should both get on SQL Server.

Posting Permissions

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