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

[Firebird-net-provider] Transactions...

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

I wonder what's wrong. I am using Firebird .NET provider (latest BETA
release) with .NET 1.1.

I wrap all FbCommand objects with an FbTransaction object, which I
get by calling FbConnection.BeginTransaction (). However, as soon as
I open a transaction with IBExpert on the same data table I want to
SELECT from .NET, the call to FbDataAdapter.Fill blocks, until I
commit my changes in IBExpert.

Can I change this behaviour and have the transaction not block ? Is
this something on the ADO.NET side or on the IBExpert side ?

Thanks...

    Pierre

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

[Josauro S.J. <jo...@ca...>]

I sorry

but it's don't work fine yeat.

Dim selectCmd As String

selectCmd =3D "SELECT * FROM GET_RECIBOS(@CLI_REFERENCIA)"

Dim myCommand =3D New FbCommand(selectCmd, myConnection, myTxn)

myCommand.CommandType =3D CommandType.StoredProcedure

myCommand.parameters.add("@CLI_REFERENCIA", FbType.VarChar).Value =3D =
Cliente

Dim Result As FbDataReader =3D =
myCommand.executeReader(CommandBehavior.CloseConnection)



CREATE PROCEDURE GET_RECIBOS (
    CLI_REFERENCIA VARCHAR(12))
RETURNS (
    REC_CODIGO DOUBLE PRECISION,
    REC_CLIENTE DOUBLE PRECISION,
    REC_DATA DATE,
    REC_DATA_LIMITE DATE,
    REC_VALOR_ALUGUEL NUMERIC(15,2),
    REC_VALOR_TAXA NUMERIC(15,2),
    REC_VALOR_MULTA_DESCONTO NUMERIC(15,2),
    VR_VALOR_LIQUIDO NUMERIC(15,2),
    VR_VALOR_BRUTO NUMERIC(15,2),
    REC_DESCRICAO_PERIODO VARCHAR(40),
    REC_NUMERO_RECIBO INTEGER,
    REC_NUMERO_BANCARIO VARCHAR(15))
AS
DECLARE VARIABLE VR_MULTA_DESCONTO CHAR(1);
DECLARE VARIABLE VR_CLIENTE DOUBLE PRECISION;
begin
  /* Procedure Text */
  SELECT CODIGO FROM get_codigo_cliente(:CLI_REFERENCIA)
  INTO :VR_CLIENTE
  ;
  SELECT REC_CODIGO,
         REC_CLIENTE,
         REC_DATA,
         REC_DATA_LIMITE,
         REC_VALOR_ALUGUEL,
         REC_MULTA_DESCONTO,
         REC_VALOR_MULTA_DESCONTO,
         REC_DESCRICAO_PERIODO,
         REC_NUMERO_RECIBO,
         REC_NUMERO_BANCARIO
  FROM RECIBO
  WHERE REC_CLIENTE =3D :VR_CLIENTE
  INTO :REC_CODIGO,
       :REC_CLIENTE,
       :REC_DATA,
       :REC_DATA_LIMITE,
       :REC_VALOR_ALUGUEL,
       :VR_MULTA_DESCONTO,
       :REC_VALOR_MULTA_DESCONTO,
       :REC_DESCRICAO_PERIODO,
       :REC_NUMERO_RECIBO,
       :REC_NUMERO_BANCARIO
  ;
  IF  (VR_MULTA_DESCONTO =3D 'D')
  THEN BEGIN
     VR_VALOR_BRUTO   =3D :REC_VALOR_ALUGUEL
                      + :REC_VALOR_TAXA;
     VR_VALOR_LIQUIDO =3D VR_VALOR_BRUTO
                      - :REC_VALOR_MULTA_DESCONTO;
  END
  ELSE BEGIN
     VR_VALOR_BRUTO   =3D :REC_VALOR_ALUGUEL
                      + :REC_VALOR_TAXA
                      + :REC_VALOR_MULTA_DESCONTO;
     VR_VALOR_LIQUIDO =3D VR_VALOR_BRUTO
                      - :REC_VALOR_MULTA_DESCONTO;
  END
