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

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

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

Hello:

> Can you please fix this ?

I'm going to add some changes to this, now FbCommand.NextResult will be:

internal bool NextResult()
{
	bool returnValue = false;

	actualCommand++;

	if (actualCommand >= commands.Length)
	{
		actualCommand--;
	}
	else
	{
		string commandText = commands[actualCommand];

		if (commandText != null &&
		commandText.Trim().Length > 0)
		{
			statement.Drop();
			statement = null;

			InternalPrepare();
			InternalExecute();
	
			returnValue = true;
		}
	}

	return returnValue;
}




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."
Albert Einstein.

[Firebird-net-provider] Developement status report

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

Hello:

First of all i want to suggest to all people that is using 1.5 version 
to upgrade to the latest version using CVS sources, i'm thinking in 
release next version soon, but until it's released it's better to be 
working with the latest version from CVS.


MONO
----

1. Information about the Firebird Data Provider at mono:: project web 
site has been update, you can see it here:

	http://www.go-mono.com/firebird.html

2. Named parameters. I have made some little tests of named parameters 
feature with mono 0.28 on linux and seems to be working now, for more 
information you can see this:

	http://bugzilla.ximian.com/show_bug.cgi?id=48666

3- Linux makefile. I have made some changes to the linux makefile for 
make the build of the NUnit test suite.

4. Exception formatting. Exceptions will be correct formatted in mono.


Development
------------

1. Build system. I have make some rework to the nant build files, now 
versions for MS .NET 1.0, MS .NET 1.1 and mono will be built at the same 
time with the same nant script.

2. Implicit transaction support. I have made a change to the implicit 
transaction support for make that commands without a transaction 
(explicit) can't be executed when the command connection have a active 
transaction that is not updated ( committed or roll backed ).

3. Firebird services implementation. A minor fix has been added to the 
FbService class for make the attachment in the same way as in old 1.1
sources.

4. Firebird Events implementation. A minor change has been added to the 
synchronization code.

5. Blob and array fields. Now it's possible to retrieve the value of 
blob and array fields as result of FbCommand.ExecuteScalar method, and 
as result of output parameters of stored procedure execution, for this i 
have added a new class to the GDS implementation called GdsValue.cs.

6. Design time support. Design time support for FbParameterCollection 
has been improved, for this there are two new classes:

	FbParameterCollectionEditor.cs

	FbParameterConverter.cs

Toolbox images now have transparent background.

( Thanks to Luciano Passuello for his feedback on this issue )

7. Cursor name property. FbCommand.CursorName property has been removed.


8. Command builder. Update and delete commands are now generated in 
different way ( similar to SqlClient and OleDb providers )

Example of Update Command:

UPDATE "TEST_TABLE_01" SET "INT_FIELD" = ?, "CHAR_FIELD" = ?, 
"VARCHAR_FIELD" = ?, "BIGINT_FIELD" = ?, "SMALLINT_FIELD" = ?, 
"DOUBLE_FIELD" = ?, "NUMERIC_FIELD" = ?, "DECIMAL_FIELD" = ?, 
"DATE_FIELD" = ?, "TIME_FIELD" = ?, "TIMESTAMP_FIELD" = ?, "CLOB_FIELD" 
= ?, "BLOB_FIELD" = ?, "IARRAY_FIELD" = ?, "SARRAY_FIELD" = ?, 
"LARRAY_FIELD" = ?, "FARRAY_FIELD" = ?, "BARRAY_FIELD" = ?, 
"NARRAY_FIELD" = ?, "DARRAY_FIELD" = ?, "TARRAY_FIELD" = ?, 
"TSARRAY_FIELD" = ?, "CARRAY_FIELD" = ?, "VARRAY_FIELD" = ?, "BIG_ARRAY" 
= ? WHERE ( ("INT_FIELD" = ?) AND (("CHAR_FIELD" IS NULL) OR 
("CHAR_FIELD" = ?)) AND (("VARCHAR_FIELD" IS NULL) OR ("VARCHAR_FIELD" = 
?)) AND (("BIGINT_FIELD" IS NULL) OR ("BIGINT_FIELD" = ?)) AND 
(("SMALLINT_FIELD" IS NULL) OR ("SMALLINT_FIELD" = ?)) AND 
(("DOUBLE_FIELD" IS NULL) OR ("DOUBLE_FIELD" = ?)) AND (("NUMERIC_FIELD" 
IS NULL) OR ("NUMERIC_FIELD" = ?)) AND (("DECIMAL_FIELD" IS NULL) OR 
("DECIMAL_FIELD" = ?)) AND (("DATE_FIELD" IS NULL) OR ("DATE_FIELD" = 
?)) AND (("TIME_FIELD" IS NULL) OR ("TIME_FIELD" = ?)) AND 
(("TIMESTAMP_FIELD" IS NULL) OR ("TIMESTAMP_FIELD" = ?)) AND 
(("EXPR_FIELD" IS NULL) OR ("EXPR_FIELD" = ?)) )



