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

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

[scampbell120012000 <sca...@ya...>]

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

public static int ExecuteNonQueryFB(string connectionString, string sql)
{
int retval = 0;
try
{
	using (FbConnection conn = new FbConnection(connectionString))
	{
		conn.Open();
		using (FbCommand cmd = new FbCommand(sql, conn))
		{
			cmd.CommandType = CommandType.Text;
			retval = cmd.ExecuteNonQuery();
		}
	}
}
catch(Exception ex)
{
	 throw new CustomAppException("Error=" + ex.Message);
}
return retval;
}

[Firebird-net-provider] Error using Firebird

[scampbell120012000 <sca...@ya...>]

I'm operating Firebird 1.5 rc6 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.

Re: [Firebird-net-provider] Insert error using .net provider W/ 1.5rc6

[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


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

Albert Einstein.

[Firebird-net-provider] Insert error using .net provider W/ 1.5rc6

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

A question from  firebird forum 

http://forums.devshed.com/t88807/s.html

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.

Re: [Firebird-net-provider] Stored Procedure (receiving binary data in output param)

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

Hello:

> Can anybody help me?!
> Can i recieve binary data in output parameter???

I have the change done but it needs testing, it's a big change and it's 
not definitive ( i'm thinking in better ways of make this ), it will 
allow to return correct values for output parameters and ExecuteScalar 
method.

I'm going to tag actual CVS sources (NP_1_5_Pre_Beta_3) and then commit 
this change.


All comments arround this change 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] Stored Procedure (receiving binary data in output param)

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

Hello:

> When i use SP and receive output parameters (i'm using
> fbCommand.ExecuteNonQuery() method), i can't get parameter if he has type
> 'bynary'. it contains int64 !!! why???

Ok this can be the blob id :) i need to read blob data in this case, i'm 
going to see this later today and add an nunit test for this if it's needed.


> Thanks. 

Thanks to you :)

> And sorry for my bas english :)

No problem, my english is very poor :)


-- 
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] Stored Procedure (receiving binary data in output param)

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

I have a problem:

When i use SP and receive output parameters (i'm using
fbCommand.ExecuteNonQuery() method), i can't get parameter if he has type
'bynary'. it contains int64 !!! why???

And when i use SP with DataReader - all ok.
I receive him and he has type 'byte[]'

Can anybody help me?!
Can i recieve binary data in output parameter???

Thanks. And sorry for my bas english :)

Re: [Firebird-net-provider] (no subject)

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

Hello:

> can provide example code.

A sample from the NUnit test suite for binary blob write & read:

public void BinaryBlobTest()
{
	int id_value = System.DateTime.Now.Millisecond;
			
	string selectText = "SELECT blob_field FROM test_table_01 WHERE 
int_field = " + id_value.ToString();
	string insertText = "INSERT INTO test_table_01 (int_field, blob_field) 
values(@int_field, @blob_field)";
			
	Console.WriteLine("\r\n\r\nBinary Blob Test");
	
	Console.WriteLine("Generating an array of temp data");

	// Generate an array of temp data
	byte[] insert_values = new byte[100000*4];
	RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();
	rng.GetBytes(insert_values);
			
	Console.WriteLine("Executing insert command");

	// Execute insert command
	FbCommand insert = new FbCommand(insertText, connection, transaction);
	insert.Parameters.Add("@int_field", FbDbType.Integer).Value = id_value;
	insert.Parameters.Add("@blob_field", FbDbType.Binary).Value = 
insert_values;
	insert.ExecuteNonQuery();

	transaction.Commit();

	Console.WriteLine("Checking inserted values");

	// Check that inserted values are correct
	FbCommand select = new FbCommand(selectText, connection);
	FbDataReader reader = select.ExecuteReader();			
	if (reader.Read())
	{
		if (!reader.IsDBNull(0))
		{
			byte[] select_values = (byte[])reader[0];
										
			for (int i = 0; i < insert_values.Length; i++)
			{
				if (insert_values[i] != select_values[i])
				{
					throw new Exception("differences at index " + i.ToString());
				}
			}
		}
	}

	Console.WriteLine("Finishing test");
	reader.Close();

	// Start a new Transaction
	transaction = connection.BeginTransaction();
}




