Help! Getting DB error 80004005.

Results 1 to 3 of 3

Thread: Help! Getting DB error 80004005.

  1. #1
    Lbodie Guest

    Default Help! Getting DB error 80004005.

    The error below is generated when I execute my SELECT. If I make the SELECT simple like "SELECT * FROM imageinfo" it will read several records and then display the same error on my MoveNext. If I make the SELECT complex like "SELECT * FROM imageinfo WHERE CustomerName LIKE &#039;"&custname&"&#039; OR bla bla bla" it returns the error below. The db is Access 2000. Anyone seen this before?<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Unrecognized database format &#039;D:Inetpubftprootkelsanpod.mdb&#039;. <BR><BR>/pod.asp, line 17 <BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Help! Getting DB error 80004005.

    Whats your connection string and recordset code look like??

  3. #3
    Lbodie Guest

    Default RE: Help! Getting DB error 80004005.

    set db=server.CreateObject("ADODB.Connection")<BR> db.Open "POD"<BR> if Err.number &#060;&#062; 0 or Len(Err.Description) &#060;&#062; 0 then<BR> Response.Write("Database error: " & Err.number & " Desc: " & Err.Description)<BR> end if<BR> <BR> custnum=trim(request("custnum"))<BR> custname=trim(request("custname"))<BR> invnum=trim(request("invnum"))<BR> <BR> set rsLogin = server.CreateObject("ADODB.Recordset")<BR> &#039;sCust_ID=CustomerNumber AND (this is a session var I was attempting to add to the select)<BR> &#039;WHERE (CustomerNumber=&#039;" & custnum & "&#039; OR CustomerName LIKE &#039;" & custname & "&#039; OR InvoiceNumber LIKE &#039;" & invnum & "&#039;) (this is the complex part of the SELECT)<BR>ORDER BY InvoiceNumber <BR> strSql = "SELECT * FROM imageinfo "<BR> rsLogin.Open strSql, db, 1,3

Posting Permissions

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