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
Post a Comment