Re: VB6 Question

Ian Steward <isteward_at_mediaone.net> wrote in message news:HsyM3.10129$Ud2.354213_at_typhoon1.rdc-detw.rr.com...
> I am just starting to work in Oracle. When I encounter messages such as:
>
> Runtime Error '-2147217900 (80040e14)':
> [Microsoft][ODBC Driver for Oracle][Oracle]ORA-20003:
>
> how can I look up this message and find out what the error really is? Is
> there list of Msoft Oracle Driver error descriptions? Help !!!!!
>
> - Ian Steward

Here's how I see it - if there's only a VB code then it's probably a VB problem. If there's both a VB code and an Oracle code then you can assume that an Oracle error started it. In the latter case you should simply look up the code in the Oracle Messages manual (or ask a DBA).

In your case, I believe that the error is a simply a programmer defined exception on the server. Is there a programmer on your team writing procedures, triggers etc? If so then you should ask them what they've used -20003 for - and coordinate with them for suitable client side handling.

Incidentally - one nice trick that colleague used, was to dump full VB/Oracle DB error text to a file whenever anything went wrong. The VB App included a send button which emailed this info, and this proved usuful during initial support.

Regards,

Richard Gowan Received on Tue Oct 12 1999 - 07:15:15 CDT