Good morning.
In the company where we work we have several applications in VB6 and after 2 clients upgrade to Oracle 12.2 that uses the oraOLEDB.oracle provider instead of MSDAORA the applications started to present several errors.
Examples: Code:
On Error Resume Next
Me.Grid.ValueLists.Clear
On Error GoTo 0
If rst.State = 1 Then rst.Close
rst.ActiveConnection = Nothing (o erro ocorre nesta linha)
Error: Run-time error '3711' The operation can not be performed during an asynchronous execution.
Code: Me.rst.Open sql, cnn, adOpenKeyset, adLockBatchOptimistic
Error: Run-time error '-2147417848 (80010108)' Automation error
Another error that is a bit more common for me and that is caused by error in the assembly of the grid is this: Multi-step operation has generated errors. Check each status value. It happens when I assign a value to the recordset Me.rst ("ID"). Value = 1234, is a common instruction and is used in the assembly of our grids
Connection String: Provider = OraOLEDB.Oracle.1; Password = **; Persist Security Info = True; User ID = BASE; Data Source = ORA12C; Extended Properties =
If they can help.