Example of Delete Command:

DELETE FROM "TEST_TABLE_01" WHERE ( ("INT_FIELD" = ?) AND (("CHAR_FIELD" 
IS NULL) OR ("CHAR_FIELD" = ?)) AND (("VARCHAR_FIELD" IS NULL) OR 
("VARCHAR_FIELD" = ?)) AND (("BIGINT_FIELD" IS NULL) OR ("BIGINT_FIELD" 
= ?)) AND (("SMALLINT_FIELD" IS NULL) OR ("SMALLINT_FIELD" = ?)) AND 
(("DOUBLE_FIELD" IS NULL) OR ("DOUBLE_FIELD" = ?)) AND (("NUMERIC_FIELD" 
IS NULL) OR ("NUMERIC_FIELD" = ?)) AND (("DECIMAL_FIELD" IS NULL) OR 
("DECIMAL_FIELD" = ?)) AND (("DATE_FIELD" IS NULL) OR ("DATE_FIELD" = 
?)) AND (("TIME_FIELD" IS NULL) OR ("TIME_FIELD" = ?)) AND 
(("TIMESTAMP_FIELD" IS NULL) OR ("TIMESTAMP_FIELD" = ?)) AND 
(("EXPR_FIELD" IS NULL) OR ("EXPR_FIELD" = ?)) )




Example of Insert Command:

INSERT INTO "TEST_TABLE_01" ("INT_FIELD", "CHAR_FIELD", "VARCHAR_FIELD", 
"BIGINT_FIELD", "SMALLINT_FIELD", "DOUBLE_FIELD", "NUMERIC_FIELD", 
"DECIMAL_FIELD", "DATE_FIELD", "TIME_FIELD", "TIMESTAMP_FIELD", 
"CLOB_FIELD", "BLOB_FIELD", "IARRAY_FIELD", "SARRAY_FIELD", 
"LARRAY_FIELD", "FARRAY_FIELD", "BARRAY_FIELD", "NARRAY_FIELD", 
"DARRAY_FIELD", "TARRAY_FIELD", "TSARRAY_FIELD", "CARRAY_FIELD", 
"VARRAY_FIELD", "BIG_ARRAY") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)





Thanks to all people that is using, testing and reporting issues about 
the Firebird .NET Data Provider.

As always all comments and suggestions are wellcome.






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

[mailmur <ma...@ya...>]

>> Firebird cannot run simple compound queries such
>> as "INSERT... ; UPDATE...;" in one go through
>> executequery.

> But it can't be executed using executenonquery
> because Firebid server 
> doesn't support batch command execution ;)

Yes, I know. Thats why I expressed my feelings on this
case ;-)

It will often complicates the clientside programs to
overcome this lack of FB feature. If I am right, a
sort of workaround is to create stored procedures for
such operations.

But if batch queries are dynamically generated on fly
and varies heavily based on business logic, then
storedprocs are not a solution. Implementing dynamic
queries at serverside are very very tricky. 

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

[Pierre A. <pie...@op...>]

Carlos Guzman Alvarez wrote:

> Try this:
> 
> FbTransaction transaction = connection.BeginTransaction();
> 
> string sql = "CREATE TABLE A(F1 INTEGER NOT NULL, F2 INTEGER NOT NULL);"
> + "ALTER TABLE A ADD CONSTRAINT PK_A PRIMARY KEY (F1, F2);";
> 
> FbCommand command = new FbCommand(sql, connection, transaction);
> 
> FbDataReader reader = command.ExecuteReader();
> while (reader.NextResult())
> {
> }
> 
> reader.Close();
> transaction.Commit();

It crashes on the second call to NextResult, at FbCommand.cs:588,
with commandText == null. The 'if (commandText.Length > 0)' can
not execute; if I replace it with :

if ((commandText != null) && (commandText.Length > 0))

then it works.

Can you please fix this ?


And I still do not understand why calling reader.Read() would
crash ?

    Pierre

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

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

Hello:


> I can confirm that following code does not work:

Try this:

FbTransaction transaction = connection.BeginTransaction();

