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

[Firebird-net-provider] FBCommandBuilder - which fields?

[JS.staff <jsp...@ec...>]

Does the FbCommandBuilder compare all fields when doing update &
deletes, or just the primary key?
=20
I've just thinking about my timestamp problem - I've removed the
timestamp from the PK, but obviously if the commandbuilder is comparing
every row for updates, I need to change this behaviour!
=20
Thanks,
=20
John

[Firebird-net-provider] Using FBCommand and stored procedures

[Tony R. <Ton...@jf...>]

Using FB.NET provider 1.5.1517.216

=20

I have the following SP, what is the best way of calling it (Note code
is in Delphi, but any language will do)

=20

CREATE PROCEDURE TEST (

    ID_IN INTEGER)

RETURNS (

    ID_OUT INTEGER)

AS

BEGIN

  ID_OUT =3D  ID_IN + 1;

  SUSPEND;

END

=20

I have got..

  ac :=3D FbCommand.Create('EXECUTE PROCEDURE
TEST(@ID_IN,@ID_OUT)',adm.Connection);

  ac.Parameters.Add('@ID_IN',FbDBType.Integer,).Direction :=3D
ParameterDirection.Input;

  ac.Parameters.Add('@ID_OUT',FbDBType.Integer).Direction :=3D
ParameterDirection.Output;

  ac.Parameters[0].Value :=3D TObject(Int32(10));

  ac.ExecuteNonQuery;

=20

But I get the following at the executeNonQuery line...

=20

#####

=20

FirebirdSql.Data.Firebird.FbException :

Dynamic SQL Error

parameter mismatch for procedure TEST

=20

  ----> FirebirdSql.Data.Firebird.Gds.GdsException : Exception of type
FirebirdSql.Data.Firebird.Gds.GdsException was thrown.

######

Tony Rivron

=20



This message has been scanned for viruses by MailControl - www.mailcontrol.=
com

[Firebird-net-provider] FbDataAdapter.FillSchema

[Oleg U. <ol...@ya...>]

Can i use this method for recieve table schema of select stored procedure?
I try do this thing, but i catch exception:
----------------
An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException'
occurred in system.data.dll

Additional information: Dynamic SQL Error
SQL error code = -204
Table unknown
TEST_SELECT
At line 1, column 15
-----------------

My code sample:
using (FbConnection connection = new FbConnection(ConnectionString))

{

connection.Open();

FbTransaction transaction = connection.BeginTransaction();

FbCommand selectCommand = new FbCommand("TEST_SELECT", connection,
transaction);

selectCommand.CommandType = CommandType.StoredProcedure;

FbDataAdapter adapter = new FbDataAdapter(selectCommand);

DataTable table = new DataTable();

adapter.FillSchema(table, SchemaType.Source);

transaction.Commit();

}

[Firebird-net-provider] 'FbDbType' is not declared while running the Firebird.net data provider 1.5 sample??

[benny <be...@ch...>]

Hi,=20

   I tried installing the FirebirdNETProvider1.5-NET1.1, there are =
sample for me to tried - CSharpExample.aspx, and VBNETExample.aspx ...
I could run the  CSharpExample.aspx successfully that prove I could =
connect to Firebird1.5RC7 that I am using ... But I failed to run the =
sample VBNETExample.aspx.
I have the following error while running on Web Matrix0.5:-

BC30451: Name 'FbDbType' is not declared.

Source Error:

Line 69:         myCommand =3D new FbCommand(selectCmd, myConnection, =
MyTxn)
Line 70:    =20
Line 71:         myCommand.parameters.add("@EMP_NO", FbDbType.SmallInt)

Why? Anyone there know any configuration I missed out during =
installation of FirebirdNETProvider1.5-NET1.1 or any mistake I might =
made?=20

TIA=20

regards,

benny ;)=20

Re: [Firebird-net-provider] Issue with timestamp comparison?[Scanned]

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

Hello:

> Still, I guess timestamp behaviour should be deterministic! ;)

After review how Jaybird people is handling the millisconds i have made 
some changes in the 1.6 sources for try to handle it, if the changes 
works well i will do the backport of these changes to the 1.5 if possible.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Use GetBytes() to get BLOB data

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

Hello:

> Yes, in two weeks.

I have committed new nunit test case for this error into the CVS, in 
both 1.5 and 1.6 sources.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Basic Question

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

Hello:

> I hope that you understand what I am asking.

I'm not sure if i understand well, sorry.

If what you need is tat the values of an "auntoinc" field to be 
generated in the server, i think you will need to use generators and 
triggers ( Before insert ).






