Mmm there's no Error Collection in ADO NET sqlConnection class

A "Error Collection" exists but when sqlExceptions happens

In this case no exceptions occurs before the "loss" of the sqlConnection

how could we...

Hi Mr. Magoo

I'll try first search and log the error collections in my copy of sqlConnection before the ExecuteScalar and even int the first instance of sqlConnection and sqlTransaction

After that...

Hi Mr. Magoo

SP content basically is like this:

CREATE PROC [dbo].[spInitialInsert]

@CustomerId varchar(10),

@Input varchar(100)

AS ...

Hi Mr. Magoo

Sorry for being "vague" but cannot just post all code for obvious reasons...

I'll check with detail your tip about "byref"...just don't know why the "byval" have been working...

Hi Lowell

I've thinking about it but in that case it should happen every time we process the same input...

We reprocess the input and it commits ok, without ANY source...

Thanks a lot for your suggestions

I try to replicate it closing connection but there's always an exception that's catched

It happens again recently, with same symptoms, in a different source, but...

Thanks a lot Jeffrey

I'm looking at the .Net code and for each user process request there's one SqlClient.SqlTransaction running 5 SPs, each inserting in a respective table.

There's a try ......