firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] error Message "Command Connection is not equal to Transaction Connection"

[Pavol S. <pa...@st...>]

George LAZAR wrote:

>Hello all!
>
>I try to use the Firebird.Net provider.
>
>i have a connection, a transaction and a data adapter.
>i have also a command builder.
>
>when i try to update the data into the database using the dataadapter, i
>receive the error message:
>"Command Connection is not equal to Transaction Connection" .
>
>any ideea?
>
>thank you
>
>
>
>  
>
hi,

you have to post us code,

but i think, that problem is here:
probably you created trancaction by new clausule... Tray to create it by 
FbConnction.BeginTransaction().

p.

>=============================================
>George LAZAR
>=============================================
>
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: ValueWeb: 
>Dedicated Hosting for just $79/mo with 500 GB of bandwidth! 
>No other company gives more support or power for your dedicated server
>http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
>_______________________________________________
>Firebird-net-provider mailing list
>Fir...@li...
>https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>  
>

[Firebird-net-provider] error Message "Command Connection is not equal to Transaction Connection"

[George L. <ge...@ra...>]

Hello all!

I try to use the Firebird.Net provider.

i have a connection, a transaction and a data adapter.
i have also a command builder.

when i try to update the data into the database using the dataadapter, i
receive the error message:
"Command Connection is not equal to Transaction Connection" .

any ideea?

thank you




=============================================
George LAZAR
=============================================

Re: [Firebird-net-provider] FBCommand.ExecuteReader and Transactions

[Carlos G. A. <car...@te...>]

Hello:

> Huummm you are right, at this moment if you want to make an application 
> that can work with, for example, Firebird and MS Sql Server ( or any 
> other ) as database server, you can make a data access layer having in 
> mind that you need to start a transaction always before executing a 
> command, with this you can solve the problem, this is the reason why i 
> think this is not a great problem ( i will try to make a test with MSDE 
> or an evaluation version of Sql Server 2000 for being sure about it ).


I make some test with an evaluation version of MS SQL Server 2000 and 
seems that i'm right, for the test i use the AS3AP Benchmark suite that 
can be found at Firebird project CVS.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] FBCommand.ExecuteReader and Transactions

[<car...@te...>]

Hello:

> this is really interesting problem... Ideology of your provider and for
> example MS provider or Ado itself is little, but in main things different...
> and of course your provider is still not finished. Im affraid that you do it
> in way how ib or now fb API works and did not check how other common
> providers work... 

Well i see some things with the MS ODBC .NET data provider ( using 
IBPhoenix ODBC driver ), but i think this is a problem on how servers 
manage some things, transactions is an example, named parameters or ? 
placeholder can be other, etc..., and this things can be easy or not, 
good or not, to do.

I'm thinking in write a data access layer and commit it to the CVS, Any 
thoughts ???

> anyway i like your point of view and dont like to add
> there new features becouse each new feature is performance hit and makes
> code dirty... It like with firebird server.

:)

> It have now lot of new features
> but its 20% slower :(

Which features ??

> i see that you want to make your provider as near to ADO.NET as possibe..
> Its great idea. But i think, that you have to make there new layer of
> codebase for example ADOFbConnection and so... Becouse there is still lot of
> work in base layer... You can have to have one connection for one command
> (big problem), problems with cleaning resources when i forgot dispose
> something... And trying to force it to be ADO compatible will not work...
> 
> So simple as i wrote there are constructor where you assign transactions, in
> this step when assigned transaction is null or not specified you create and
> start new one... and when you call close or dispose you will commit or
> rollback... In this case will be transaction closed by command not
> connection, and is not created for each statement, so you can call prepare
> many times... And oposite there is one transaction which will be closed as
> command is closed (transaction is private in this case) so there will not be
> problem with lot of transaction to be closed by connection...
> Best way i see is create inherited class ADOFbCommand with new overloaded
> constructor and new close and dispose.
> 
> Or you can replace this:
> if (Transaction == null)
> 
> throw new InvalidOperationException("Command must have a valid
> Transaction.");
> 
> in executeNoQuery, Scalar, Reader by
> 
> 
> 
> if (Transaction == null)
> 
>     Transaction = Connection.BeginTransaction();
> 
> // ofcourse you know that there is connection
> 
> 
> you can put this only in ExecuteReader an can set behavior to
> CloseConnection and there will be no problems with closing :)

I know that there are some ways to do this, but i see this only for 
select commands, we need to think for example that DbDataAdapter make 
calls to ExecuteReader when it exec the insert, update or delete 
commands of FbDataAdapter, and i think that for update operations is 
better to make explicit transactions.

> As i wrote this, why near all classes are sealed???
> There is lot of possibilities how to do that. Question whis is best :)