end

Exce=E7=E3o do tipo FirebirdSql.Data.INGDS.GDSException foi acionada.=20
Descri=E7=E3o: Ocorreu uma exce=E7=E3o n=E3o tratada durante a =
execu=E7=E3o da atual solicita=E7=E3o da Web. Examine o rastreamento de =
pilha para obter mais informa=E7=F5es sobre o erro e onde foi originado =
no c=F3digo.=20

Detalhes da Exce=E7=E3o: FirebirdSql.Data.INGDS.GDSException: =
Exce=E7=E3o do tipo FirebirdSql.Data.INGDS.GDSException foi acionada.

Erro de Origem:=20

Linha 99:             Dim objRecibo =3D New RecibosDB
Linha 100:
Linha 101:            grdRecibo.DataSource =3D =
objRecibo.GetRecibos("00025.005.01")
Linha 102:
Linha 103:            grdRecibo.DataBind()=20

Arquivo de Origem: =
C:\Inetpub\DNNFramework\DotNetNuke1010\DesktopModules\Recibos\ListaRecibo=
s.ascx.vb    Linha: 101=20

Rastreamento de Pilha:=20

[GDSException: Exce=E7=E3o do tipo FirebirdSql.Data.INGDS.GDSException =
foi acionada.]
   FirebirdSql.Data.Firebird.FbStatement.Execute()
   FirebirdSql.Data.Firebird.FbCommand.ExecuteReader(CommandBehavior =
behavior)

[FbException: multiple rows in singleton select
]
   Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, =
Type objType, String name, Object[] args, String[] paramnames, Boolean[] =
CopyBack)
   DotNetNuke.ListaRecibos.BindGrid() in =
C:\Inetpub\DNNFramework\DotNetNuke1010\DesktopModules\Recibos\ListaRecibo=
s.ascx.vb:101
   DotNetNuke.ListaRecibos.Button1_Click(Object sender, EventArgs e) in =
