Board index » cppbuilder » Number of connections

2003-09-15 03:37:56 PM
cppbuilder24
Hi all,
I usually work with MS Access DBs and do not have to worry about the number
of connections I make per application instance. However, I am now writing
an application that will get all of its data from an Oracle 9i DB.
I originally thought that it would be best to use just one TQuery but this
is proving to be too restrictive. If instead I use one TQuery for most of
the data retreival and another one only when really neccesary will this have
a detrimental effect on the number of concurrent users of the DB? Do I need
to take anything else into account?
Cheers
Chris
 

Hi Chris,
If you are using BDE, and C++Builder Professional edition, you must
configure an ODBC alias on every workstation which runs your application.
Drop down a TDatabase to make a single connection to the Oracle server and
as many TQueries as you need. Set up the DatabaseName property of every
TQuery to the name of the TDatabase you droped down into your application.
You need a single Oracle connection per application-user.
HTH
Jayme .
"Chris" < XXXX@XXXXX.COM >wrote in message

"Jayme Jeffman Filho" < XXXX@XXXXX.COM >wrote in message
Thanks for the explanation, much appreciated.
Cheers
Chris
 

{smallsort}

I have a problem with number of connections with my SQL SERVER2000. If I starting more than 10 connections in the same station the error "Insuficient Memory for this operation" appears. Using DBExpress this error does not happen. WHat can I do to solve that ?
Configuration:
Delphi5
SQL Server2000
WindosXP