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

Re: [Firebird-net-provider] Bug in Provider 1.5 Beta 4 (.NET 1.1)

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

HEllo:

> What happens, is that in FbCommand.cs:
>
> namedParameters = search.Matches(this.commands[actualCommand]);
>
> I have actualCommand == 2, this.commands[2] == null, and the
> regex 'search.Matches(null)' cannot be used ! This throws an
> exception (Value cannot be null).

With the same CommandText i got only 2 elements ( this can be the reason
why i don't get an exception ):

    [0]    "CREATE TABLE A(F1 INTEGER NOT NULL, F2 INTEGER NOT NULL)"
    [1]    "ALTER TABLE A ADD CONSTRAINT PK_A PRIMARY KEY (F1, F2)"




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Some comments about future developement

[Miha M. <mi...@NO...>]

Point 2 is very welcome :)

Miha

"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:3FB...@te......
> Hello:
>
> The beta 4 is the last beta release before start the RC stage, i'm
> starting to think in the needs we are going to have after 1.5 release, i
> think we have two mayor needs for the future:

Re: [Firebird-net-provider] More on bug in Provider 1.5 Beta 4 (.NET 1.1)

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

Hello:

> string commandText = this.commands[actualCommand];
> if (this.commandText != null && this.commandText.Trim().Length > 0)
>
> The test is done with respect to this.commandText, however it is a
> local variable (commandText) that should be tested here, or am I
> wrong ?
>
> This might be the real cause of my troubles...

You are more than right :) thanks very much.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Some comments about future developement

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

Hello:

The beta 4 is the last beta release before start the RC stage, i'm 
starting to think in the needs we are going to have after 1.5 release, i 
think we have two mayor needs for the future:


1. ADO.NET 2.0 compatibility. I'm thinking on this for version 2.0 of 
the Firbeird .NET Data Provider.

I'm reviwing the alpha docs of ADO.NET 2.0 and there are a lot of 
internal changes that are going to be needed for match with the new 
architecture of ADO.NET (Documentation of ADO.NET is fairly incomplete 
but it's not bad to be reviewing it yet ;)).

All the actual ADO.NET classes needs changes for match new class 
hierarchy, for example in ADO.NET 2.0:

- SqlConnection inherits from:

    DbConnectionBase, ICloneable, ISqlConnection, IDbConnection, IDisposable

- SqlCommand inherits from:

    DbCommandBase, ICloneable, IDbAsyncCommand, ISqlCommand, IDbCommand, 
IDisposable

- SqlCommandBuilder inherits from:

    DbCommandBuilder

- SqlDataReader inhertits from:

    DbDataReaderBase, IDataReader, IDataRecord, ISqlReader, IDisposable, 
ISqlRecord, ISqlGetTypedData, IGetTypedData

- SqlTransaction inherits from:

    DbTransaction, ISqlTransaction, IDbTransaction, IDisposable

- SqlParameter inherits from:

    DbParameterBase, ICloneable, ISqlParameter, IDbDataParameter, 
IDataParameter

- SqlParameterCollection inherits from:

    DbParameterCollectionBase, ISqlParameterCollection, 
IDataParameterCollection, IList, ICollection, IEnumerable

There are some new classes in the SqlClient of ADO.NET 2.0, some of them 
will be needed of implement in the Firebird .NET Data Provider, until 
now i have found this:

    - ResultSetEnumerator

    - SqlBulkCopyColumnAssociator

    - SqlBulkCopyColumnAssociatorCollection

    - SqlClientFactory (*)

    - SqlDataTable (*)

    - SqlDependency (*)

    - SqlResultSet (*)

    - SqlRecord (**)

    - SqlUpdatableRecord (***)


(*) I think they are needed for implement in the Firebird .NET Data 
Provider as public classes.
(**) I think they are needed for implement in the Firebird .NET Data 
Provider as internal classes.
(***) Has no documentation yet, nut probably will be needed to implement.

There are too some new features, for example SqlConnection has a 
GetSchema ( we have it yet in 1.5 as GetDbSchema but it's a little 
different and it's going to need changes ), SqlCommand has async methods 
for execution.

I will try to continue to review the ADO.NET 2.0 docs.



2. Embbeded server support. For this we have to write a Firebird Client 
Wrapper, if i'm not wrong there two ways for do this:

    1. Using PInvoke.

    2. Using a C++ managed dll.

I see both ways are no easy ;).

I'm thinking on implement this for version 2.0 of the Firebird Provider 
( if i can .. hehe ... i have basic knowledge of C++ and i'm not sure is 
PInvoke is a real option for this ;) ), i want to see a way for abstract 
GDS implementation and Firebird client wrapper for allow to use only one 
set of ADO.NET classes, now the .net provider ships with a single 
assembly and for make this the best way, in first place, will be to use 
custom assemblys for GDS implementations.