-- 
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] (no subject)

[Navneet B. <nbh...@he...>]

Hi,

I have a field where I want to store Image.
This image can be of any size between 4KB to 100 KB.

I want to store this image into the firebird database, I read through 
the documentation and was very confused regarding the segment and 
reading and writing one segment at a time.

I have a stream in .NET which has the image.

I am confused about the following things.

1. What segment size should i define.
2. How do i read the data using .NET provider (with supose I define 
the segment size to 10KB)
3. How do I write the data to the database with .NET provider with 
insert command.
4. How do I write a procedure to insert the image to the database.
5. How do I write the data to the database with .NET provider with 
procedure.

Can anyone please help me with this. It would be really great if you 
can provide example code.

Thanks and Regards
Navneet Bhartia

Re: [Firebird-net-provider] Re: backup database error....

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

Hello:

> Do you know why the backup only work when I remove these options?

I have added little fix to FbService.Open method for make it to work as 
in old 1.1 version, it's on CVS yet.




-- 
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] Re: backup database error....

[Thomas J. <ja...@ma...>]

Hi Carlos

Version 1.5 (Beta 1 ( 2003-09-18 )) and=20
Firebird-1.5.0.3815_RC6_win32

Running as SuperServer.

When I remove this line:
backupSvc.Options =3D FbBackupFlags.IgnoreLimbo|
FbBackupFlags.NoGarbageCollect |
FbBackupFlags.MetaDataOnly;

then I can make a complete backup.

Any idea?


But when I try to open the backup-database I get this error:
Error while testing connection: ISC ERROR CODE: 335544323

ISC ERROR MESSAGE:
file c:\testbackup.gdb is not a valid database

Any idea why?


/Thomas

Re: [Firebird-net-provider] backup database error....

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

Hello:

> Firebird-1.5.0.3815_RC6_win32

Running as SuperSerer or Classic Server ??


Here is the test case that i'm using ??

string database = @"c:\bugtracker.fdb";

FbBackup backupSvc = new FbBackup();
			
backupSvc.UserName 	= "SYSDBA";
backupSvc.UserPassword 	= "masterkey";
			
backupSvc.Database = database;
backupSvc.BackupFiles.Add(new FbBackupFile(@"c:\testdb.gbk", 2048));
backupSvc.Verbose = true;
			
backupSvc.Options = FbBackupFlags.IgnoreLimbo|
FbBackupFlags.NoGarbageCollect |
FbBackupFlags.MetaDataOnly;
			
backupSvc.Start();

string lineOutput;
while((lineOutput = backupSvc.GetNextLine()) != null)
{
	Console.WriteLine(lineOutput);
}

backupSvc.Close();		




-- 
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] backup database error....

[Thomas <ja...@ma...>]

Hi Carlos:

I use:
Version 1.5 (Beta 1 ( 2003-09-18 )) and=20
Firebird-1.5.0.3815_RC6_win32


/Thomas

Re: [Firebird-net-provider] backup database error....

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

Hello:

> When I try to backup a database I get this error:
> {"No message for code 472 found.\nNo message for code 243 found.\n" }
> in this line: fbBackup.Start();

I have made some tests having o problem ( Firebird 1.5 SS RC6 & Firebird 
Data Provider 1.5 from CVS ), wich version of Firebird and Data 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.

Re: [Firebird-net-provider] Build and install Questions

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

Hello:

