Microsoft Jet 4.0 OLE DB Provider Nightmare

Results 1 to 2 of 2

Thread: Microsoft Jet 4.0 OLE DB Provider Nightmare

  1. #1
    LostInSpace Guest

    Default Microsoft Jet 4.0 OLE DB Provider Nightmare

    Whats happening to my ASP?<BR><BR>One one page I have three calls to the database, using Jet 4.0 OLE DB. The first two work just fine, the third gets caught up and says only "error &#039;80004005&#039;". Its getting caught on the line: rs.Open SQL, Conn<BR><BR>It used to work OK using DSN file and ODBC. Is there some change in the SQL that is needed??<BR><BR>The SQL statment (in this example) is;<BR>SQL = "SELECT Code, Description, Colour, Size, UnitPrice FROM Products WHERE (SubCategory = &#039;" & ListCat(co) & "&#039;) ORDER BY Code"<BR><BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default Could be anything...

    What is the error you are getting? I don&#039;t have the numbers memorized, so refresh my memory on what error 80004005 is, also you may want to look into using a provider instead of a jet statement... like this...<BR><BR>con_bd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("db.mdb")<BR><BR>IT gives better detailed errors and is generally less error prone...<BR><BR>-- Whol

Posting Permissions

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