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

Re: [Firebird-net-provider] Start and stop firebird

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

Hello:

> and killing the process to stop the server. Do you know any better way
> to do it?

Huummm for me the best way is to install Firebird as a service with 
manual startup and
start/stop it using ServiceController class ( i have not tested it but 
probably will work ).

But if as you said you don't want to install it as a service, for me the 
best will be using the
firebird guard, but i don't know what is the option to stop it :) or for 
hide the icon in the taskbar,
try to ask it in the firebird support or firebird devel lists.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.5 Beta 2 released.

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

Hello:

Firebird .NET Data Provider Beta 2 available for download.


Beta 2 ( 2003-10-14 )
---- - --------------

- Bug fixes.

- Better fit to ADO.NET.

- Improved Command Builder implementation.

- Improved Design time support for FbParameterCollection class.

- Removed FbCommand.Cursor property.

- Added handling of character sets by field for char and varchar datatypes.


You can view the complete changelog at:

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


Downloads
---------


You can download binarys for .NET Framework 1.0 at:

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


You can download binarys for .NET Framework 1.1 at:

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


You can download sources at:

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


You can download documentation at:

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


CVS Tag:

NP_1_5_Beta_2


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Start and stop firebird

[<ja...@er...>]

Hi all,

I have a question that it's more for the general list but maybe you 
know the answer.
We need to distribute the firebird database with our application, but 
because our code
is in C# we are not using the embedded database (.Net data provider 
doesn't support
the embedded database).

Then we need to distribute firebird and we do in a silent way unzipping 
the engine in 
a specific folder (we don't want to distribute the actual firebird 
setup or we don't 
want to install it as a service). What we do is start a process to 
start the engine:

fbserver.exe -a

and killing the process to stop the server. Do you know any better way 
to do it? 
Which is the commad to stop the server? There is a way to start the 
server without the
icon in the system tray?

Thank you.

Regards,
Jesus

Re: [Firebird-net-provider] MONO - CultureInfo

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

Hello:

> i want to notice you, that mono now contains CultureInfo class...

Thanks :) Bugzilla error about CompareInfo has not been updated yet, i 
will try this after release
of Beta 2 ( today or tomorrow ).

> What next is missing in mono to fully support net-provider?

Known by me, at this moment, nothing, but after beta 2 release i'm going 
to run the Nunit test suite using mono 
in Linux Red Hat 8

> And finally, i sue mono and net provider in production without 
> problems for one month... Carlos great work, thanx...

Great!!, Thanks very much for the tip :)



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] MONO - CultureInfo

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

Hallo,

i want to notice you, that mono now contains CultureInfo class...
What next is missing in mono to fully support net-provider?

And finally, i sue mono and net provider in production without problems 
for one month... Carlos great work, thanx...

p.

Re: [Firebird-net-provider] Dataset back using VB.net

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

Hello:

 > Has anyone got an exampel of the rest och the code I can use?

Here is the rest of the code to fill a dataset .... in C# ;):

    FbDataAdapter FbAdapter = new FbDataAdapter(FbComm);
    DataSet dsCustomers = new DataSet("CUSTOMER");

    // Fill dataset                              
    FbAdapter.Fill(ds, "CUSTOMER");

    // Commit transaction
    ...

    // Close connection
    ....


You can see the NUnit test suite for see some simple examples.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain                              

[Firebird-net-provider] Dataset back using VB.net

[<mic...@fr...>]

Im trying to connect to a databse and get a Dataset back using VB.net =
and FirebirdSql.Data.Firebird


            Dim connectionString As String
            connectionString =3D =
"Database=3DE:\\Projects\\bilpool\\bilpool.gdb;User=3DSYSDBA;Password=3Dm=
asterkey;Dialect=3D3;Server=3Dlocalhost"
            Dim sSQL As String =3D "SELECT * FROM CUSTOMER"
            Dim FbC As New FbConnection(connectionString)
            FbC.Open()
            Dim FbT As FbTransaction
            FbT =3D FbC.BeginTransaction()
            Dim FbComm As New FbCommand
            FbComm.CommandType =3D CommandType.Text
            FbComm.Connection =3D FbC
            FbComm.Transaction =3D FbT
            FbComm.CommandText =3D sSQL