Another question i'm thinking on is that more than probably version 2.0 
of the Firebird provider will ship with documentation only for non 
standard ADO.NET classes ( for these classes the documentation of 
SqlClient or other Microsoft provider will be more than good :) ).

Before the 2.0 release there will one or more releases with little 
enhacements and bug fixes if needed.



--
Best regards

Carlso Guzmán Álvarez
Vigo-Spain

P.S: Sorry for the poor english, this is the nig email i have written 
ever in English :)

[Firebird-net-provider] apostrophe

[luisa\.123\@libero\.it <lui...@li...>]

Hello!
Sorry for my English, I=92m Italian.
I would want to know, how t=
o insert apostrophe.  
Sample: insert =93Jon=92s=94

I do:
Com.Comman=
dText =3D "INSERT INTO Client (Name) Values (=91Jon=92=92s=92)"
 r =3D c=
om.ExecuteNonQuery

but I have error.
How I can do it?
I use net and =
firebird net provider 1.5
  Thanks.

[Firebird-net-provider] More on bug in Provider 1.5 Beta 4 (.NET 1.1)

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

...researching a bit more I found something strange in FbCommand.cs,
at line 602:

string commandText = this.commands[actualCommand];
if (this.commandText != null && this.commandText.Trim().Length > 0)

The test is done with respect to this.commandText, however it is a
local variable (commandText) that should be tested here, or am I
wrong ?

This might be the real cause of my troubles...

    Pierre

[Firebird-net-provider] Bug in Provider 1.5 Beta 4 (.NET 1.1)

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

Hello Carlos,

I am still using the same code as I was on October 6th as I reported
and proposed a fix, since following code crashed:

   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 ();

This does no longer work. I have a crash in FbCommand.cs,
at line 537, while executing the second loop in my for(;;)
block, on reader.NextResult.

The call trace is:

FbCommand.InternalPrepare
FbCommand.NextResult
FbDataReader.NextResult

What happens, is that in FbCommand.cs:

  namedParameters = search.Matches(this.commands[actualCommand]);

I have actualCommand == 2, this.commands[2] == null, and the
regex 'search.Matches(null)' cannot be used ! This throws an
exception (Value cannot be null).

What is the best way to fix this ? Add a test to whether the
argument is null, or shouldn't this code get executed ?

Kind regards.

    Pierre

[Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.5 Beta 4 available for download.

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

Hello:

Firebird .NET Data Provider 1.5 Beta 4 available for download.


Release Changes:


Beta 4 ( 2003-11-11 )
---- - --------------

- Bug fixes.

- Improved prepared statement handling ( Thanks to Jesus for his feedback )

- Improved array datatype support ( Thanks to Jesus for his feedback )

- Now it's possible to use FbConnection, FbCommand and FbDataAdapter as 
components inside #Develop.

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


You can download binarys for .NET 1.0 at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta4-Net1.0.exe?download


You can download binarys for .NET 1.1 at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta4-Net1.1.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta4-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta4-Doc.zip?download




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Logging - sql statements

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

Hello:

> Yes, I'm using FbCommandBuilder, and can call:
> textBox1.Text = fbcb1.GetInsertCommand().CommandText;
> and I've got:
> INSERT INTO "TB1" ("IDTB1", "IDTB2", "ILO", "CENA") VALUES (?, ?, ?, ?)
> but I want to see this statement filled with data. 

It's not filled with data, you need to check parameters values in 
Parameters collection.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Logging - sql statements

[Mirek S. <m.s...@tr...>]

Dnia 2003-11-10 14:15, U=BFytkownik Carlos Guzm=E1n =C1lvarez napisa=B3:

>
> If you are using a FbCommandBuilder yes, if i understand well you want=20
> to check the SQL statement before made the Update, i'm right ??.
>
>
Yes, I'm using FbCommandBuilder, and can call:
textBox1.Text =3D fbcb1.GetInsertCommand().CommandText;
and I've got:
INSERT INTO "TB1" ("IDTB1", "IDTB2", "ILO", "CENA") VALUES (?, ?, ?, ?)
but I want to see this statement filled with data.

Mirek Sobczak

Re: [Firebird-net-provider] Logging - sql statements

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

Hello:

> It is possible to see SQL statement generated and send by provider 
> during update to firebird.
> In following sequence:
>    fbtb1.Fill(dataSet1, "tb1");
>    ... I insert new row in dbgrid
>
>    fbtb1.Update(dataSet1,"tb1");
>    and  exception is catched.
> Can I see this statemant before send to firebird

If you are using a FbCommandBuilder yes, if i understand well you want 
to check the SQL statement before made the Update, i'm right ??.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Logging - sql statements

[Mirek S. <m.s...@tr...>]

Hi,
It is possible to see SQL statement generated and send by provider 
during update to firebird.
In following sequence:
    fbtb1.Fill(dataSet1, "tb1");
    ... I insert new row in dbgrid

    fbtb1.Update(dataSet1,"tb1");
    and  exception is catched.
Can I see this statemant before send to firebird

Mirek Sobczak

Re: [Firebird-net-provider] FW: #Develop

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

Hello:

> When I put a connection string into the fbConnection component, both the
> datasource and database property gets set to the database path...
>
> I get an error on fbconnection.open(); (just attached to a button 
> click) is
> the connection error because the connection string does not get parsed
> correctly?


More than probably the connection string is not being parsed when 
setting it in the  properties panel, for this there are a connection 
string editor but sharpdevelop doesn't show the button for access it ;)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FW: #Develop

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

Hello:

> I've also noticed that if the CHARSET is actually NONE, then I need to 
> omit
> this in the connection string because CHARSET=NONE throws an exception...

I have tested this in my local tree and it's working fine:

string connectionString =
    @"Database=test.fdb;" +
    "User=SYSDBA;" +
    "Password=masterkey;" +
    "Server=localhost;" +
    "Port=3050;" +
    "Dialect=3;" +
    "Charset=NONE;" +
    "pooling=false;" +
    "Role=;";

FbConnection connection = new FbConnection(connectionString);
connection.Open();

connection.Close();


> I can now see that setting the port number to something other than 
> 3050 also
> thtorws an exception, I can connection with
> User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;DataSource=s
> hortblack;Port=3050;Dialect=1;Role=;Connection
> lifetime=30;Pooling=true;Packet Size=8192;
>
> but not with
> User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;DataSource=s
> hortblack;Port=3051;Dialect=1;Role=;Connection
> lifetime=30;Pooling=true;Packet Size=8192;


And you have the server listening on port 3051 ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] FW: #Develop

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

> Hi
> I've the same problem with VS .NET.
> I can't connect adapter to dataset in graphical environment.
> I found out that I can do it programaticaly:
> fbDataAdapter1.Fill(dataSet1, "tb1");  //where tb1 is table name
>
> Dnia 2003-11-10 03:39, Użytkownik Alan McDonald napisał:

Bingo - thanks that's nice

Alan

RE: [Firebird-net-provider] FW: #Develop

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

> I've also noticed that if the CHARSET is actually NONE, then I 
> need to omit
> this in the connection string because CHARSET=NONE throws an exception...
> 
> I can now see that setting the port number to something other 
> than 3050 also
> thtorws an exception, I can connection with
> User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;Da
> taSource=s
> hortblack;Port=3050;Dialect=1;Role=;Connection
> lifetime=30;Pooling=true;Packet Size=8192;
> 
> but not with
> User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;Da
> taSource=s
> hortblack;Port=3051;Dialect=1;Role=;Connection
> lifetime=30;Pooling=true;Packet Size=8192;
> 
> Alan
> 

