We have been using OLE DB, but we have to changed it to ODBC.
Our problem is that, when we changed to ODBC we got this error. "Disconnected recordsets are not available from ODBC connections.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
We have simple SQL SELECT query that worked with OLE DB. It has custom Result set to: Result Name = 0 Variable Name User::rsTest. rsTest is object datatype.
- also tried to set TypeConversionMode to allowed and nothing changed
Does somebody know what to ? Thanks for any help...