what could this be in reference to ???

Results 1 to 2 of 2

Thread: what could this be in reference to ???

  1. #1
    Join Date
    Dec 1969

    Default what could this be in reference to ???

    I get the following error:<BR><BR>ADODB.Recordset error &#039;800a0e7d&#039; <BR><BR>The connection cannot be used to perform this operation. It is either closed or invalid in this context. <BR><BR>/websites/MustekIntranet/admin/addremedit.asp, line 195 <BR><BR><BR>====================================== ====================<BR>When I use this code:<BR><BR>Set rstDBEdit = Server.CreateObject("ADODB.Recordset")<BR> rstDBEdit.Open strSQL&#039;, CONN_STRING, adOpenForwardOnly, adLockReadOnly, adCmdText<BR>

  2. #2
    Join Date
    Dec 1969

    Default You need the

    Connection Object Open, make sure it is open and that it is not closed somewhere!<BR><BR>Dim objConnection<BR>Set objConnection = Server.CreateObject("ADODB.Connection")<BR>objConn ection.Open ""<BR><BR><BR>Dim strSQL<BR>strSQL = "SELECT ......"<BR><BR><BR>Dim objRecordset<BR>Set objRecordset = Server.CreateObject("ADODB.Recordset")<BR>objRecor dset.Open strSQL, objConnection, .......<BR>

Posting Permissions

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