--
Best regards

Carlos Guzmán Álvarez
vigo-Spain

Re: [Firebird-net-provider] Issue with timestamp comparison?

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

Hello:

> Although the first query returns a value, the second sometimes fails to 
> return a row! Possibly some precision failure in the conversion between 
> FB timestamps and .NET datetimes????


Huummmm ... maybe the problem is with the milliseconds ...



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Basic Question

[Inter-Biz, U. u i. <ne...@in...>]

Does Firebird.NET provide disconnected mode or it is using Transactions to
work with multi-user access?
For example if I us DataAdapter to get local copy of data from certain
table, and then I change and insert new records in this table. One of fields
is autoinc field. There can be many users making new inserts on their client
PCs (to same table). Does Firebird.NET emulate MS disconnected mode
presented for e.g. SQLServer (meaning, when calling Update data are
transfered to DataSource, and autoinc fields are recreated on server -
values can differ from those defined in local table)?

I hope that you understand what I am asking.
I worked with FB using Delphi 7, but now I started using VC#.NET and I have
some little experience when using SQL Server with it.

[Firebird-net-provider] Issue with timestamp comparison?

[JS.staff <jsp...@ec...>]

Are there any known issues with comparing equality of timestamps?? with
.NET datetime values.
=20
I've got a table with a PK made up of int 'numberpk', varchar(20)
'textpk' and a timestamp 'whenstarted'.
=20
I do something like : select max(whenstarted) from mytable where
numberpk =3D @num and textpk =3D @text
=20
This correctly returns a datetime into .net.
=20
Then I do: select * from mytable where numberpk =3D @num and textpk =3D
@text and whenstarted =3D @valuefromlastquery
=20
Although the first query returns a value, the second sometimes fails to
return a row! Possibly some precision failure in the conversion between
FB timestamps and .NET datetimes????
=20
A test case is difficult to provide, because if I type the date into the
record again, the problem goes away!
=20
Thanks,
=20
John

Re: [Firebird-net-provider] Latest cvs changes for 1.5

[Alessandro P. <pet...@in...>]

"Carlos Guzmán Álvarez" <car...@te...> ha scritto nel messaggio
news:404...@te......
> Hello:
>
> > latest changes breaks 1.5 stability.
> > If I try to fill a dataset with an empty result set (using a stored
> > procedure), the following exception occurs:
>
> Thanks, i think it will be fixed in the CVS now, sorry for the
> inconvenience.

Confirmed working.

Thank you very much.

--
Alessandro Petrelli.

Re: [Firebird-net-provider] Latest cvs changes for 1.5

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

Hello:

> latest changes breaks 1.5 stability.
> If I try to fill a dataset with an empty result set (using a stored
> procedure), the following exception occurs:

Thanks, i think it will be fixed in the CVS now, sorry for the 
inconvenience.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Latest cvs changes for 1.5

[Alessandro P. <pet...@in...>]

Hello Carlos,

latest changes breaks 1.5 stability.
If I try to fill a dataset with an empty result set (using a stored
procedure), the following exception occurs:

