Help: Intermittent Connection Problems

We have a problem whereby the database server has an apparent memory leak, and fails to allow conections with intermittent increasing frequency.

I am connecting to Oracle 7.3 using ODBC v2.1 abd ODBC v3.0. I also connect through SQL Plus and SQL Station (non-ODBC connection).

We have tried the above using RDOv2 in VB5 and through VB4 DAO 2.5 with the same results. When the problem finally becomes constant, nobody can connect through any means.

I can connect in a loop to test and with variable intermittency, it eventually fails to connect with no timeout, and no return. Locks the app! (usually after 2-20 attempts)

I have tried Intersolv ODBC drivers (2.11, 2.12 and 3.0). Also tried MS Oracle drivers with same result.

Is there a way to loop connect in PL/SQL?

I've tried:
declare

    i number;
begin

    for i ub 1..50 loop

        connect uid/pwd_at_db ; --<- tried with ann w/o ";"     end loop;
end;

with no success. Any ideas.

I'd like to dispel the primitive myth that this problem is an aplication problem at work. Funny that an application could be responsible for the server. Says more about the robustness of the server.

SQL Net version is something like 2.3.3. DB is 7.3xx?

Restarting the DB always corrects the problem. Restarting the listener has on occassion worked, but the DBA group still insists that it is an app problem :-)

Thanks in advance for any help. Received on Sat Feb 28 1998 - 00:00:00 CST