Sybase does not allow multiple "statements" per co

[Stephane FRANC]

Hi,

I have a problem with Sybase and dbexpress driver for Sybase.

By default, Sybase does not allow multiple "statements" per connection which necessitates the need for multiple user connections for multiple "Tables", "Queries/SQL" and "Linked Cursors" for a Sybase/MSSQL client.

"Multiplexing" a single connection would incur a decrease in performance.

But, on Unix platform or with the ODBC administrator, it is possible to set the "SelectMethod" option to allow multiple "statements" per connection.

Is there also, with Visoco, a possibility of by-passing this problem ?

Regards,
Stephane FRANC

[VISOCO Support]

This feature will be available in the next minor version.
However, using of this method will cause some restrictions as discussed in the topic
"Bugs in the dbexpsyb.dll"

[Mario]

Hi,

I currently have 1.2.5.106 version.

Is the feature to allow multiple statements per connection currently available? Is so, how do I turn it on?

I'm using Delphi 6 Enterprise SP2.

Thanks for your help!

[VISOCO]

No, there is no such feature.
_________________
Best regards,
VISOCO Software Team
--
VISOCO Software - Sybase connectivity products

[Smile_DP]

Hi!

I have trial version dbexpsyb.dll 2.1.2.15. There's also no possibility to use multiple statements per connection

I'm completly satisfied with "VISOCO dbExpress driver for Sybase ASE", but this feature is very important to me and because of that i can't purchase your product:-(

Is there hope what this problem will be solved in nearly time?
I think it really improves your product..


best wishes

[VISOCO Support]

Hi there,

unfortunately this feature cannot be implemented in the near future.
It requires fundamental changes of the driver's architecture.

Try to use caching datasets (TClientDataSet) to minimize the number of open cursors. The connection will be reused if the cursor will be closed.

[Smile_DP]

Thanks for your advice:-)

But it's not an alternative for me, because application will be very big and will be used by big number of users. There is limit of connection in sybase.

For example if my application will be used at least by 10 user and for each application will be 5 active statement in specified time(what equival to 5 connection) - because of that there's it will be 50 connection to db server, i think its not normally:-)