C:\Inetpub\DNNFramework\DotNetNuke1010\DesktopModules\Recibos\ListaRecibo=
s.ascx.vb:148
   System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   =
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.Rais=
ePostBackEvent(String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler =
sourceControl, String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   System.Web.UI.Page.ProcessRequestMain()
=20



Josauro S.J.
Diretor
e-mail: jo...@ca...
   site: www.casasoft.inf.br

Portal de im=F3veis www.IndicadorDeIm=F3veis.com.br

O =FAnico Portal de im=F3veis 100% on-line com as imobili=E1rias, =
im=F3veis atualizados minuto a minuto a certeza de que o im=F3vel =
anunciado realmente esta Dispon=EDvel.

  ----- Original Message -----=20
  From: Carlos Guzm=E1n =C1lvarez=20
  To: Josauro S.J.=20
  Cc: fir...@li...=20
  Sent: Tuesday, November 25, 2003 7:50 AM
  Subject: Re: [Firebird-net-provider] =
FirebirdSql.Data.INGDS.GDSException


  Hello:

  > Hello:
  > =20
  > I change my code to  ...("EXECUTE PROCEDURE=20
  > GET_RECIBOS(@CLI_REFERENCIA)" )...
  > And the error not ocurrs, but other error about cant return =
multiples=20
  > row in singleton select....

  SELECT * FROM GET_RECIBOS(@CLI_REFERENCIA)



  --
  Best regards

  Carlos Guzm=E1n =C1lvarez
  Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

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

Hello:

> Hello:
>  
> I change my code to  ...("EXECUTE PROCEDURE 
> GET_RECIBOS(@CLI_REFERENCIA)" )...
> And the error not ocurrs, but other error about cant return multiples 
> row in singleton select....

SELECT * FROM GET_RECIBOS(@CLI_REFERENCIA)



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

[Josauro S.J. <jo...@ca...>]

Hello:

I change my code to  ...("EXECUTE PROCEDURE =
GET_RECIBOS(@CLI_REFERENCIA)" )...
And the error not ocurrs, but other error about cant return multiples =
row in singleton select....

Josauro S.J.
Diretor
e-mail: jo...@ca...
   site: www.casasoft.inf.br

Portal de im=F3veis www.IndicadorDeIm=F3veis.com.br

O =FAnico Portal de im=F3veis 100% on-line com as imobili=E1rias, =
im=F3veis atualizados minuto a minuto a certeza de que o im=F3vel =
anunciado realmente esta Dispon=EDvel.

  ----- Original Message -----=20
  From: Carlos Guzm=E1n =C1lvarez=20
  To: Josauro S.J.=20
  Cc: fir...@li...=20
  Sent: Monday, November 24, 2003 7:39 PM
  Subject: Re: [Firebird-net-provider] =
FirebirdSql.Data.INGDS.GDSException


  Hello:

  Ok, thanks :), two questions whic version of the .net data provider =
are=20
  you using ??

  > CREATE PROCEDURE GET_RECIBOS (
   >
  > [FbException: Dynamic SQL Error
  > SQL error code =3D -104
  > Token unknown - line 1, char 1
  > GET_RECIBOS
  > ]

  Huummmm you have the sp created as:

  CREATE PROCEDURE GET_RECIBOS (

  or as:

  CREATE PROCEDURE "GET_RECIBOS" (

  ??



  --
  Best regards

  Carlos Guzm=E1n =C1lvarez
  Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

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

Hello:

> First
>  
> I'm using    data Provider  1.5 Beta 4  Net 1.1.
>  
> Second
>  
> I had  sp created as:
> 
> CREATE PROCEDURE GET_RECIBOS (

Thanks, can you try to debug the ExecuteReader call for see what is the 
command that is being executed ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

[Josauro S.J. <jo...@ca...>]

First

I'm using    data Provider  1.5 Beta 4  Net 1.1.

Second

I had  sp created as:

CREATE PROCEDURE GET_RECIBOS (

Thanks

Josauro S.J.
Diretor
e-mail: jo...@ca...
   site: www.casasoft.inf.br

Portal de im=F3veis www.IndicadorDeIm=F3veis.com.br

O =FAnico Portal de im=F3veis 100% on-line com as imobili=E1rias, =
im=F3veis atualizados minuto a minuto a certeza de que o im=F3vel =
anunciado realmente esta Dispon=EDvel.

  ----- Original Message -----=20
  From: Carlos Guzm=E1n =C1lvarez=20
  To: Josauro S.J.=20
  Cc: fir...@li...=20
  Sent: Monday, November 24, 2003 7:39 PM
  Subject: Re: [Firebird-net-provider] =
FirebirdSql.Data.INGDS.GDSException


  Hello:

  Ok, thanks :), two questions whic version of the .net data provider =
are=20
  you using ??

  > CREATE PROCEDURE GET_RECIBOS (
   >
  > [FbException: Dynamic SQL Error
  > SQL error code =3D -104
  > Token unknown - line 1, char 1
  > GET_RECIBOS
  > ]

  Huummmm you have the sp created as:

  CREATE PROCEDURE GET_RECIBOS (

  or as:

  CREATE PROCEDURE "GET_RECIBOS" (

  ??



  --
  Best regards

  Carlos Guzm=E1n =C1lvarez
  Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

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

Hello:

Ok, thanks :), two questions whic version of the .net data provider are 
you using ??

> CREATE PROCEDURE GET_RECIBOS (
 >
> [FbException: Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 1, char 1
> GET_RECIBOS
> ]

Huummmm you have the sp created as:

CREATE PROCEDURE GET_RECIBOS (

or as:

CREATE PROCEDURE "GET_RECIBOS" (

??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

[Josauro S.J. <jo...@ca...>]

HI:

My Code FireBird ***

CREATE PROCEDURE GET_RECIBOS (
    CLI_REFERENCIA VARCHAR(12))
RETURNS (
    REC_CODIGO DOUBLE PRECISION,
    REC_CLIENTE DOUBLE PRECISION,
    REC_DATA DATE,
    REC_DATA_LIMITE DATE,
    REC_VALOR_ALUGUEL NUMERIC(15,2),
    REC_VALOR_TAXA NUMERIC(15,2),
    REC_VALOR_MULTA_DESCONTO NUMERIC(15,2),
    VR_VALOR_LIQUIDO NUMERIC(15,2),
    VR_VALOR_BRUTO NUMERIC(15,2),
    REC_DESCRICAO_PERIODO VARCHAR(40),
    REC_NUMERO_RECIBO INTEGER,
    REC_NUMERO_BANCARIO VARCHAR(15))
AS
DECLARE VARIABLE VR_MULTA_DESCONTO CHAR(1);
DECLARE VARIABLE VR_CLIENTE DOUBLE PRECISION;
begin
  /* Procedure Text */
  SELECT CODIGO FROM get_codigo_cliente(:CLI_REFERENCIA)
  INTO :VR_CLIENTE
  ;
  SELECT REC_CODIGO,
         REC_CLIENTE,
         REC_DATA,
         REC_DATA_LIMITE,
         REC_VALOR_ALUGUEL,
         REC_MULTA_DESCONTO,
         REC_VALOR_MULTA_DESCONTO,
         REC_DESCRICAO_PERIODO,
         REC_NUMERO_RECIBO,
         REC_NUMERO_BANCARIO
  FROM RECIBO
  WHERE REC_CLIENTE =3D :VR_CLIENTE
  INTO :REC_CODIGO,
       :REC_CLIENTE,
       :REC_DATA,
       :REC_DATA_LIMITE,
       :REC_VALOR_ALUGUEL,
       :VR_MULTA_DESCONTO,
       :REC_VALOR_MULTA_DESCONTO,
       :REC_DESCRICAO_PERIODO,
       :REC_NUMERO_RECIBO,
       :REC_NUMERO_BANCARIO
       ;
  IF  (VR_MULTA_DESCONTO =3D 'D')
  THEN BEGIN
     VR_VALOR_BRUTO   =3D :REC_VALOR_ALUGUEL
                      + :REC_VALOR_TAXA;
     VR_VALOR_LIQUIDO =3D VR_VALOR_BRUTO
                      - :REC_VALOR_MULTA_DESCONTO;
  END
  ELSE BEGIN
     VR_VALOR_BRUTO   =3D :REC_VALOR_ALUGUEL
                      + :REC_VALOR_TAXA
                      + :REC_VALOR_MULTA_DESCONTO;
     VR_VALOR_LIQUIDO =3D VR_VALOR_BRUTO
                      - :REC_VALOR_MULTA_DESCONTO;
  END
  suspend;
end


My Vb.net Code

Public Function GetFBConnectionString() As String

Return ConfigurationSettings.AppSettings("FBConnectionString")

End Function



Public Function GetRecibos() As FbDataReader

Dim myConnection2 =3D New FbConnection(GetFBConnectionString)

myConnection2.Open()

myTxn =3D myConnection2.BeginTransaction()

selectCmd =3D "GET_RECIBOS"

Dim myCommand =3D New FbCommand(selectCmd, myConnection2, myTxn)

myCommand.CommandType =3D CommandType.StoredProcedure

myCommand.parameters.add("@CLI_REFERENCIA", FbType.VarChar).Value =3D =
"00025.005.01"

Dim Result As FbDataReader =3D =
myCommand.executeReader(CommandBehavior.CloseConnection) '<--****  HERE =
CODE BREACK **->

Return Result



End Function




My exception.


Exce=E7=E3o do tipo FirebirdSql.Data.INGDS.GDSException foi acionada.=20
Descri=E7=E3o: Ocorreu uma exce=E7=E3o n=E3o tratada durante a =
execu=E7=E3o da atual solicita=E7=E3o da Web. Examine o rastreamento de =
pilha para obter mais informa=E7=F5es sobre o erro e onde foi originado =
no c=F3digo.=20

Detalhes da Exce=E7=E3o: FirebirdSql.Data.INGDS.GDSException: =
Exce=E7=E3o do tipo FirebirdSql.Data.INGDS.GDSException foi acionada.

Erro de Origem:=20


Linha 99:             Dim objRecibo =3D New RecibosDB
Linha 100:
Linha 101:            grdRecibo.DataSource =3D objRecibo.GetRecibos()
Linha 102:
Linha 103:            grdRecibo.DataBind()=20


Arquivo de Origem: =
C:\Inetpub\DNNFramework\DotNetNuke1010\DesktopModules\Recibos\ListaRecibo=
s.ascx.vb    Linha: 101=20

Rastreamento de Pilha:=20


[GDSException: Exce=E7=E3o do tipo FirebirdSql.Data.INGDS.GDSException =
foi acionada.]
   FirebirdSql.Data.Firebird.FbStatement.Prepare()
   FirebirdSql.Data.Firebird.FbCommand.Prepare()

[FbException: Dynamic SQL Error
SQL error code =3D -104
Token unknown - line 1, char 1
GET_RECIBOS
]
   Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, =
Type objType, String name, Object[] args, String[] paramnames, Boolean[] =
CopyBack) +899
   DotNetNuke.ListaRecibos.BindGrid() in =
C:\Inetpub\DNNFramework\DotNetNuke1010\DesktopModules\Recibos\ListaRecibo=
s.ascx.vb:101
   DotNetNuke.ListaRecibos.Button1_Click(Object sender, EventArgs e) in =
C:\Inetpub\DNNFramework\DotNetNuke1010\DesktopModules\Recibos\ListaRecibo=
s.ascx.vb:148
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   =
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.Rais=
ePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler =
sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) =
+33
   System.Web.UI.Page.ProcessRequestMain() +1277
=20




-------------------------------------------------------------------------=
-------

Informa=E7=F5es sobre a Vers=E3o: Microsoft .NET Framework =
Vers=E3o:1.1.4322.573; Vers=E3o do ASP.NET:1.1.4322.573=20


  Hello:

  > Why it's breack with message...  =
/FirebirdSql.Data.INGDS.GDSException/

  In first place your code seems to be correct, can you send the stack=20
  trace ??

  In which line of the function source is giving the exception ??




  --
  Best regards

  Carlos Guzm=E1n =C1lvarez
  Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

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

Hello:

> Why it's breack with message...  /FirebirdSql.Data.INGDS.GDSException/

In first place your code seems to be correct, can you send the stack 
trace ??

In which line of the function source is giving the exception ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FirebirdSql.Data.INGDS.GDSException

[Josauro S.J. <jo...@ca...>]

Why it's breack with message...  FirebirdSql.Data.INGDS.GDSException

Public Function GetRecibos(Optional ByVal Cliente As String =3D =
"00001.001.01") As FbDataReader

Dim myConnection2 =3D New FbConnection(GetFBConnectionString)

myConnection2.Open()

myTxn =3D myConnection2.BeginTransaction()

selectCmd =3D "GET_RECIBOS"

Dim myCommand =3D New FbCommand(selectCmd, myConnection2, myTxn)

' Mark the Command as a SPROC

myCommand.CommandType =3D CommandType.StoredProcedure

myCommand.parameters.add("@CLI_REFERENCIA", FbType.VarChar).Value =3D =
"00025.005.01"

Dim Result As FbDataReader =3D myCommand.executeReader()

Return Result



End Function

Josauro S.J.

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

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

Hello:

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

I'm thinking on make this yet, for 1.5 version, before enter in RC 
stage, opinions are wellcome.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

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

Hello:

> I am new to this group 

Be wellcome :)

>- my vote goes to embedded
> database for simple reason of me being inclined to
> use Firebird for my distributable project because
> it would make deployment a lot easy - a feature
> that would differentiate FB from MySQL and
> PostgreSQL.

Thanks :)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FB backup gives error Server: WIN XP Home Edition

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

Hello:

> Anyways I am happy my problem is solved.
> Thanx a lot.

Ok, in any case i will try to do some more tests with CS it's very strange.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FB backup gives error Server: WIN XP Home Edition

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

Hi Carlos,

:)

Problem solved with super-server on XP.
But on 2000, classic was installed and backup was working fine, well
strange.

Anyways I am happy my problem is solved.
Thanx a lot.

Regards,
sguha.


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

From: <carlosga@te...>
 Re: FB backup gives error Server: WIN XP Home Edition
2003-11-19 01:44
 Hello:

 > RC6 installed as classic server.

 I have tested it only with Super Server ;) i'm not sure what is the
 exact status of the services API in Classic Server ( i'm going to try to
 reinstall firebird as CS and give a try to the services api
 implementation in the .net provider using the nunit test suite)




 --
 Best regards

 Carlos Guzmán Álvarez
 Vigo-Spain

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

Hi Carlos,

 FB .NEt Prov 1.5 for .NET 1.1 Beta 4
 RC6 installed as classic server.

 Cant figure out problem :(

 sguha


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


 From: <carlosga@te...>
  Re: FB backup gives error Server: WIN XP Home Edition
 2003-11-18 00:00
  Hello:

  > Same problem on XP Home with Backup !!!!

  I'm in XP too.

  > Config: FB1.5 RC6 / .NET Prov 1.1 Beta 4
  > ServerOS: WINXP Home

  Installed as Classic Server or as Super Server ??

   > .NET Prov 1.1 Beta 4

  1.5 Beta 4 ??



  --
  Best regards

  Carlos Guzmán Ávarez
  Vigo-Spain


 ------------------
 Hi Carlos,

  Same problem on XP Home with Backup !!!!

  Config: FB1.5 RC6 / .NET Prov 1.1 Beta 4
  ServerOS: WINXP Home

  Code:

  Dim bkup as FbBackup
  bkUp = New FbBackup()
  bkUp.UserName = "sysdba"
  bkUp.UserPassword = "masterkey"
  bkUp.Database = "x:\fb\test.fdb"
  bkUp.BackupFiles.Add(New FbBackupFile("x:\fb\backups\test.fbk")
  bkUp.ServerName = "localhost"
  bkUp.Options = FbBackupFlags.IgnoreLimbo

  bkUp.Start()   ********** generates error  "No message for code 472
 found.No
  message for code 243 found."
  bkUp.Close()


  Surprisingly changing SERVER OS to "Win 2000" Pro eliminates the problem.
  Is there something wrong using "WIN XP home" as the server OS?


  Regards,
  sguha.

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

[Alex C. <al...@ch...>]

Hi all,

I am new to this group - my vote goes to embedded
database for simple reason of me being inclined to
use Firebird for my distributable project because
it would make deployment a lot easy - a feature
that would differentiate FB from MySQL and
PostgreSQL.

regards,

Alex

Re: [Firebird-net-provider] RE: Firebird-net-provider as Visual studio project

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

Hello:

> I want the source code in my project, not the compiled dll.
> How to?

I don't see the problem ;), download the sources of the .net data 
provider, add a new project to your solution, add the data provider 
sources to the new project and the needed assembly references.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Support for Embedded Firebird database?

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

Hello:

> Does Firebird-net provider support the Embedded version of Firebird 
> database?

No at this moment.

I suggest you to read the thread:

 "Some comments about future developement" - 11/11/2003 19:39

For see plans arround this.




--
Best regards

Carlos Guzmán Álvarez
Vigo-España

[Firebird-net-provider] Support for Embedded Firebird database?

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

Does Firebird-net provider support the Embedded version of Firebird =
database?

Regards
Thomas

[Firebird-net-provider] RE: Firebird-net-provider as Visual studio project

[Majken L. <maj...@ma...>]

Hi Carlos:    
 
I want the source code in my project, not the compiled dll.
 
How to?
 
Regards
Thomas

Re: [Firebird-net-provider] Firebird-net-provider as Visual studio project

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

Hello:

> I want to include Firebird-net provider as a project in my visual 
> studio solution. (source code)
>
> What is the procedure to do this?
>
You need to add a reference to the Firebird .NET data provider into your 
project,
if you have it installed in the GAC see this:

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306149







--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Firebird-net-provider as Visual studio project

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

Carlos:

I want to include Firebird-net provider as a project in my visual studio =
solution. (source code)
What is the procedure to do this?

Regards
Thomas

Re: [Firebird-net-provider] Strange character problem with beta4? (v.1.5.1410.16587)

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

Hello:

> Hi Carlos
>
> Thanks for you'r reply.
>
> Can you give me an example on using parametrized querys?

Of course :)

FbConnection connection = new FbConnection(connectionString);
FbTransaction transaction = connection.BeginTransaction();

FbCommand insert = new FbCommand("insert into table_name (field_name) 
values(@param_name)", connection, transaction);
insert.Parameters.Add("@param_name", FbDbType.Char).Value="@123";

int affected = insert.ExecuteNonQuery();

transaction.Commit();
connection.Close();



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Strange character problem with beta4? (v.1.5.1410.16587)

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

Hi Carlos

Thanks for you'r reply.

Can you give me an example on using parametrized querys?

Regards
Thomas



----- Original Message ----- 
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Thomas" <ja...@ma...>
Cc: "firebird" <fir...@li...>
Sent: Thursday, November 20, 2003 10:26 AM
Subject: Re: [Firebird-net-provider] Strange character problem with beta4?
(v.1.5.1410.16587)


> Hello:
>
> > When I insert this string: string t = "@123";  in my database,
> > only a "?" is appear in the database.
>
> Thew @ is used inside the command text for denote a named parameter,
> named parameters detection is made using regular expressions: at this
> moment this the regex used:
>
> (@{1}\w+)
>
> in beta 2 it was:
>
> (@([a-zA-Z-$][a-zA-Z0-9_$]*))
>
>
> But it's not handling ok the @ wen it appears inside '', if anybody
> knows how to modify it for handle ok this case i will be more than
> happy of modify it :)
>
>
>
> You can use parametrized querys for solve the problem.
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>

[Firebird-net-provider] ASP3AP Benchmark results, Beta 4 vs CVS sources

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

Hello:

Attached to this email are the results of the AS3AP benchmark, running 
using Beta 4 and actual CVS sources.

The benhmark was executed using a machine like this:

* Athlon 1000
* 256MB
* Windows XP
* Firebird 1.5 RC7 Super Server
* .NET Framework 1.0 (SP2)
* Firebird .NET Data Provider Beta 4 and Firebird .NET Data Provider 
binaries built from CVS sources.
* AS3AP 40MB data file.


There are, i think, a significant performance improvement in actual CVS 
sources.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Developement status report

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

Hello:

Summary of changes in CVS
------- -- ------- -- ---

* Changes to improve handling of query parameters, witch conversions of 
parameter values will be done only one time.

* Changes in the wayof store rows fetched, until beta 4 an arraylist was 
used for store the rows fetched as result of a select query now an array 
of objects will be used.

* FbConnection, FbCommand, FbCommandBuilder and FbDataAdapter has now 
better implementations of constructors and constructors ( i thnk ).

* There are some changes in the Firebird Events API implementation.

* Changes for try to get better charset support ( Thanks to Peter Jacobi 
and Oleg Ufaev ).

* In FbCommand the exception that was raised when a string parameter has 
incorrect length has been removed, because firebird has an old bug that 
reports sqllen bad for fields of system tables.

* In FbCommand, batch command execution is now restricted to 
ExecuteReader calls.

* FbDataReader.GetSchema method will now return the size in characters 
for char ad varchar columns.

* The Nunit test suite has been reworked for allow database creation in 
the fly, and the build file will use now NUnit 2.1 for the suite build.

* FbCommand has some fixes for correct checkin of command[actualCommand] 
( Thanks to Pierre Arnaud )



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain