can not create new connection because in manual or distributed mode

praaphorst · Post by **praaphorst** » Thu 08 Dec 2005 12:03

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?

Ikar · Post by **Ikar** » Thu 08 Dec 2005 13:47

This is MS SQL problem. Do you use FetchAll = False?

praaphorst · Post by **praaphorst** » Thu 08 Dec 2005 14:01

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).

Ikar · Post by **Ikar** » Fri 09 Dec 2005 07:59

Is it possible that several queries are executed at the same time through the same connection?

praaphorst · Post by **praaphorst** » Fri 09 Dec 2005 08:16

Each client has it's own connection to the database.

Ikar · Post by **Ikar** » Fri 09 Dec 2005 08:23

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)

praaphorst · Post by **praaphorst** » Fri 09 Dec 2005 13:20

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.

Ikar · Post by **Ikar** » Mon 12 Dec 2005 12:58

> 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.