Because the same classses of other providers are sealed :)

> BUT PLEASE DO NOT MIX IT IN WORKING CODE, until all other required features
> are implemented... i fell that it will bring lot of problems to try it make
> MS compatible and will corrupt working code...

I'm not going to do that


> AND I WANT TO THANK YOU FOR THIS PROVIDER ITS GREAT, ITS PERFECT, ITS BEST
> :) I use it every day and for now i did not find any problem which cannot be
> done by this or any bug you did not correct fast...

Thanks very much :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] FBCommand.ExecuteReader and Transactions

[Pavol S. <st...@st...>]

hi,

this is really interesting problem... Ideology of your provider and for
example MS provider or Ado itself is little, but in main things different...
and of course your provider is still not finished. Im affraid that you do it
in way how ib or now fb API works and did not check how other common
providers work... anyway i like your point of view and dont like to add
there new features becouse each new feature is performance hit and makes
code dirty... It like with firebird server. It have now lot of new features
but its 20% slower :(

i see that you want to make your provider as near to ADO.NET as possibe..
Its great idea. But i think, that you have to make there new layer of
codebase for example ADOFbConnection and so... Becouse there is still lot of
work in base layer... You can have to have one connection for one command
(big problem), problems with cleaning resources when i forgot dispose
something... And trying to force it to be ADO compatible will not work...

So simple as i wrote there are constructor where you assign transactions, in
this step when assigned transaction is null or not specified you create and
start new one... and when you call close or dispose you will commit or
rollback... In this case will be transaction closed by command not
connection, and is not created for each statement, so you can call prepare
many times... And oposite there is one transaction which will be closed as
command is closed (transaction is private in this case) so there will not be
problem with lot of transaction to be closed by connection...
Best way i see is create inherited class ADOFbCommand with new overloaded
constructor and new close and dispose.

Or you can replace this:
if (Transaction == null)

throw new InvalidOperationException("Command must have a valid
Transaction.");

in executeNoQuery, Scalar, Reader by



if (Transaction == null)

    Transaction = Connection.BeginTransaction();

// ofcourse you know that there is connection


you can put this only in ExecuteReader an can set behavior to
CloseConnection and there will be no problems with closing :)

As i wrote this, why near all classes are sealed???
There is lot of possibilities how to do that. Question whis is best :)

BUT PLEASE DO NOT MIX IT IN WORKING CODE, until all other required features
are implemented... i fell that it will bring lot of problems to try it make
MS compatible and will corrupt working code...

AND I WANT TO THANK YOU FOR THIS PROVIDER ITS GREAT, ITS PERFECT, ITS BEST
:) I use it every day and for now i did not find any problem which cannot be
done by this or any bug you did not correct fast...

p.

Re: [Firebird-net-provider] FBCommand.ExecuteReader and Transactions

[Carlos G. A. <car...@te...>]

Hello:

> i want to say, that adding autostart transaction support is not hard to
> implement... Simple add there new constructor for FbCommand or other
> components without transaction and in that start default transaction... in
> close method rollback or commit...

Well, my first idea was to start a new transaction in 
FbStatement.Prepare method if the command don't have a transaction yet 
and it's a select ( probably by check if CommandText start with SELECT ) 
and rollback it in Close method, but this can have problems, for example 
lots of open transactions if you left the connection to close the 
commands .....

> but this is against carlos philosophy... he dont want bind things together
> and want as few relations as possible between connection, trancation and
> command...
> And i like his aproach, im doing high performance apps, so i wand direct
> control about this...
> This is my opinion and my be im wrong, but i was speaking with carlos about
> some time ago and i observed his code a lot... Hi knows that its not hard to
> do that, but i think hi dont want do that :)

Huummm you are right, at this moment if you want to make an application 
that can work with, for example, Firebird and MS Sql Server ( or any 
other ) as database server, you can make a data access layer having in 
mind that you need to start a transaction always before executing a 
command, with this you can solve the problem, this is the reason why i 
think this is not a great problem ( i will try to make a test with MSDE 
or an evaluation version of Sql Server 2000 for being sure about it ).

> carlos if im wrong sorry...

