Page 1 of 1
can not create new connection because in manual or distributed mode
Posted: Thu 08 Dec 2005 12:03
by praaphorst
Starting a second client of our software produces the following error:
- can not create new connection because in manual or distributed mode -
What should you set for the dbExpressDriver to avoid this error?
There's a topic in borland.public.delphi.database.dbexpress discussing this
for the borland driver where T. Ramesh advices poFetchDetailsonDemand :=True on the provider side.
What is the solution for the Corelab driver?
Posted: Thu 08 Dec 2005 13:47
by Ikar
This is MS SQL problem. Do you use FetchAll = False?
Posted: Thu 08 Dec 2005 14:01
by praaphorst
We do not set this value explicitly so i assume it's at it's default value which should be True (according to the readme).
Posted: Fri 09 Dec 2005 07:59
by Ikar
Is it possible that several queries are executed at the same time through the same connection?
Posted: Fri 09 Dec 2005 08:16
by praaphorst
Each client has it's own connection to the database.
Posted: Fri 09 Dec 2005 08:23
by Ikar
Please send us (dbxsda*crlab*com) a complete small sample to demonstrate it and include script to create and fill table.
Also supply us following information
- Version of Delphi or C++ Builder
- Version of DbxSda. You can find it in History.html
- Version of Microsoft SQL Server and OLE DB provider that you use (sqloledb.dll)
Posted: Fri 09 Dec 2005 13:20
by praaphorst
Our server software is run on a MS 2003 Server using MS SQL Server 2k. This server has MDAC 2.8 RTM installed (sqloledb version 2000.85.1022.0).
Our server software uses dbexpsda.dll version 2.50.4.
I can not present you with a program example where this error occurs, or a complete isolated case as you requested. Our software is to extensive for that.
In fact we assume the dbExpress driver is doing something that violates the restrictions this ms sqlserver driver has.
You could possibly find some more info in the thread named "dbExpress MSSQL issue: Cannot create new connection because in manual or distributed transaction mode." @ borland.public.delphi.database.dbexpress.
Posted: Mon 12 Dec 2005 12:58
by Ikar
> In fact we assume the dbExpress driver is doing something that violates the
> restrictions this ms sqlserver driver has.
It's possible, but unlikely. From time to time other users report about similar problems, but always it's problems with calling application.