> I have downloaded NANT and the source... couple of questions
> I modified the nant config to use .NET 1.1 - it compiles but the test units
> fail (can't find a build log to see more detail as to why)

You can try using -verbose option, do you have nunit installed ??

> Firing NANT in the NETFirebird_15 dir does not work as documented since
> there is a mono.build file as well.. i.e. the .build file needs to be
> specified

Use -f:buildfile or use one of the .bat files that are in the 
NETFirebird_15 directory.

I suggest you to get the sources from the CVS, if you can, to test the 
build with the new build file.

> The build also goes thru OK except for the test units.
> Finally - I have a dll built but not sure how to actually install this into
> the managed code area so I can see it in the class browser..

If you want to install it in the GAC use GACUTIL.EXE


-- 
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] Build and install Questions

[Alan M. <al...@me...>]

Carlos,
I have downloaded NANT and the source... couple of questions
I modified the nant config to use .NET 1.1 - it compiles but the test units
fail (can't find a build log to see more detail as to why)
Firing NANT in the NETFirebird_15 dir does not work as documented since
there is a mono.build file as well.. i.e. the .build file needs to be
specified
The build also goes thru OK except for the test units.
Finally - I have a dll built but not sure how to actually install this into
the managed code area so I can see it in the class browser..

could you throw me some crumbs (hints) as to what I need to do to get around
these issues?
thanks
Alan

[Firebird-net-provider] backup database error....

[Thomas <ja...@ma...>]

When I try to backup a database I get this error:
{"No message for code 472 found.\nNo message for code 243 found.\n" }
in this line: fbBackup.Start();


Code:
....
FirebirdSql.Data.Firebird.Services.FbBackup fbBackup =3D new FbBackup(); =


bool res =3D true;

try

{

fbBackup.Verbose =3D true;


fbBackup.UserName =3D user;

fbBackup.UserPassword =3D password;

fbBackup.Database =3D @"C:\Test\dbBackup.GDB";

fbBackup.Options =3D FbBackupFlags.IgnoreLimbo;

fbBackup.BackupFiles.Add(new FbBackupFile(backupPath+backFileName, =
2048));=20

fbBackup.Start();

string lineOutput;

while((lineOutput =3D fbBackup.GetNextLine()) !=3D null)

{

Console.WriteLine(lineOutput);

}

fbBackup.Close();

}

catch (Exception ex)

{

MessageBox.Show(ex.StackTrace.ToString());

res =3D false;

}



.....



Any help?

Regards
Thomas

Re: [Firebird-net-provider] MONO

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

Hello:

> At this moment if i'm not wrong mayor problem is with the implementation 
> of Regex class in mono that is not complete and doesn't allow named 
> params to be used 

Tis problem seems to be fixed on mono 0.28




-- 
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] alter table, create table and drop table?

[<ait...@gm...>]

Hi Thomas,

By the same way, using FbCommand.ExecuteNonQuery(). The following code
adds a new column to a table:


// Open connection
FbConnection myConnection =3D new FbConnection(myConnectionString);
myConnection.Open();

// Init transaction
FbTransaction myTransaction =3D myConnection.BeginTransaction();

// Command
FbCommand myCommand =3D new FbCommand();
myCommand.CommandText =3D "alter table MY_TABLE add NEW_COLUMN blob";
myCommand.Connection =3D myConnection;
myCommand.Transaction =3D myTransaction;

// Execute Update
myCommand.ExecuteNonQuery();

// Commit changes
myTransaction.Commit();

// Free command resources in Firebird Server
myCommand.Dispose();

// Close connection
myConnection.Close();



Regards,
Aitor.




-----Mensaje original-----
De: fir...@li...
[mailto:fir...@li...] En nombre de
Thomas Juul
Enviado el: mi=E9rcoles, 01 de octubre de 2003 0:27
Para: fir...@li...
Asunto: [Firebird-net-provider] alter table, create table and drop
table?

To update, insert and delete table I use the FbCommand.
=A0
But how do a make a ALTER Table, CREATE table or a DROP table ?
=A0
Regards
Thomas

[Firebird-net-provider] alter table, create table and drop table?