No problem :) , i want to hear opinions about this :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FBCommand.ExecuteReader and Transactions

[Pavol S. <st...@st...>]

hallo,

i want to say, that adding autostart transaction support is not hard to
implement... Simple add there new constructor for FbCommand or other
components without transaction and in that start default transaction... in
close method rollback or commit...

but this is against carlos philosophy... he dont want bind things together
and want as few relations as possible between connection, trancation and
command...
And i like his aproach, im doing high performance apps, so i wand direct
control about this...
This is my opinion and my be im wrong, but i was speaking with carlos about
some time ago and i observed his code a lot... Hi knows that its not hard to
do that, but i think hi dont want do that :)

carlos if im wrong sorry...

p.

Re: [Firebird-net-provider] FBCommand.ExecuteReader and Transactions

[Carlos G. A. <car...@te...>]

Hello:

> While true, a number of data drivers also support implicit-start
> transaction connections.

Yes, i know, but i think there no easy solution for this and mantain 
compatibility with ADO.NET ( or i can't find one :) ), i have some 
thinks in mind but none of them is really good for me  :)


Ideas are welcome.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

RE: [Firebird-net-provider] FBCommand.ExecuteReader and Transactions

[Leyne, S. <Se...@Br...>]

Carlos,

> > Is there a reason for this different behaviour ?
>=20
> Well, i don't know how transactions work with Sql Server 2000, but in=20
> Firebird you a need always a trasaction for allow command execution (=20
> stored procs, select, insert, delete, update ).

While true, a number of data drivers also support implicit-start
transaction connections.


Sean

Re: [Firebird-net-provider] FBCommand.ExecuteReader and Transactions

[Carlos G. A. <car...@te...>]

Hello:

> Is there a reason for this different behaviour ?

Well, i don't know how transactions work with Sql Server 2000, but in 
Firebird you a need always a trasaction for allow command execution ( 
stored procs, select, insert, delete, update ).





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] FBCommand.ExecuteReader and Transactions

[Sw D. <sw...@to...>]

I'm using VB.NET to develop database applications based on Sql Server =
2000.

I wish to try Firebird as an alternative DBMS, using Firebird .Net =
Provider.

In my first test i found that the .ExecureReader method of FBCommand =
need an valid transaction object, while SqlCommand and OleDBCommand =
(from MS Sql Data Provider and Ole DB Data Provider) do not: i can open =
a connection, create a command, assign to a datareader the return value =
of ExecuteReader, without using a transaction.

Looking to the C# source code of Firebird .Net Provider, i saw that =
there is as explicit IF test for the null-transaction.

Is there a reason for this different behaviour ?

Thank you

Lorenzo Ruggeri

Re: [Firebird-net-provider] [ANN] Firebird .Net provider Release Candidate 1 available for download.

[Carlos G. A. <car...@te...>]

Hello:

> i know but this way the project will be more visible :) 
> more eyes will see the release news ... 

i know :) and how there no page for the provider i send emails to C#, 
ADO.NET, VB.NET and ASP.NET microsoft newsgroups in spanish and english 
with the announce of new releases.









Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] -lu dccil switch problems when using Firebird .net dll

[Konstantin R. <mr...@mr...>]

> Has anyone tried to compile a Delphi unit using the Firebird provider for
.net?

uses
 FirebirdSql.Data.Firebird,
 Borland.Delphi.SysUtils,
...

Firebird has to be first unit in order (don't ask me why, I have no idea)

dccasp -m -luFirebirdSql.Data.Firebird.dll unit.pas

---
Konstantin Rudenko (mr...@mr...)

Re: [Firebird-net-provider] [ANN] Firebird .Net provider Release Candidate 1 available for download.

[Marius P. A. <ma...@re...>]

i know but this way the project will be more visible :)=20
more eyes will see the release news ...=20

On Wed, 26 Mar 2003 11:42:45 +0100
Carlos Guzman Alvarez <car...@te...> wrote:

> Hello:
>=20
> > do you have a freshmeat project where to put the news ?=20
>=20
>=20
> No, but you can see it in IBPhoenix web site or you can receive a email=20
> with the notificaction of new releases if you ave a Sourceforge ID and=20
> have monitored the package.
>=20
>=20
>=20
> --
> Best regards
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.net email is sponsored by:
> The Definitive IT and Networking Event. Be There!
> NetWorld+Interop Las Vegas 2003 -- Register today!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] -lu dccil switch problems when using Firebird .net dll

