bachar
asked on
Using Database connection pooling with ADO
Hi,
I'm using Database connection pooling with ADO, by keeping one instance of a Connection object instantiated for each unique user. I'm writing in VC++ 6.0
How can I configure the max number of connections in the Database connection pooling?
How can I get the pool parameters (number of active connections, disconnected connections, etc.)?
Thanks
I'm using Database connection pooling with ADO, by keeping one instance of a Connection object instantiated for each unique user. I'm writing in VC++ 6.0
How can I configure the max number of connections in the Database connection pooling?
How can I get the pool parameters (number of active connections, disconnected connections, etc.)?
Thanks
Triskelion
What database brand?
ASKER
Oracle 8.1.7
Don't know about Oracle, but I do know that keeping a connection alive for the session of a unique user is bad design. Open the connection when you need the connection and close it again when you are not sure that any database access can occur again. Keep the connection alive as short as possible!
CJ
CJ
I assume though that Oracle also supports the Microsoft Distributed Transaction coordinator. That way you can see how many calls are being made, how many connections are open etc.
Not sure though if oracle supports it.
CJ
Not sure though if oracle supports it.
CJ
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- Answered by: schwertner
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
Nic;o)
Question has been closed as per recommendation
JGould-EE Moderator
JGould-EE Moderator
Thank you very much!