string sql = "CREATE TABLE A(F1 INTEGER NOT NULL, F2 INTEGER NOT NULL);" 
+ "ALTER TABLE A ADD CONSTRAINT PK_A PRIMARY KEY (F1, F2);";
			
FbCommand command = new FbCommand(sql, connection, transaction);

FbDataReader reader = command.ExecuteReader();
while (reader.NextResult())
{
}

reader.Close();
transaction.Commit();






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

[Pierre A. <pie...@op...>]

> Can you etst this using the latest CVS sources ??

OK. I've been able to download CVS sources. Last entry in
Changelog is dated 2003-10-04.


I can confirm that following code does not work:

   command.CommandType = System.Data.CommandType.Text;
   command.CommandText =
    "CREATE TABLE A(F1 INTEGER NOT NULL, F2 INTEGER NOT NULL);" +
    "ALTER TABLE A ADD CONSTRAINT PK_A PRIMARY KEY (F1, F2);";
   command.Transaction = my_transaction;

   reader = command.ExecuteReader ();

   for (;;)
   {
     while (reader.Read ())
     {
       System.Console.Out.WriteLine ("{0} columns found.",
                                     reader.FieldCount);
     }
     if (reader.NextResult () == false)
     {
       break;
     }
   }
   reader.Close ();

I get an exception thrown in the first call to Read() with
"invalid request handle" as explanation.

I get the following trace:

    Read()
      GdsStatement.Fetch, line 523
        GdsAttachment.ReceiveResponse, line 319
          GdsAttachment.ReadStatusVector, line 222

    with arg = 0x1 and er  = 0x14000007

Do you have any idea how to fix this ?

    Pierre

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

[Pierre A. <pie...@op...>]

Carlos Guzman Alvarez wrote:

>> Why do I get an invalid request handle if the command has not produced
>> any results ? I'd rather expect Read to return false.
>
> Can you etst this using the latest CVS sources ??

I have not been able to connect to CVS today. Can you please send
me either the .NET 1.1 binaries, or the current sources and I will
be glad to check.

> jeje I mean if you are using 1.5 Alpha 1, 1.5 Alpha2, 1.5 Beta 1, etc.. :)

I don't remember :-(

Re: [Firebird-net-provider] SP execute error, when in SP name i'm

[olegmad <ol...@ya...>]

