[cleanstackhub]

I have converted my access database to mysql however my asp code is throwing the following error.

Microsoft VBScript runtime error '800a01a8'

Object required: 'rsObject'

/ezpoll/common/db_functions.asp, line 52

I have looked at the code and cannot try to figure out why I am getting the error to this line of code:

rsObject.Close: Set rsObject = Nothing

the full code is below;

<%
  Sub ConnOpen(Conn)
	  Conn.Open ConnStr
	End Sub
	
	Sub ConnClose(Conn)
	  Conn.Close: Set Conn = Nothing
	End Sub

	Sub getPageRecordset(strSQL, rsObject) 

		'rsObject.CursorLocation =  3
		rsObject.Open strSQL, Conn, 3, 1, &H0002
	
	End Sub
	
	
	Sub getPageTextRecordset(strSQL, rsObject) 

		'rsObject.CursorLocation =  3
		rsObject.Open strSQL, Conn, 3, 2, &H0001
	
	End Sub
	
	Sub getPTextRecordset(strSQL, rsObject) 

		rsObject.Open strSQL, Conn, 3, 2, &H0001

	End Sub

	Sub getTextRecordset(strSQL, rsObject)
	 
    rsObject.CursorLocation =  3
		rsObject.Open strSQL, Conn, 3, 3, &H0001

	End Sub
	
	Sub getTableRecordset(strSQL, rsObject) 

		rsObject.Open strSQL, Conn, 3, 3, &H0002

	End Sub
	
	Sub getExecuteQuery(strSQL) 
	
		Conn.Execute(strSQL)

	End Sub
	
	Sub closeRecordset(rsObject)

		rsObject.Close: Set rsObject = Nothing

	End Sub
	
	Sub closeObject(oObject)

		oObject.Close: Set oObject = Nothing

	End Sub
%>

Any suggestions would be appreciated

[Doug G]

If you have any on error resume next statements in your code comment them out and perhaps you'll see other errors.