Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  ADODB Field error!

Author  Topic  jains Starting Member 1 Post Posted - 2009-08-12 : 22:11:10 Hey when i try to run my VB Script to import data to MS Access, this is the error i get: ADODB.Field: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. this is the part of my script giving error: Do while not ObjPerMonthRecord.EOF IPAddr = ObjPerMonthRecord(0).Value PortID= ObjPerMonthRecord(1).Value PortStatus= ObjPerMonthRecord(2).Value sql="SELECT PortStatus FROM CheckUsedPortStatusMonthly WHERE IPAddr = '" & IPAddr & "' and PortID = " & PortID & "" Set rs2 = conn2.execute(sql) If rs2(0).Value = "down(2)" And PortStatus = "up(1)" Then Condition = "[PortStatus] = '" & PortStatus & "',[Changetime] ='" & ObjPerMonthRecord(3).Value & "'" 'WScript.Echo IPAddr & " " & PortID & " " & PortStatus Call ImporttoPortDescriptionMonth(Condition,IPAddr,Port ID) Else 'WScript.Echo IPAddr & " " & PortID & " " & PortStatus End If ObjPerMonthRecord.MoveNext Loop ============================================ Please suggest what could be done to sort this problem..