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)  Please help....error...error...error

Author  Topic  zara Starting Member 3 Posts Posted - 2000-12-01 : 15:00:33 Operation is not allowed on an object referencing a closed or invalid connection. Code: Calling SQL statement as follows: Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open application("pmisconn") Set logcommand = Server.CreateObject("ADODB.Command") logcommand.ActiveConnection = Conn logcommand.CommandType = adCmdStoredProc logcommand.CommandText = "LogView_SP" Set RS = Server.CreateObject("ADODB.Recordset") Rs.CursorType = adOpenStatic Rs.Open rcd Rs.PageSize = 10 Rs.CacheSize = Rs.PageSize intPageCount = Rs.PageCount Rs.MoveLast intRecordCount = Rs.RecordCount All help is greatly appreciated and advice taken seriously.