I have a ADODB.Connection object and different ADODB.Recordset objects.
First recordset is opened succesesfully but while opening second recordset it gives error
"Method 'Open' of object '_Recordset' failed".
i tried it with command object also. At that time i got message
"Method 'Execute' of object '_Command' failed".
can any body plz help me?