Error msg in OLD DB provider

10 Nov 2005 8:09 PM

Roy

I use OLE DB to call a series of stored procedures to add records to database
tables within one transaction. I got the following errors:

Description: Cannot create new connection because in manual or distributed
transaction mode.
Source Description: Microsoft OLE DB Provider for SQL Server

The stored procedures are very simple. I do not try to create a new
connection explicitly. Neither do I try to use distributed transactions. The
only thing that might be a little complicate is I use ISequentialStream to
write blobs to table fields. The error msg confuses me. Any one has ideas
about this?

10 Nov 2005 8:14 PM

Roy

Anothing might be interesting is that the error happens randomly and if I set
a break point in the code where it crashed and wait for a while before the
rest of stored procedures, you will not see the error and the save is
successful.
Roy

Show quote

"Roy" wrote:

> I use OLE DB to call a series of stored procedures to add records to database
> tables within one transaction. I got the following errors:
>
> Description: Cannot create new connection because in manual or distributed
> transaction mode.
> Source Description: Microsoft OLE DB Provider for SQL Server
>
> The stored procedures are very simple. I do not try to create a new
> connection explicitly. Neither do I try to use distributed transactions. The
> only thing that might be a little complicate is I use ISequentialStream to
> write blobs to table fields. The error msg confuses me. Any one has ideas
> about this?

10 Nov 2005 10:29 PM

Thomas

The URL below mayhelp.
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q272/3/58.asp&NoWebContent=1

--
Thomas

Show quote

"Roy" wrote:

> I use OLE DB to call a series of stored procedures to add records to database
> tables within one transaction. I got the following errors:
>
> Description: Cannot create new connection because in manual or distributed
> transaction mode.
> Source Description: Microsoft OLE DB Provider for SQL Server
>
> The stored procedures are very simple. I do not try to create a new
> connection explicitly. Neither do I try to use distributed transactions. The
> only thing that might be a little complicate is I use ISequentialStream to
> write blobs to table fields. The error msg confuses me. Any one has ideas
> about this?