[Zarko G. <del...@ab...>]

Hi all

Has anyone tried to compile a Delphi unit using the Firebird provider for
.net?

When I want to compile such a unit with

dccil -luFirebirdSql.Data.Firebird UnitName.pas

the compiler comes with several AV's and nothing happens - no dcuil for the
pas file is created.
Any suggestions?

Zarko

Re: [Firebird-net-provider] Re: [ANN] Firebird .Net provider Release Candidate 1 available for download.

[Achim K. <ach...@wi...>]

Hello,

>> I've downloaded the binary release for Win32. On Installation (Windows 
>> 2000 Prof.) I get the following errors:

[ msvcr70.dll missing ]

>
> I don't know what can be the problem, i'm testing the setup with Windows 
> 2000 + SP2 and .NET Framework v1.0.3705 and it works well.

I found a dll named msvcr70.dll in
C:\Programme\Gemeinsame_Dateien\Microsoft_Shared\Help\
and copied it to C:\WINNT\SYSTEM32. Now the installation completes.

Achim

Re: [Firebird-net-provider] [ANN] Firebird .Net provider Release Candidate 1 available for download.

[Carlos G. A. <car...@te...>]

Hello:

> do you have a freshmeat project where to put the news ? 


No, but you can see it in IBPhoenix web site or you can receive a email 
with the notificaction of new releases if you ave a Sourceforge ID and 
have monitored the package.



--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Re: [ANN] Firebird .Net provider Release Candidate 1 available for download.

[Carlos G. A. <car...@te...>]

HEllo:

>  > Firebird .Net provider Release Candidate 1 available for download.
> 
> I've downloaded the binary release for Win32. On Installation (Windows 
> 2000 Prof.) I get the following errors:


I don't know what can be the problem, i'm testing the setup with Windows 
2000 + SP2 and .NET Framework v1.0.3705 and it works well.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] Re: [ANN] Firebird .Net provider Release Candidate 1 available for download.

[Achim K. <ach...@wi...>]

Hello,

fir...@li... wrote:

 > Firebird .Net provider Release Candidate 1 available for download.

I've downloaded the binary release for Win32. On Installation (Windows 
2000 Prof.) I get the following errors:

---------------------------
gacutil.exe - DLL nicht gefunden
---------------------------
Die Dynamic Link Library MSVCR70.dll wurde nicht im angegebenen Pfad 
E:\user\kalwa\temp\14V35BS2\FirebirdNetProvider-1.0-RC1;.;C:\WINNT\System32;C:\WINNT\system;C:\WINNT;E:\D7NET\Aspx\Bin\;E:\D7NET\Aspx\Framework\;E:\D7NET\Bin\;D:\Delphi7\Bin;D:\Delphi7\Projects\Bpl\;C:\WINNT\System32\Wbem;d:\App32\Tools\PGP;Z:.;Y:.; 
gefunden.
---------------------------
OK
---------------------------

After clicking "OK" the message is:

---------------------------
Firebird .Net Data Provider Release Candidate 1
---------------------------
Cannot register assembly FirebirdSql.Data.Firebird.dll
---------------------------
OK
---------------------------

The MS .NET Framework 1.1 is installed, I use the Borland Delphi for 
.Net-Preview to play around with. Do I need to download MSVCR70.dll from 
somewhere?

Any hints?

Achim

Re: [Firebird-net-provider] [ANN] Firebird .Net provider Release Candidate 1 available for download.

[Marius P. A. <ma...@re...>]

do you have a freshmeat project where to put the news ?=20
it could be nice to have a page there :)=20


On Wed, 26 Mar 2003 00:08:25 +0100
Carlos Guzman Alvarez <car...@te...> wrote:

> Hello:
>=20
> Firebird .Net provider Release Candidate 1 available for download.
>=20
>=20
> You can view the changelog at:
>=20
> http://sourceforge.net/project/shownotes.php?release_id=3D148711
>=20
>=20
> You can download binarys at:
>=20
> http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC1.e=
xe?download
>=20
> You can download sources at:
>=20
> http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC1-S=
rc.zip?download
>=20
>=20
> You can download documentation at:
>=20
> http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC1-D=
oc.zip?download
>=20
>=20
> CVS Tag:
>=20
> NP1_0_RC1
>=20
>=20
>=20
>=20
> --
> Best regards
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.net email is sponsored by:
> The Definitive IT and Networking Event. Be There!
> NetWorld+Interop Las Vegas 2003 -- Register today!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [ANN] Firebird .Net provider Release Candidate 1 available for download.

