| Author |
Message |
germanf
Joined: 21 May 2004
Posts: 2
|
 Posted: Mon Apr 11, 2005 5:10 pm Post subject: Does not release connections? |
 |
|
Hi,
Our program works correctly, after one or two hours it exhausts the amount of connections available for SYBASE, apparently, in some circumstances, does not release connections. Same program works well with SQL Server/dbExpress.
Thanks. |
|
| Back to top |
|
 |
VISOCO Support
VISOCO Software Support
Joined: 16 Jul 2002
Posts: 96
|
| Posted: Wed Apr 13, 2005 12:18 pm Post subject: |
|
|
Hi,
We'll look for the solution but it doesn't seem to be a simple task... So it can take some time...
What kind of datasets are you using in your application? Could you trace which actions cause an increase of the number of open connections? In which situations the connection remains open ?
| Quote: | | apparently, in some circumstances, does not release connections |
Maybe, you have some ideas or code samples that can help to localize the problem. Could you please send us a little sample that demonstrates the trouble? |
|
| Back to top |
|
|
VISOCO Support
VISOCO Software Support
Joined: 16 Jul 2002
Posts: 96
|
| Posted: Wed Apr 13, 2005 12:22 pm Post subject: |
|
|
| Code: | | Same program works well with SQL Server/dbExpress |
What is the version of the server / driver you are using ? |
|
| Back to top |
|
|
germanf
Joined: 21 May 2004
Posts: 2
|
| Posted: Mon May 02, 2005 11:02 pm Post subject: RE: Does not release connections? |
|
|
Hi,
At the moment we used SYBASE ASE 12.5.2, the problem also appears ASE 12.5.0. Our system is an ERP, therefore makes use intensive of data base, is difficult to exactly determine in that situation appears the fault. The system has multitier (Remote Data modules) which are instancing in way ' Multiple Instance’, I guess this is a possible cause, we have executed our test units with a single user and the driver behaves well. When we generated load with concurrent users appears the fault. Today we managed to capture following error: "dbExpress Error: Local Transaction already active ".
Thanks for your interest.
German. |
|
| Back to top |
|
|
VISOCO Support
VISOCO Software Support
Joined: 16 Jul 2002
Posts: 96
|
| Posted: Tue May 03, 2005 10:15 pm Post subject: |
|
|
Hi,
the last version of the driver was compiled with Delphi 7.0 with Update 1.
The values of dbexpress error codes were changed in this update:
excerpt from DBXpress.pas (Delphi 7.0)
| Code: | DBXERR_DRIVERRESTRICTED = $0011;
DBXERR_LOCALTRANSACTIVE = $0012; |
excerpt from DBXpress.pas (Delphi 7.0, Update 1):
| Code: | DBXERR_DRIVERRESTRICTED = $0012;
DBXERR_LOCALTRANSACTIVE = $0013; |
If your program was compiled with Delphi 7.0 without Update 1 it will map the error code DBXERR_DRIVERRESTRICTED (returned by the trial version of the driver) to the exception mentioned above (dbExpress Error: Local Transaction already active).
You need to to install Update 1 and recompile the program. |
|
| Back to top |
|
|
|
RSS Feed 
FAQ 
Search 
Memberlist 
Usergroups
Register
Profile 
Log in