Has anyone got an exampel of the rest och the code I can use?

Regards

Michael H=E5kansson
------------------------------------
mic...@fr...

Re: [Firebird-net-provider] How do i Build with Mono:: platform:?

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

Hello:

If you are in linux you have a makefile, if you are in windows there are 
nant build scripts ( you need to download
nant at nant.sourceforge.net ).

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 do i Build with Mono:: platform:?

[<mic...@fr...>]

How do i Build with Mono:: platform:?

 - You nedd Mono:: ( www.go-mono.com ), version > 0.16 ( at this moment =
CVS Sources ).

 - The provider sources have a build file, makefile, for build the =
sources ( this script file needs Cygwin ).

 - The makefile build file generates:

  1.- FirebirdSql.Data.Firebird.dll ( binary of the ado .net provider )

 Note : You can build it using NANt too, for this you need to modify the =
NAnt script changing the build=20
 file for allow it.


Regards

Michael H=E5kansson
System Design Engineer
------------------------------------
mic...@fr...

RE: [Firebird-net-provider] RE: Firebird .NET Data Provider setup problems

[Thomas A. <tho...@st...>]

> > We don't seem to find any directory mono/lib. Is this 
> > something that we should be creating ?
> 
> How you have installed mono ??
> 
> I usually install it building CVS sources, after build and install it,
> in the mono installation directory there are a lib directory with the
> dll of the class libraries, try to copy the provider dll to 
> this directory.

Thanks Carlos. I installed mono using rpms. In the end we got it to work
with the dll in /usr/lib. (This was after trying it in several places).
I don't understand why it didn't work there in the beginning, but we may
have changed something along the way. Probably not paying enough attention
to detail. Anyway, thanks for your help!

-Thomas

Re: [Firebird-net-provider] DBNull.Value

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

Hello:

> When i execute this code (.NET provider 1.0 or 1.5b1, Firebird 1.0.3 or
> 1.5R6, WinXP), all values >=1 is NULL...


Fixed on CVS for 1.5 version :) , thanks very much.




-- 
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] DBNull.Value

[Jan J. <fb...@ja...>]

Hi,
When i execute this code (.NET provider 1.0 or 1.5b1, Firebird 1.0.3 or
1.5R6, WinXP), all values >=1 is NULL...

===================================================
// create table tbTest(
//    p1 char(10)
// );
FbCommand comm = new FbCommand(
       "insert into tbTest(p1) values(@p1);",
       conn,
       tran
       );
FbParameter p1 = new FbParameter("@p1", FbType.Char);
comm.Parameters.Add(p1);
comm.Prepare();

for(int i = 0; i < 5; i++) {
   if(i = 1)
      p1.Value = DBNull.Value;
   else
      p1.Value = i.ToString();
   comm.ExecuteNonQuery();
}
tran.Commit();
===================================================

Regards,

Jerry

Re: [Firebird-net-provider] Select stored procedures 2

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

Hello:

> It is possible?

Yes with latests 1.5 releases.




-- 
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] Select stored procedures 2

[nicoya n. <nic...@ho...>]

Hi, I need to use dataapater to fill an dataset with a select stored 
procedures (retrieve rows). May I need to add the "Select * FROM " to my 
select stored procedures?
Look this:
---------------------------------------------------------------
CREATE PROCEDURE PA_PAIS_CONSULTAR
RETURNS (
    CODIGO INTEGER,
    NOMBRE VARCHAR (20))
AS
begin
   for select Id, Pais
   from Paises
   into :Codigo, :Nombre
   DO
   SUSPEND;
end


