Using DOA 3.3.3 - ORA-00054 Error

[brettf]

When trying to connect to an Oracle 7.3.x database (after installing the 8.1.6 client tools) I am getting an ORA-00054 error. Assuming that my Oracle session object is named ORCL, I can call ORCL.Connected:=true; without any problems. As soon as I try to execute my first Oracle Query (named OQry1), I get the above mentioned error with the explanatory text:

"Resource busy and aquire with NOWAIT specified"

Is there an incompatibility with my 8.1.6 driver, or with DOA 3.3.3 and 8.1.6 client?

Thanks.

------------------
-- Brett Fattori

 

[Marco Kalter]

Are you sure this happens during logon?

------------------
Marco Kalter
Allround Automations

 

[brettf]

Not during logon, but when I execute my first SQL statement. I seem to have been able to get around it, however. I needed to supply the service name as ALL CAPS.

What I used to do, when I was using the older 8.1.x tools, was supply the service name in lowercase "bob.bizserve.com". I found that in 8.1.6 I have to use ALL CAPS.

------------------
-- Brett Fattori