Re: What is ORA-03123

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Wed, 24 Nov 1999 12:32:50 GMT
Message-ID: <383bda51.4194150@newshost.us.oracle.com>

On Tue, 23 Nov 1999 15:56:34 GMT, thtsang_at_my-deja.com wrote:

>Hello All,
>
>I have a VB program connecting an Oracle database. I have got the error
>ORA-03123 serveral time. According to oerr, 'this is not an error' and I
>should retry later. What's going on?
>
>I heard that this may be caused by 16 bit programs using IPX. But mine
>is VB5 program using the ODBC driver from Oracle. The network protocol
>was TCP/IP. Can anyone suggest what is the problem? Also, is it
>guaranteed that my retry will eventually succeed? How long should I
>wait?

For *every* connection you open to the Oracle database, try setting:

        SQLSetConnectOption( hdbc, SQL_ASYNC_ENABLE_OFF, SQL_NTS );
>
>Thank you very much.
>
>Anthony Tsang
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Thanks!

Joel

Joel R. Kallman Oracle Service Industries

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Wed Nov 24 1999 - 06:32:50 CST