uniConnection not connecting after few connect/disconnect

[arusoft]

This is kind of urgent.

We are connecting to ORACLE using Tuniconnection.

We have a Delphi Application that calls a DLL that is created in Delphi .
This DLL has its own UniConnection component. All this DLL dose is connection to database. Run some select and update/insert query and disconnects.

Now when I run the application and after calling DLL for about 5 times, it freeze application.

The problem is I cannot reproduce on my machine, but I can see this happening at client machine every time. We even tired monitoring using UniSQLMonitor. It shows five successful connects and disconnect messages. On 6th try it dose not connects at all. With uniSQLMonitor I see that last log as Connect: XXXXX@YYY

And when we kill the application process and try all over again the pattern repeats.

Please advice.

Thank You.

[AlexP]

Hello,

Thank you for the information. We have reproduced the problem and will investigate the reasons of such behaviour. We will inform you as soon as we have any results.
P.S. For the time being, to solve the problem, you can avoid using (creating) the TUniSQLMonitor object in your library.

[arusoft]

Thanks for your reply. Just for your info we added TUniSQLMonitor just for monitor reason only. So we are having this issue without TUniSQLMonitor in DLL.

Also since we support SQL Server too, we are seeing similar behavior. And when I checked sysprocesses table in SQL Server I saw that NumberOfConnections count keep increasing and there was no loginName associated with it.



Thank You.

[AlexP]

Hello,

We cannot reproduce the problem not using UniSQLMonitor in the DLL, when both working with Oracle and MS SQL Server. Please send an application demonstrating the problem to alexp*devart*com, and specify the exact versions of UniDAC, IDE, OSs, Oracle and MS SQL Server (servers and clients).

[arusoft]

Sorry I am not able to reproduce either.

But we have a webservice that call this DLL and its freexing too.

When I put the TUniSQLMonitor and trace the error this is what I get

Connect: XXXX@YYY
Error: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Connect: XXXX@YYY
Error: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Connect: XXXX@YYY
Error: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Connect: XXXX@YYY
Error: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


This is really urgent. please advice.

THanks.

[AlexP]

Hello,

When this error occurs, please check the listener status on the server using the commands:

Code: Select all

cmd>lsnrctl status
cmd>lsnrctl service