I'm having a problem here with disconnected recordsets.
The key is a sequence in Oracle and i use the Microsoft ODBC driver for Oracle
.CursorLocation = adUseClient
.Properties("Update Criteria").Value = adCriteriaAllCols
.Properties("Update Resync").Value = adResyncInserts Or adResyncUpdates Or adResyncAutoIncrement
.Open strSQL, DB_CONNECT, adOpenStatic, adLockBatchOptimistic
Set .ActiveConnection = Nothing
'fill the fields
.ActiveConnection = conRDBMS
Normally i should have now in that recordset the record with the new PK. Unfortunatelay it doesn't do that.
When i look at some properties of the recordset they say:
"Row handle referred to a deleted row or a row marked for deletion."
Giving error number -2147217885
How do i solve that? Has it something to do with the ODBC driver?