Error in VB6 application using the provider oraOLEDB.oracle

0

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.

    
asked by anonymous 23.08.2018 / 16:58

0 answers