string Conexion = "Database=C:\\Bases\\PACHACAMAC.GDB;User=SYSDBA....";
string SQL = "SELECT * FROM PA_PAIS_CONSULTAR";  <<<-------

DataSet DS = new DataSet();
FbConnection FCon = new FbConnection(Conexion);
FbCommand FCD = new FbCommand(SQL,FCon);
FCD.CommandType = System.Data.CommandType.StoredProcedure;
FbDataAdapter FDA = new FbDataAdapter(FCD);
FDA.Fill(DS);

this.dataGrid1.DataSource = DS;
---------------------------------------------------------------

I want this:
---------------------------------------------------------------
string Conexion = "Database=C:\\Bases\\PACHACAMAC.GDB;User=SYSDBA....";
string SQL = "PA_PAIS_CONSULTAR";  <<<-------

DataSet DS = new DataSet();
FbConnection FCon = new FbConnection(Conexion);
FbCommand FCD = new FbCommand(SQL,FCon);
FCD.CommandType = System.Data.CommandType.StoredProcedure;
FbDataAdapter FDA = new FbDataAdapter(FCD);
FDA.Fill(DS);

this.dataGrid1.DataSource = DS;
---------------------------------------------------------------

It is possible?
It will be posible? :D  I think that make FB more easy to use a chanche to.
You may think this a less important topic, but i really want it wil be 
possible beacuese i use an business rules layer y my sqlserver projects that 
abstract all data access using stored procedures with datasets to provide 
diferent numbers of parameters and create its, And build the stored 
procedures names, etc. I really good thing :D

Thanks.

_________________________________________________________________
Consigue aquí las mejores y mas recientes ofertas de trabajo en América 
Latina y USA: www.yupimsn.com/empleos

Re: [Firebird-net-provider] .NET provider 1.5 for .NET 1.1 Framework

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

Hello:

> Is the DataBlock v2 sources in the tree working well with the 
> firebird.net provider?

In first place yes, but as you can think they need testing, cannot be 
called stable ;) (
i have changes uncommitted in my local tree)




-- 
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] .NET provider 1.5 for .NET 1.1 Framework

[Lee C. <lee...@ho...>]

Is the DataBlock v2 sources in the tree working well with the firebird.net 
provider?


>From: Carlos Guzmán Álvarez <car...@te...>
>To: Lee Connell <lee...@ho...>
>CC: fir...@li...
>Subject: Re: [Firebird-net-provider] .NET provider 1.5 for .NET 1.1 
>Framework
>Date: Thu, 09 Oct 2003 23:05:51 +0200
>
>Hello:
>
>>Will there be an availabe binary version of the .NET Provider 1.5 for the 
>>.NET 1.1 Framework soon?
>
>Yes beta 2 will have an installer for .NET 1.1
>
>>Will there be an available binary version of the .NET Application 
>>DataBlock v2 soon?
>
>
>No.
>
>
>
>
>
>
>--
>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.
>

_________________________________________________________________
Fast, faster, fastest: Upgrade to Cable or DSL today!   
https://broadband.msn.com

Re: [Firebird-net-provider] RE: Firebird .NET Data Provider setup problems

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

Hello:

> We don't seem to find any directory mono/lib. Is this something that 
> we should be creating ?


How you have installed mono ??

I usually install it building CVS sources, after build and install it,
in the mono installation directory there are a lib directory with the
dll of the class libraries, try to copy the provider dll to this directory.






-- 
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: Firebird .NET Data Provider setup problems

[Dave S. <ds...@ci...>]

<HTML><HEAD>
</HEAD>
<BODY bgcolor=3D"#FFFFFF">
<div><FONT FACE=3D"Arial" SIZE=3D3> &gt; Try to copy it into your=
 mono/lib directory</FONT></div>
<div>&nbsp;</div>
<FONT FACE=3D"Arial" SIZE=3D3> </FONT><div><FONT FACE=3D"Arial" SIZE=3D3>=
 We don't seem to find any directory mono/lib. Is this something=
 that we should be creating ?</FONT></div>
