#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    1
    Rep Power
    0

    Unhappy Help from converting access to mysql - Object required: 'rsObject'


    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:

    Code:
    rsObject.Close: Set rsObject = Nothing
    the full code is below;

    Code:
    <%
      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
  2. #2
  3. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,451
    Rep Power
    4539
    If you have any on error resume next statements in your code comment them out and perhaps you'll see other errors.
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester

IMN logo majestic logo threadwatch logo seochat tools logo