oracle - ADO "Unspecified Error" instead of actual error when fetching server side cursor -


This is related to the question of my own:

I have to reproduce a situation enable ADO using Oracle Oelidibi provider where I am, I ORA-01722: can force an error on an invalid number calling Recordset.MoveNext I though this error The application form which is not Instead, the application sees provider error '80004005' unspecified error . How can I get an application to see the actual error from the database? This is with Oracle 10G (Client and Server), if this is the case.

Sample code is roughly as follows:

  dim com as new Adiodibi. ADODB.Command Dim rs As ADODB.Recordset con.ConnectionString = "Provider = OraOLEDB.ORACLE; Data Source = xxx; User ID = yyy; password = zzz" con.CursorLocation = adUseServer con.Open set cmd.ActiveConnection = con cmd Kmmandtakst = "table (selection) * select" Simdikpeepiard = True set RS = Simdi.aksakyut, while rs.EOF rs.MoveNext Wend  

SQLCODE and SQLERRM should be returned with a SQL call. This ADO error is to reach this.


Comments