<div>&nbsp;</div>
<FONT FACE=3D"Arial" SIZE=3D3> </FONT><div><FONT FACE=3D"Arial" SIZE=3D3>=
 Many thanks,</FONT></div>
<div><FONT FACE=3D"Arial" SIZE=3D3> Thomas</FONT></div>
</body></html>

Re: [Firebird-net-provider] Firebird .NET Data Provider setup problems

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

Hello:

> Sorry if this is a dumb question, but I couldn't find any doc
> that covers our problem.
> 
> We want to set up Firebird .NET Data Provider for mono on
> Red Hat 9. We downloaded the source of .NET Provider, compiled
> it using the make file, and now have FirebirdSql.Data.Firebird.dll
> in ./build.
> 
> The problem is we don't know how to get mono to use the dll.
> We tried putting it with the other DLLs (I think it was /usr/lib)
> but it didn't work. Is there some command (like ldconfig) that
> we need to run for mono to be able to use it ?
> 
> (Mono seems to be working fine - we tested by compiling the sample
> stuff.)
> 
> Sorry the question's so vague, I'm not a c# programmer,
> and I'm nowhere near the pc now :(

Try to copy it into your mono/lib directory.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Plans for the FbHelper class

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

Hello:

> No problem i will try review one thing later today :)


I have removed yet the Parameter cache class, and added DeriveParameters 
methods
to FbHelper class,  it's not in CVS yet i will try to test it later today :)



-- 
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] Firebird .NET Data Provider setup problems

[Thomas A. <tho...@st...>]

Hi,

Sorry if this is a dumb question, but I couldn't find any doc
that covers our problem.

We want to set up Firebird .NET Data Provider for mono on
Red Hat 9. We downloaded the source of .NET Provider, compiled
it using the make file, and now have FirebirdSql.Data.Firebird.dll
in ./build.

The problem is we don't know how to get mono to use the dll.
We tried putting it with the other DLLs (I think it was /usr/lib)
but it didn't work. Is there some command (like ldconfig) that
we need to run for mono to be able to use it ?

(Mono seems to be working fine - we tested by compiling the sample
stuff.)

Sorry the question's so vague, I'm not a c# programmer,
and I'm nowhere near the pc now :(

Many thanks,
Thomas

Re: [Firebird-net-provider] .NET provider 1.5 for .NET 1.1 Framework

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

Hello:

> Will there be an availabe binary version of the .NET Provider 1.5 for 
> the .NET 1.1 Framework soon?

Yes beta 2 will have an installer for .NET 1.1

> Will there be an available binary version of the .NET Application 
> DataBlock v2 soon?


No.






-- 
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] .NET provider 1.5 for .NET 1.1 Framework

[Lee C. <lee...@ho...>]

Will there be an availabe binary version of the .NET Provider 1.5 for the 
.NET 1.1 Framework soon?

Will there be an available binary version of the .NET Application DataBlock 
v2 soon?

Thank you,

Lee

_________________________________________________________________
Help protect your PC.  Get a FREE computer virus scan online from McAfee. 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Re: [Firebird-net-provider] Plans for the FbHelper class

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

Hello:

> Well, I don't want to change your current plans :-)


I have reviews yet one thing :) ( there are changes in CVS ), the other 
thing is that
i'm thinking on remove the ParameterCache and add to FbHelper a 
DeriverParameters method
probably with some overloads... i will reiview it later today :)


-- 
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] Plans for the FbHelper class

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

Hello:

> Well, I don't want to change your current plans :-)


No problem i will try review one thing later today :)

>
> I'll look at the sample app to see usage. I need to run stored procedure
> that returns value (with ExecuteNonSql) and some selectable stored
> procedure. I saw some methods used for parameters creation are returning
> IDataParameters instead of FbParameters.... why?


Because i have abstracted the DAAB for allow database independence, this is
good for people that uses more that one RDBMS, but i have made 
implementation
only for firebird ;)



-- 
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.