[Carlos G. A. <car...@te...>]

Hello:

Firebird .Net provider Release Candidate 1 available for download.


You can view the changelog at:

http://sourceforge.net/project/shownotes.php?release_id=148711


You can download binarys at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC1.exe?download

You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC1-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC1-Doc.zip?download


CVS Tag:

NP1_0_RC1




--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] problem

[Carlos G.A. <car...@te...>]

Hello:

> i found there bug (may be)... when closing FbConnection.Close() and i 
> did not close and dispose FbDataReader, exception was raised... null 
> reference... 


Fixed in CVS, thanks very much.





Best regards
Carlos Guzman Alvarez
Vigo-Spain

[Firebird-net-provider] problem

[Pavol S. <pa...@st...>]

Hi,


i found there bug (may be)... when closing FbConnection.Close() and i 
did not close and dispose FbDataReader, exception was raised... null 
reference...

private void GetDBAnswer() {
            string dbCommandString = "select first 1 POLLID, TEXT, 
FINALVOTES from PollsAnswers where ID = @ID";
           
            FbConnection dbConn = new FbConnection(dbConnectionString);
            try {
                dbConn.Open();
               
                FbTransaction dbTran = dbConn.BeginTransaction();
                try {
                    FbCommand dbComm = new FbCommand(dbCommandString, 
dbConn, dbTran);
                    try {
                        dbComm.Parameters.Clear();
                        dbComm.Parameters.Add("@ID", id);
                       
                        FbDataReader dbData = dbComm.ExecuteReader();
                        try {
                            if (dbData.Read()) {
                                pollId = dbData.GetInt32(0);
                                text = dbData.GetString(1);
                                finalVotes = dbData.GetInt32(2);
                            }
                        }
                        finally {
//MARK                            dbData.Close();
//MARK                            dbData.Dispose();
                        }
                    }
                    finally {
                        dbComm.Dispose();
                    }
                }
                finally {
                    dbTran.Commit();
                    dbTran.Dispose();
                }
            }
            finally {
                dbConn.Close();
            }
        }

ir two marked lines was not there exception was raised, and when i added 
that lines everything is ok...

thanx
p.

[Firebird-net-provider] Re: Suggestion for Firebird .Net Data Provider beta 4

[Carlos G. A. <car...@te...>]

Hello:

 >Current implementation of Firebird .Net provider forces usage of 
 >transactions for ExecuteScalar and ExecuteReader. In my oppinion, 
 >using transactions should be mandatory only for ExecuteNonQuery method 
 >(INSERT, UPDATE, DELETE statements etc.) as in Microsoft's 
 >implementation of Odbc and Sql data providers. For example, Easysoft 
 >ODBC driver for Interbase/Firebird does not require transactions in 
 >order to execute ExecuteReader and ExecuteScalar methods which is, I 
 >think, desirable behaviour.

 >This incompatibility makes hard to develop generic (data provider 
 >independent code) which is Interface based.

For ExecuteScalar it can be of interest, but for ExecuteReader i need to 
make some test making update, delete and insert operations using a 
DataAdapter, i tell this because as i remember DbDataAdapter make calls 
to ExecuteReader instead of ExecuteNonQuery, but i want to verify it.


Any thoughts ???


 >2) Small issue in ExecuteNonQuery() method in FbCommand class.

 >According to documentation:

 >For UPDATE, INSERT, and DELETE statements, the return value is the 
 >number of rows affected by the command. For all other types of 
 >statements, the return value is -1.

 >But, it appears that when no records are affected in UPDATE opperation 
 >(I haven't checked other SQL statements) return value is -1 instead of >0.

Fixed in CVS, please if yo can test it, i will try to make a NUnit test 
tomorrow.






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] exception by fb1.5 win beta4

[Karl S. <web...@st...>]

"Carlos Guzman Alvarez" <car...@te...> schrieb im Newsbeitrag
news:3E7...@te......
> Hello:
>
> > string myInsertQuery = "INSERT INTO PROJECT(proj_id, proj_name, product)
> > Values('test', '.Net Provider', 'N/A')";
>
> proj_id field accepts only uppercase values try using:

>
> string myInsertQuery = "INSERT INTO PROJECT(proj_id, proj_name, product)
> Values('TEST', '.Net Provider', 'N/A')";
>
>

Like always,

that was it

thanks :-)

KS