I get the error System.__ComObject when using recordset

This error occurs if you are trying to fetch the recordset value as follows

rs.Fields('productname')

To avoid this error try
VB.NET

rs.Fields('productname').Value.ToString()

C#

rs.Fields['productname').Value.ToString() ;