I have an class that utilizes a ADO Connection object. This object gets set after i create the object. When I call a function in the class(piece of it below) I get an error(3001) if using the first line..and w/ the second it works..but the recordset it returns is forward and read-only which just wont cut it.
Dim rsTemp As ADODB.Recordset
Set rsTemp = New ADODB.Recordset
---Give 3001 error.
rsTemp.Open "select * from " & strProject & "_settings where messaging = 1", conMain, adOpenStatic, adLockOptimistic
---Works fine but recordset is limited
Set rsTemp = conMain.Execute("select * from " & strProject & "_settings where messaging = 1")
I have looked for previous questions here however there are only a few w/o 'specific' answers, and MSDN Library has a single reference to this error however it only talks about Command objects.
TechInfo- VB6EE w/ SP3 w/ the latest MDAC