Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

Hello everyoen, I get this strange error:
ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/OPICForms/115/115-attach.asp, line 0


It comes from my connection code.  I know my connection string is correct becuase it works on all the other pages except this one... Of cousrse this page is particularly special as it saves attachementns intot he database as blobs...

Here is the connectionc ode, please let me know if you require more code or further explanation
Since the application is so huge I did not wan to clutter the quetsion with too much code, however, I would be more than ahppay to add whatever you think to be necessary to figure out this strange error/;


CODE:

  'Checking to make sure if file was uploaded
   dim objConn, strConnStr

strConnStr = "PROVIDER=MSDASQL;DRIVER={SQL Server}; SERVER=servername; DATABASE=dbName; UID=user;PWD=password;"

      set objConn = server.createObject("ADODB.Connection")
      objConn.ConnectionString = strConnStr
      objConn.Open   'Without this the error says the connection is NOT open

    If fileSize > 0 Then
     Dim rs
      Set rs = Server.CreateObject("ADODB.Recordset")
        rs.Open "SELECT * FROM tableName", objConn, 2, 2
        
        ' Adding data
            if not rs.eof then
                  rs.AddNew
                    rs("File Name") = fileName
                        
                  rs.Update
        end if

rs.Close
Set rs = Nothing

            objConn.Close
              Set objConn = Nothing

Start Free Trial