[Thomas J. <ja...@ma...>]

To update, insert and delete table I use the FbCommand.

But how do a make a ALTER Table, CREATE table or a DROP table ?

Regards
Thomas

Re: [Firebird-net-provider] [Firebid-net-provider] TableMappings

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

Hi,
Yes it is.
It is resolve me problem.
I try it again.

Thanks.

"Carlos Guzman Alvarez" <car...@te...> píse v diskusním príspevku
news:3F7...@te......
> Hello:
>
>
> I think i have a sample working now ( i have made a test with SqlClient
> and it works too ) :
>
>
> DataSet ds = new DataSet("Areas");
>
> adapter.TableMappings.Add("Areas", "BugAreas");
> adapter.TableMappings["Areas"].ColumnMappings.Add("IDAREA", "Id");
> adapter.TableMappings["Areas"].ColumnMappings.Add("NAME", "Nombre");
> adapter.Fill(ds, "Areas");
> Console.WriteLine(ds.Tables["BugAreas"].Rows[0]["Nombre"]);
>
>
> Please tell to me if this is what you need to do :).
>
>
>
> -- 
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] [Firebid-net-provider] TableMappings

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

Hello:


I think i have a sample working now ( i have made a test with SqlClient 
and it works too ) :


DataSet ds = new DataSet("Areas");

adapter.TableMappings.Add("Areas", "BugAreas");
adapter.TableMappings["Areas"].ColumnMappings.Add("IDAREA", "Id");
adapter.TableMappings["Areas"].ColumnMappings.Add("NAME", "Nombre");
adapter.Fill(ds, "Areas");
			Console.WriteLine(ds.Tables["BugAreas"].Rows[0]["Nombre"]);


Please tell to me if this is what you need to do :).



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Exception: A transaction is currently active....

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

Hello:

> I sometimes get this exception:
> 
> "A transaction is currently active. Parallel transactions are not supported."
> 
> I am pretty sure that I only have one transactions i use.
> 
> Any idea why I get this exception?
> 
> I am using version 1.5 Beta 1 ( 2003-09-18 ) and Firebird-1.5.0.3815_RC6_win32

This exception gives on FbConnection.Begintransaction methods when 
actual transaction is not Committed or Rollbacked.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Exception: A transaction is currently active....

[Thomas <ja...@ma...>]

I sometimes get this exception:

"A transaction is currently active. Parallel transactions are not =
supported."

I am pretty sure that I only have one transactions i use.

Any idea why I get this exception?

I am using version 1.5 Beta 1 ( 2003-09-18 ) and =
Firebird-1.5.0.3815_RC6_win32

Re: [Firebird-net-provider] [Firebid-net-provider] TableMappings

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

Hi,
I found some info in help in Visual studio 2003
use this topic:

"Setting Up DataTable and DataColumn Mappings  [C#]"

If you do not specify a TableName or a DataTableMapping name when calling
the Fill or Update method of the DataAdapter, the DataAdapter will look for
a DataTableMapping named "Table". If that DataTableMapping does not exist,
the TableName of the DataTable will be "Table". You can specify a default
DataTableMapping by creating a DataTableMapping with the name of "Table".
The following code example creates a DataTableMapping (from the
System.Data.Common namespace) and makes it the default mapping for the
specified DataAdapter by naming it "Table". The example then maps the
columns from the first table in the query result (the Customers table of the
Northwind database) to a set of more user-friendly names in the Northwind
Customers table in the DataSet. For columns that are not mapped, the name of
the column from the data source is used.
[C#]
DataTableMapping custMap = custDA.TableMappings.Add("Table",
"NorthwindCustomers");
custMap.ColumnMappings.Add( "CompanyName", "Company");
custMap.ColumnMappings.Add( "ContactName", "Contact");
custMap.ColumnMappings.Add( "PostalCode", "ZIPCode");

custDA.Fill(custDS);