[NullReferenceException: Riferimento a un oggetto non impostato su
un'istanza di oggetto.]
   FirebirdSql.Data.Firebird.FbDataReader.Read() +67
   FirebirdSql.Data.Firebird.FbDataReader.Close() +44
   FirebirdSql.Data.Firebird.FbDataReader.Dispose(Boolean disposing) +23
   FirebirdSql.Data.Firebird.FbDataReader.System.IDisposable.Dispose() +17
   System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38

My code:

  FbCommand cmd = new FbCommand("SP_COUNTRY_LIST", conn);
   cmd.CommandType = CommandType.StoredProcedure;

   FbDataAdapter adapter = new FbDataAdapter();
   DataSet ds = new DataSet();

   adapter.SelectCommand = cmd;
   adapter.Fill(ds);

   adapter.Dispose();
   cmd.Dispose();
   conn.Close();
   conn.Dispose();



--
Alessandro Petrelli.

Re: [Firebird-net-provider] Firebird BDP driver for C#Builder and Delphi

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

Hello:

> I wonder if there exists an Borland BDP driver for Firebird? 

No yet.

> If it doesn't exist then are there any plans for creating one?

Yes, there are plans for it.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Firebird BDP driver for C#Builder and Delphi

[Johannes <n@n.com>]

Hi,

I wonder if there exists an Borland BDP driver for Firebird? If it 
doesn't exist then are there any plans for creating one?

Thanks

Johannes

Re: [Firebird-net-provider] Re: [Firebird-odbc-devel] Always return DBCS Length for string field ?

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

Hello:

> Carlos has fought against the very same problem (but surfacing for UTF-8, 
> where all strings get triple length) for the .NET-provider.
> 
> Perhaps his solution (if any) can be ported to ODBC.

Finally i have implemented your solution in the 1.6 sources, i need to 
do more tests, but for now seems to be working.

It looks like this when reading char values:

string s = this.ReadString(
	field.Charset.Encoding,
	field.Length);

if ((field.Length % field.Charset.BytesPerCharacter) == 0 &&
	s.Length > field.CharCount)
{
	fieldValue = s.Substring(0, field.CharCount);
}
else
{
	fieldValue = s;
}


I have applied a similar one for the char parameter values (committed 
today):

string svalue = sqldata.ToString();

if ((param.Length % param.Charset.BytesPerCharacter) == 0 &&
	svalue.Length > param.CharCount)
{ 	
	throw new IscException(335544321); 	
}

						this.WriteOpaque(
	param.Charset.Encoding.GetBytes(svalue),
	param.Length);




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: [Firebird-odbc-devel] Always return DBCS Length for string field ?

[Peter J. <pj...@wa...>]

Hi Shum, All, 

"Shum W.C." <sh...@mi...> wrote:
> I use BIG-5 Character set (Traditional Chinese Character)
> 
> I have the following problem after fetched fireBird through IBPhoenix ODBC
> 
> the result data (string type) always double the length:
> 
> for examples:
> 1.)  I get "Y " instead of "Y"  even the field is defined as CHR(1)
> 2.) "ABC   " instead of "ABC even the field is definec as CHR(3)

Carlos has fought against the very same problem (but surfacing for UTF-8, 
where all strings get triple length) for the .NET-provider.

Perhaps his solution (if any) can be ported to ODBC.

Regards,
Peter Jacobi

Re: [Firebird-net-provider] .Net Provider Compatibility

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

Hello:

> Is the .NET 1.1 Data Provider compatible with the Firebird 1.0 engine, or
> does it require a later version?

It needs to work with Firebird 1.0 ( but there will things, like 
savepoints, that will work only with Firebird 1.5 )



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] .Net Provider Compatibility

[dwds <dw...@tr...>]

Is the .NET 1.1 Data Provider compatible with the Firebird 1.0 engine, or
does it require a later version?

Thanks

Dave White

Re: [Firebird-net-provider] CREATE TABLE with Embedded server

[Tobias G. <tob...@ca...>]

Tobias Grimm wrote:

> When I then try to create a table using the Embedded server, I get an 
> FBException "unsuccessful metadata updateTABLEA".

Thanks to Carlos, I finally figured out what the problem was. The
fbintl.dll needs to be copied to the "intl" subdirectory under the 
applications directory, not the application directory itself.

bye,

Tobias

[Firebird-net-provider] Tutorial

[Claudinei R. <ne...@ac...>]

Hi,

=20

My name is Nei and I'd like to know if anybody have any tutorial about
the Firebird .NET. I'm using Delphi 8 and I don't know to use this
driver.

=20

Thanks.

=20

=20

Re: [Firebird-net-provider] Use GetBytes() to get BLOB data

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

Hello:

> Would a new version be released, e.g, 1.5.2

Yes, in two weeks.

> or would I have to grab the code from CVS and
> build it myself?  I've never had to do that with any open-source project,
> but if that's what's necessary, then I'll figure it out.

I can send to you the new dll built from CVS if you want it.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbDataAdater.Update()

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

Hello:

> I think it's right!
> When you commit this changes? I'd like to test it. :)

It's on CVS yet, in both 1.5 and 1.6 sources thanks very much




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Use GetBytes() to get BLOB data

[Derek M. A. Lee-W. <de...@fa...>]

> > Is this a defect in the .NET provider
> 
> Yes, i will fix it tomorrow, thanks very much.

Great.  Thanks.

Once it is fixed, how would I get the updated code?  Would a new version
be released, e.g, 1.5.2, or would I have to grab the code from CVS and
build it myself?  I've never had to do that with any open-source project,
but if that's what's necessary, then I'll figure it out.

Derek

-- 
Derek M. A. Lee-Wo
Email: (Home) de...@le...  (Work) dl...@vo...
Fax:     (US) 413-826-0641      (UK) 08701 338414

    "Those who will not risk cannot win" - John Paul Jones

Re: [Firebird-net-provider] FbDataAdater.Update()

[Oleg U. <ol...@ya...>]

> Opinions ??

I think it's right!
When you commit this changes? I'd like to test it. :)