Open Independent Mulitple sessions with oracle in a LabVIEW exe

[sumitrishi]

Is it possible to maintain different sessions to same database from within a labVIEW exe. I need to have a server to which multiple clients connect. Server starts handler for each client and each handler needs to connect to the database and transact on its own and get some data for the client. This is basically to achieve concurrency. But the operations are happening only sequentially. Please help.

[Jeremy Braden]

Your two other postings:

"Parsing an SQL statement coming in the way of reentrancy."
"NEW!! Parsing an SQL statement coming in the way of reentrancy."

I put a link to all your postings here to help others on the discussion forum to follow your questions.

The problem may be that your server has a single CPU and that it can only do one thing at a time. Another limitation may be the abstraction layer for your database. What version of the Oracle d
b are you using? Do you have this problem across computers or just on a single machine?

[sumitrishi]

I am using oracle 8i and the problem is on the same computer - Atleast my server program runs on one computer alone.
However if I use TOAD and my program to run two different stored procedures they execute in parallel . but different handlers, spawned by the server to handle client requests, are not able to transact independently.I am not sure if my settings for connection , recordset object are correct or not? or if concurrency is really a feature of the provider which I am using ( MSDASQL.1) . Thanks.

[sumitrishi]

I just used this API SQLGetInfo()and found out that the Oracle ODBC Driver supports SQL_MULTIPLE_ACTIVE_TXN. I thought I will share this too with you.