Connection ERROR!!!!HELPP!!!!

Results 1 to 2 of 2

Thread: Connection ERROR!!!!HELPP!!!!

  1. #1
    Pierre Guersley Guest

    Default Connection ERROR!!!!HELPP!!!!

    HELP, HELP, HELP,<BR> i&#039m having that error for 2 days now and i can&#039t solve it would u PLEASE tell me what could be the problem????<BR><BR> my include file is:<BR> &#060;%<BR> Dim oConn <BR> Set oConn = Server.CreateObject("ADODB.Connection")<BR><BR> strConnect = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("acces_contact.mdb")<BR><BR> %&#062;<BR><BR> my code is:<BR> &#060;%<BR> dim rsUsagers, sql<BR> set rsUsagers = Server.CreateObject("ADODB.Recordset")<BR> sql = " SELECT * FROM PR_CCD WHERE pein = " & Request("PR_CCD") & ";"<BR> rsUsagers.Open sql, oConn, adOpenForwardOnly, adLockOptimistic, adCmdText<BR> <BR> %&#062;<BR><BR> and my error is:<BR> ADODB.Recordset error &#039 800a0e7d&#039 <BR><BR> Operation is not allowed on an object referencing a closed or invalid connection. <BR><BR> /ModifierUnePersForm.asp, line 38 <BR><BR> and the line 38 is:<BR> rsUsagers.Open sql, oConn, adOpenForwardOnly, adLockOptimistic, adCmdText

  2. #2
    Join Date
    Dec 1969

    Default Refer below.

    Refer Below.

Posting Permissions

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