> Can you send a test case ?? The change in the name can be only a case
> question in the exception message ( DeriveParameters doesn't cange this )

DeriveParameters doesn't change - a know it.
I give that example, just to show you, what my code don't have errors, my SP
really exist and work correctly.

When dbCommand.ExecuteReader() fire, on the some level procedure name comed
to hi case. I try to find this in source code, but for the current moment
don't find this place.

Simple example:
Create empty SP with any low case name (f.e. mystoredproc).
and try execute it...

Thanks.

Re: [Firebird-net-provider] SP execute error, when in SP name i'm use mix case.

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

Hello:

> Look on SP name!!! It's in hi case!

Can you send a test case ?? The change in the name can be only a case 
question in the exception message ( DeriveParameters doesn't cange this )



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

Re: [Firebird-net-provider] SP execute error, when in SP name i'm use mix case.

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

Hello:

> An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException'
> occurred in
> 
> -----------------------------------------
> 
> firebirdsql.data.firebird.dll
> 
> Additional information: Dynamic SQL Error
> SQL error code = -204
> Procedure unknown
> GETSOMETHING
> 
> -----------------------------------------

I will try to take a look at this later today thanks



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."
Albert Einstein.

[Firebird-net-provider] SP execute error, when in SP name i'm use mix case.

[olegmad <ol...@ya...>]

Hi, again!

I have SP, named "GetSomething" (mix case!)
when i derive parameters from SP - all ok.

FbCommand dbCommand = connection.CreateCommand();
dbCommand.CommandText = "GetSomething";

dbCommand.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(dbCommand);



But! When i try execute this SP.

dbCommand.ExecuteReader();

 I catch this exception:

----------------------------------------

An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException'
occurred in

-----------------------------------------

firebirdsql.data.firebird.dll

Additional information: Dynamic SQL Error
SQL error code = -204
Procedure unknown
GETSOMETHING

-----------------------------------------

Look on SP name!!! It's in hi case!



Thanks.... Bye.

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

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

Hello:

> Firebird cannot run simple compound queries such as
> "INSERT... ; UPDATE...;" in one go through
> executequery.

But it can't be executed using executenonquery because Firebid server 
doesn't support batch command execution ;)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

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

Hello:

> Well, FbScript is not an option, since it does not have the IDbCommand
> interface. I'd like to be able to define the parameters for my multiple
> commands once, then let it execute everything in one call.

Ok.

> The second solution, using ExecuteReader, almost works. It feels strange
> to have to use it, since both commands above don't return any results.

If i'm not wring this the only way for exec batch commands in ADO.NET

> Why do I get an invalid request handle if the command has not produced
> any results ? I'd rather expect Read to return false.


Can you etst this using the latest CVS sources ??

I can send to you a dll built with .net 1.0 or a zip with the sources if 
needed.

> I am using assembly version 1.5.1333.25082.

jeje I mean if you are using 1.5 Alpha 1, 1.5 Alpha2, 1.5 Beta 1, etc.. :)


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

[mailmur <ma...@ya...>]

[slightly offtopic comment]
This is what I've always found MSSQLServer to be one
of the best dbserver atm. It can run an arbitrary
script queries just fine through a normal executequery
commands.

Firebird cannot run simple compound queries such as
"INSERT... ; UPDATE...;" in one go through
executequery.

> >> I'd like to do the following using a single
> FbCommand object :
> >> 
> >> "CREATE TABLE Test(ID INTEGER NOT NULL,
> >>                    REV INTEGER NOT NULL,
> >>                    DATA VARCHAR(100) CHARACTER
> SET UNICODE_FSS);
> >> 
> >>  ALTER TABLE Test ADD CONSTRAINT PK_TEST PRIMARY
> KEY (ID, REV);"
> [...]
> > You have two ways use the FbScript class, or use
> FbCommand.ExecuteReader
> > and FbDataReader.NextResult.
> 
> Well, FbScript is not an option, since it does not
> have the IDbCommand
> interface. I'd like to be able to define the
> parameters for my multiple
> commands once, then let it execute everything in one
> call.
> 
> The second solution, using ExecuteReader, almost
> works. It feels strange
> to have to use it, since both commands above don't
> return any results.
> Moreover, if I do :
> 
> for (;;)
> {
>     while (reader.Read ())
>     {
>         ...
>     }
>     if (! reader.NextResult ()) break;
> }
> 
> Then I get an exception on "Read", telling me
> "invalid request handle".
> If I drop the reader.Read (), then it will be OK.
> 
> Why do I get an invalid request handle if the
> command has not produced
> any results ? I'd rather expect Read to return
> false.
> 
> > Which version of the .NET Provider are you using
> ??
> 
> I am using assembly version 1.5.1333.25082.

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

[Pierre A. <pie...@op...>]

>> I'd like to do the following using a single FbCommand object :
>> 
>> "CREATE TABLE Test(ID INTEGER NOT NULL,
>>                    REV INTEGER NOT NULL,
>>                    DATA VARCHAR(100) CHARACTER SET UNICODE_FSS);
>> 
>>  ALTER TABLE Test ADD CONSTRAINT PK_TEST PRIMARY KEY (ID, REV);"
[...]
> You have two ways use the FbScript class, or use FbCommand.ExecuteReader
> and FbDataReader.NextResult.

Well, FbScript is not an option, since it does not have the IDbCommand
interface. I'd like to be able to define the parameters for my multiple
commands once, then let it execute everything in one call.

The second solution, using ExecuteReader, almost works. It feels strange
to have to use it, since both commands above don't return any results.
Moreover, if I do :

for (;;)
{
    while (reader.Read ())
    {
        ...
    }
    if (! reader.NextResult ()) break;
}

Then I get an exception on "Read", telling me "invalid request handle".
If I drop the reader.Read (), then it will be OK.

Why do I get an invalid request handle if the command has not produced
any results ? I'd rather expect Read to return false.

> Which version of the .NET Provider are you using ??

I am using assembly version 1.5.1333.25082.


    Pierre

Re: [Firebird-net-provider] FBBackup Class: Incremental Backup?

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

Hello:

> The FBBackup class works well so as FBRestore. Although rite now I have only
> tried it for small database... around 15-20 tables. Are there any issues
> known, if backing up large databases would be a problem? .. say around 150
> tables.

I think there will be no problems, in any case test it and comment here 
the results :) i will try to do a test wil a database with 130 tables 
that i have :)

> Also I needed to know about incremental backups. Is there a way to do an
> incremental backup rather than backing up the full database always.

No ( the FbBackup database implement the Firebird Backup Service. )



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

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

Hello:

