Unspecified Error

Results 1 to 2 of 2

Thread: Unspecified Error

  1. #1
    Kegsyb Guest

    Default Unspecified Error

    Select * FROM tblcontacts WHERE id=&#039 8&#039 <BR>Provider error &#039 80004005&#039 <BR><BR>Unspecified error <BR><BR>/private/resume.asp, line 32<BR><BR>I get this error the second time I run the code. I cannot figure it out. I am using a querystring to get info from a database and it works the first time it runs but not the second time the page loads.<BR><BR>Any Ideas?<BR>Thanks,<BR>Gregsby<BR><BR>P.S. Below is my code<BR><BR>&#060;% response.buffer = true %&#062;<BR>&#060;!--#include file="adovbs.inc"--&#062;<BR>&#060;%<BR> Dim sdb, sPath, sDSNDir, sDSNFil, sDefDir, sDSN, sScriptDir<BR><BR> &#039 This is the entire DB path - Physical with respect to root physical path <BR> sDB = "../db/exec.mdb" <BR> sScriptDir = Request.ServerVariables("SCRIPT_NAME")<BR> sScriptDir = StrReverse(sScriptDir)<BR> sScriptDir = Mid(sScriptDir, InStr(1, sScriptDir, "/"))<BR> sScriptDir = StrReverse(sScriptDir)<BR> <BR> &#039 Set the virtual Directory<BR> sPath = Server.MapPath(sScriptDir) & "\"<BR><BR> &#039 This is the DSN file Name for Access database<BR> sDSNFil = "Access.dsn"<BR><BR> &#039 This is the resulting DSN string<BR> sDSN = "filedsn=" & sPath & sDSNFil & ";DefaultDir=" & sPath & ";DBQ=" & sPath & sDB & ";"<BR><BR> &#039----------------------------------------------------<BR>%&#062;<BR>&#060;%&#039disable caching for internet explorer%&#062;<BR>&#060;%Response.ExpiresAbsolute = Now() - 1%&#062;<BR>&#060;%<BR> sSQL = "Select * FROM tblcontacts WHERE id=" & Request.QueryString("id") & ""<BR> response.write ssql<BR> Set Rs = Server.CreateObject("ADODB.RecordSet")<BR><BR>&#03 9this is the line I am getting the error on <BR>Rs.Open sSQL, sDSN, adOpenKeySet, adLockPessimistic, adCmdText<BR><BR>%&#062;<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Unspecified Error

    Maybe it&#039s just looking at your code via the board but it looks like there is a space before the 8

Posting Permissions

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