SQLB-2451: There is already an open DataReader associated with this Com

[Mide]

SqlBase 12, .NET data provider.

Open SqlBaseConnection

Start SqlBaseTransaction, commit, dispose.

Start another SqlBaseTransaction using same connection.

You will get error from subject.

[Mike Vandine]

Hi Mide,

I saw that you posted this in the SB12 forum as well. Did you get a resolution to this?

Best regards,

[Mide]

Nope

I first posted this in SqlBase 12 forum, but after testing I think it's u bug so I posted it here.

Maybe it's me but I think that one should be able to execute two or more transactions over same connection. I'm not talking about concurence transactions but one after another.

Right now I'm in process of porting our SqlBase 8.5 database to 12 version and I'm stuck becouse of this "bug".

[Mike Vandine]

Hi,

OK, I understand. Please submit a small project that shows this issue that I can give to Dev. I think that maybe the dispose might not be clearing the connection quickly enough.

Mike

[Mide]

Thank you Mike

Here is example project (Visual Studio 2013, .NET Framework 4.0).

I also noticed one more thing preparing the test case.

When you add reference to Gupta.SqlBase.Data and if you choose from properties window for referenced assembly option "specific version" true than you get compiler warning

Warning 1 The predefined type 'System.Runtime.CompilerServices.ExtensionAttribute' is defined in multiple assemblies in the global alias; using definition from 'h:\SQLBase 12\Gupta.SQLBase.Data.dll' C:\Users\mide\Documents\Visual Studio 2013\Projects\SQLBase12Test\SQLBase12Test\CSC SQLBase12Test

In this case opening connection and working with Gupta.SqlBase.Data is significantly slower. Do I need to open new thread for this ?

[Mike Vandine]

Hi,

This has been reproduced and SQLB-2451 was created for this issue. It's scheduled for a SB12.0.1 fix.

Regarding the warning message:

Regarding the warning message: "The warning is a workaround for a feature I use. It will be removed when we no longer target .NET 2.0. "

Regarding the slowness of the .NET driver, can you please open a new thread with a sample and steps to show the problem.

Best regards,