1. Santosh Pawar
  2. PowerBuilder
  3. Tuesday, 9 May 2017 10:18 AM

We have multiple users, using same .exe from shared folder (shared folder exist in server), recently i installed the Application first time for one new user but a error is coming

like "Transaction already connected", remaining all users its working fine. i restarted his machine but still issue exist. we are using DB as Oracle 11g and PB 12.5.

Please any hints on this?

Error : Database Connect Error, Database error detected during connect, Transaction already connected
           
           

 

 

Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 10 May 2017 02:44 AM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

I can get some sample code tomorrow, but in a nutshell this is the flow:

1. Before you attempt to connect, put a simple SELECT count(*) INTO l_result from TABLE_1;

2. Check the SQLCA.sqlCode. The results will tell you if you succeeded or failed.

3. If you succeeded, then you are already connected!

 

Later -

Olan

Comment
There are no comments made yet.
Chris Pollach Accepted Answer Pending Moderation
  1. Tuesday, 9 May 2017 18:59 PM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

Hi Santosh;

   Sounds like a message that gets issues from your PB App. I would also assume that its related around issuing the Connect DB command. I would review your source code and see exactly where & why that message gets displayed.

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.