Sorry - my mistake - I was making two connections..
Alan

RE: [Firebird-net-provider] FW: #Develop

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

I've also noticed that if the CHARSET is actually NONE, then I need to omit
this in the connection string because CHARSET=NONE throws an exception...

I can now see that setting the port number to something other than 3050 also
thtorws an exception, I can connection with
User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;DataSource=s
hortblack;Port=3050;Dialect=1;Role=;Connection
lifetime=30;Pooling=true;Packet Size=8192;

but not with
User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;DataSource=s
hortblack;Port=3051;Dialect=1;Role=;Connection
lifetime=30;Pooling=true;Packet Size=8192;

Alan

RE: [Firebird-net-provider] FW: #Develop

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

When I put a connection string into the fbConnection component, both the
datasource and database property gets set to the database path...

I get an error on fbconnection.open(); (just attached to a button click) is
the connection error because the connection string does not get parsed
correctly?

Alan

RE: [Firebird-net-provider] FW: #Develop

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

> Hello:
>
> > I've the same problem with VS .NET.
> > I can't connect adapter to dataset in graphical environment.
>
> Because there are no design time support for the FbDataAdapter class ;)
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez

pity...

Re: [Firebird-net-provider] FW: #Develop

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

Hello:

> I've the same problem with VS .NET.
> I can't connect adapter to dataset in graphical environment.

Because there are no design time support for the FbDataAdapter class ;)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FW: #Develop

[Mirek S. <m.s...@tr...>]

Hi
I've the same problem with VS .NET.
I can't connect adapter to dataset in graphical environment.
I found out that I can do it programaticaly:
fbDataAdapter1.Fill(dataSet1, "tb1");  //where tb1 is table name

Dnia 2003-11-10 03:39, U=BFytkownik Alan McDonald napisa=B3:

>Just trying to setup #Develop with the appropriate components...
>I have installed the firebird components into the toolbox - no problem.
>I can drop the connection, command and adapter onto the form and set the
>properties ok.
>But I can't figure out how to connect the adapter into a dataset so I ca=
n
>populate a datagrid. I suppose there must be some raw code to do here - =
but
>I'm sort of hoping I can get a simple app running with properties set in
>components a la what I could do in Delphi.
>
> =20
>
In VS.NET I can work with MS database components so easy like in Delphi,=20
connection DataAdapter to DataSet is easier with MS components, becouse=20
there is a wizzard, but Fill methode must be called any way.

>Anyone know how this might be done?
>
>thanks
>Alan
>
> =20
>

RE: [Firebird-net-provider] FW: #Develop

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

I'd love to make a sample app using #Develop with simple firebird
components, standard datagrid etc maybe using the employee database
Has anyone got anything along these lines which they'd like to share?
Alan

RE: [Firebird-net-provider] FW: #Develop

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

Just trying to setup #Develop with the appropriate components...
I have installed the firebird components into the toolbox - no problem.
I can drop the connection, command and adapter onto the form and set the
properties ok.
But I can't figure out how to connect the adapter into a dataset so I can
populate a datagrid. I suppose there must be some raw code to do here - but
I'm sort of hoping I can get a simple app running with properties set in
components a la what I could do in Delphi.

Anyone know how this might be done?

thanks
Alan

Re: [Firebird-net-provider] FW: #Develop

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

Hello:

> Do you have SharpDevelop?


Yes last version ( 0.98 ) seems to be much more usable than previous 
versions.

> It's a really nice open source edition of a C# IDE. It runs against 
> mono as
> well as against the win framework.
> Any chance of making the .NET driver have installable components for this
> IDE? that would be really cool.


I have added a change to CVS sources for allow this, i have added the 
TooboxItem
attribute to the firebird .net provider components ( i have try to 
attach an image
on how it looks when adding the components but the email is being 
rejected due to
the size ;) test it when you can and comment the results )




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FW: #Develop

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

Carlos,
Do you have SharpDevelop?
http://www.icsharpcode.net/OpenSource/SD/
It's a really nice open source edition of a C# IDE. It runs against mono as
well as against the win framework.
Any chance of making the .NET driver have installable components for this
IDE? that would be really cool.
Alan