> I'd like to do the following using a single FbCommand object :
> 
> "CREATE TABLE Test(ID INTEGER NOT NULL,
>                    REV INTEGER NOT NULL,
>                    DATA VARCHAR(100) CHARACTER SET UNICODE_FSS);
> 
>  ALTER TABLE Test ADD CONSTRAINT PK_TEST PRIMARY KEY (ID, REV);"
> 
> Is this possible ? If so, can I do it ? I tried to define the
> command text to be exactly as above, and it executes fine. However,
> when I check with IB Expert, I don't see the PK_TEST constraint.
> 
> It is as if it had not been processed by the command.
> 
> Any ideas ?


You have two ways use the FbScript class, or use FbCommand.ExecuteReader 
and FbDataReader.NextResult.

Which version of the .NET Provider are you using ??


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

[Firebird-net-provider] How can I execute several commands in a single FbCommand object

[Pierre A. <pie...@op...>]

Hello,

I'd like to do the following using a single FbCommand object :

"CREATE TABLE Test(ID INTEGER NOT NULL,
                   REV INTEGER NOT NULL,
                   DATA VARCHAR(100) CHARACTER SET UNICODE_FSS);

 ALTER TABLE Test ADD CONSTRAINT PK_TEST PRIMARY KEY (ID, REV);"

Is this possible ? If so, can I do it ? I tried to define the
command text to be exactly as above, and it executes fine. However,
when I check with IB Expert, I don't see the PK_TEST constraint.

It is as if it had not been processed by the command.

Any ideas ?

    Pierre

[Firebird-net-provider] FBBackup Class: Incremental Backup?

[Samrat G. <sg...@he...>]

Hi,

The FBBackup class works well so as FBRestore. Although rite now I have only
tried it for small database... around 15-20 tables. Are there any issues
known, if backing up large databases would be a problem? .. say around 150
tables.

Also I needed to know about incremental backups. Is there a way to do an
incremental backup rather than backing up the full database always.

Regards,
Sam.

Re: [Firebird-net-provider] Dataset Update and Blob type memo.

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

Hello:

> I just build new version Provider from CVS and it works.

Great !!

> Sorry for incompetence .

No problem :)

> Thanks for great work.

Thanks to you.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

Re: [Firebird-net-provider] Dataset Update and Blob type memo.

[Martin R. <ne...@mi...>]

Hi,
I just build new version Provider from CVS and it works.
Sorry for incompetence .

Thanks for great work.

Martin Radvansky

Re: [Firebird-net-provider] Dataset Update and Blob type memo.

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

Hello:

> Does anybody any idea about this?

Can you send a test case ??




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

[Firebird-net-provider] Dataset Update and Blob type memo.

[Martin R. <ne...@mi...>]

Hi,
I try update database from my program by use command of dataset UPDATE.

At first I create dataset and table by fill table from FB1.5
In the form I can show data from this table. One field is Blob type memo.
After fill is the column in the table binding to the blob field.
The column in the table is type string.
When I use Dataset.Update("TABLE") then I get
error:
Object reference not set to an instance of an object.
When I don't update BlobField the update command work good.
Does anybody any idea about this?

Thank you very much.

Best regards
Martin Radvansky

Re: [Firebird-net-provider] Error inserting into Firebird. Code is below.

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

Hello:

> I sent the previous email. here is the code I used:

I have made a initial test using the AS3AP benchmark suite, using the 
4mb database ( 10000 records per table for 4 tables ) running in local, 
and working well, i will try to make more tests tomorrow using anything 
similar to your code.







-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.

Re: [Firebird-net-provider] Error using Firebird

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

Hello:

 > Insert error using .net provider W/ 1.5rc6
 >
 > I'm operating under Windows XP using C# along with the Firebird .net 
1.5 beta 1 provider. I'm currently just testing to determine suitability 
for some projects. I'm trying to create some tables, and insert data 
into them.
 >
 > I get an error "Unable to complete network request to host 
\"localhost\"".
 >
 > It usually occurs after inserting a couple thousand rows. If I debug, 
and breakpoint at several points, it doesn't seem to occur.
 >
 > Do I need to wrap all commands in a "transaction"? For this test I 
was using the ExecuteNonQuery method of the Command object, but without 
a transaction.


In first place no, can you send a test case ??,

The only thing that you need to have in mind when using implicit 
transactions is that the transaction is not committed until the command 
is disposed.

I will try to make a test using the AS3AP test suite tomorrow ( this can 
do a variable number of inserts and i can modify it for use implicit 
transactions ).




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain