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

Re: [Firebird-net-provider] Possible bug with new stored procedure exec format

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

Hello:

> this piece of code
> 
>     FbCommand Cmd = new FbCommand("SP_VERIFICA_CODICE", Conn);
>     Cmd.CommandType = CommandType.StoredProcedure;
>     Cmd.Parameters.Add("@IN_COD_MSISDN", FbDbType.VarChar).Value =
> edtCodice.Text;
> 
>     FbDataReader dr = Cmd.ExecuteReader();
>     dr.Read();
> 
>     if (!dr.IsDBNull(0))
>     {
>       lblValidazioneCodice.Text = "Codice valido e utilizzabile";
>     }
>     else
>     {
>      lblValidazioneCodice.Text = "Codice o MSISDN inesistente";
>     }
> 
>     dr.Close();
> 
> causes the following exception

Thanks, fixed on CVS.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Possible bug with new stored procedure exec format

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

Hola Carlos,

this piece of code

    FbCommand Cmd = new FbCommand("SP_VERIFICA_CODICE", Conn);
    Cmd.CommandType = CommandType.StoredProcedure;
    Cmd.Parameters.Add("@IN_COD_MSISDN", FbDbType.VarChar).Value =
edtCodice.Text;

    FbDataReader dr = Cmd.ExecuteReader();
    dr.Read();

    if (!dr.IsDBNull(0))
    {
      lblValidazioneCodice.Text = "Codice valido e utilizzabile";
    }
    else
    {
     lblValidazioneCodice.Text = "Codice o MSISDN inesistente";
    }

    dr.Close();

causes the following exception

System.ArgumentOutOfRangeException: Index was out of range. Must be
non-negative and less than the size of the collection. Parameter name: index

on dr.Close(); // if removed works ok

Stack Trace:
[ArgumentOutOfRangeException: Index was out of range.  Must be non-negative
and less than the size of the collection.
Parameter name: index]
   System.Collections.ArrayList.get_Item(Int32 index) +91
   FirebirdSql.Data.Firebird.FbCommand.SetOutputParameters() +81
   FirebirdSql.Data.Firebird.FbDataReader.Close() +97
   Acros.Edu.EduStart.btnVerificaCodice_Click(Object sender, EventArgs e) in
d:\webroot\Edu\default.aspx.cs:200
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String eventArgument) +58
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1277

Thank you.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Dispose in OnRowUpdated

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

Hello:

> When I use FbDataAdapter + FbCommandBuilder I must do this?:
> <code>
>      ...
>      using(FbCommand command = new FbCommand(sql, connection, transaction))
>      using(FbDataAdapter adapter = new FbDataAdapter(command))
>      using(FbCommandBuilder builder = new FbCommandBuilder(adapter)) {
>         countUpdated = 0;
>         adapter.RowUpdated += new FbRowUpdatedEventHandler(OnRowUpdated);
>         adapter.Update(dataTable);
>      }
>      ...
>         protected void OnRowUpdated(object sender, FbRowUpdatedEventArgs e)
>         {
>             e.Command.Dispose();  // is this necessary? <---!!!!
>             // it's for me ...
>             if((++_countUpdated % 1000) == 0) {
>                 _transaction.CommitRetaining();
>             }
>         }

In first place can be needed i will try to do some test later today.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FBCommand.splitCommandText

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

Hello:

> FBCommand.splitCommandText splits ; from the command text even if it is
> within quotes denoting a string 'dfgdfg;fdg'.
> 
> 
> The splitCommandText should check whether the semicolon is between quotes or
> not.
> I am unable to insert any string with a ; into the database.
> 
> Any workarounds?

I know this the best way for exec this type of commands at this moment 
is using Parameterized querys.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FirebirdSql.Data.Firebird.Events

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

Hello:

> But the events should be generated across all connections who are listening
> for it, like the second user.

Huummm do you know if this is how it works using the Firebird API ??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Dispose in OnRowUpdated

[Evgeny F. <uf...@pb...>]

Hello, firebird-net-provider.

When I use FbDataAdapter + FbCommandBuilder I must do this?:
<code>
     ...
     using(FbCommand command = new FbCommand(sql, connection, transaction))
     using(FbDataAdapter adapter = new FbDataAdapter(command))
     using(FbCommandBuilder builder = new FbCommandBuilder(adapter)) {
        countUpdated = 0;
        adapter.RowUpdated += new FbRowUpdatedEventHandler(OnRowUpdated);
        adapter.Update(dataTable);
     }
     ...
        protected void OnRowUpdated(object sender, FbRowUpdatedEventArgs e)
        {
            e.Command.Dispose();  // is this necessary? <---!!!!
            // it's for me ...
            if((++_countUpdated % 1000) == 0) {
                _transaction.CommitRetaining();
            }
        }
    ...
</code>
without Dispose - 20000 rows updated... firebird server eats > 600mb
(leaks of memory) of memory!!!

-- 
Ufff...
 Evgeny                          mailto:uf...@pb...

[Firebird-net-provider] FBCommand.splitCommandText

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

FBCommand.splitCommandText splits ; from the command text even if it is
within quotes denoting a string 'dfgdfg;fdg'.


The splitCommandText should check whether the semicolon is between quotes or
not.
I am unable to insert any string with a ; into the database.

Any workarounds?

Regards,
Samrat

[Firebird-net-provider] FirebirdSql.Data.Firebird.Events

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

Hi Carlos,

The situation is, I have 2 users on two different computers.

One of them has executed a procedure which inserts a row in a table "and has
commited
the transaction and released the connection."

The procedure has a POST_EVENT ('string') in it with suspend for returning
output values.

How with the help of FBEvents can, the other user know that, a new row has
been
created in the database? (He is listening for events in a different
connection.)

The example which you gave, is possible on the same computer with the
'same' connection although, the "processEvent" is being raised as soon
as I have done queEvents.

If I am not wrong, the RegisterEvents is the same for embedded SQL EVENT
INIT and
the QueEvents is the same for embedded SQL EVENT WAIT.

But the events should be generated across all connections who are listening
for it,
like the second user.

Any help would be appreciated.

regards,
Samrat.



--------------------------------------
> Can anyone please tell me what I am doing wrong?


 Can you send a test case ??

 Here the sample of the NUnit test::

 FbEvent FbEvent = new FbEvent(connection);

 FbEventAlertEventHandler e = new FbEventAlertEventHandler(processEvent);

 FbEvent.EventAlert += e;
 FbEvent.RegisterEvents("new row", "updated row");

 FbEvent.QueEvents();

 FbCommand command = new FbCommand("UPDATE test_table_01 SET char_field =
 'events test'", connection , transaction);

 command.ExecuteNonQuery();

 transaction.Commit();

 FbEvent.QueEvents();
--
 Bets regards

 Carlos Guzmán Álvarez
 Vigo-Spain
----------------------------------------------
Hi,

 I had a question about POST_EVENT and register events.

 In my procedure I have a line
 POST_EVENT('NEW CUST').

 In the front end .NET, using FirebirdNETProvider1.5-Alpha1,

 I am listening for events as follows:

 Public fbEv As FbEvent
   fbEv = New FbEvent(conn)
   fbEv.RegisterEvents(New String() {"NEW CUST"})
   fbEv.QueEvents()
   AddHandler fbEv.EventAlert, AddressOf listenEv
 End Sub

 Public Sub listenEv(ByVal sender As Object, ByVal e As
 FirebirdSql.Data.Firebird.Events.FbEventAlertEventArgs)
   MsgBox("Customer Created")
 End Sub

 I am not being able to receive the Event.

 Can anyone please tell me what I am doing wrong?

 Regards,
 Sam.

[Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.5 Alpha 2 ( for .NET 1.0 ) released.

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

Hello:

Firebird .NET Data Provider 1.5 Alpha 2 ( for .NET 1.0 ) available for 
download.


Release Changes:


Alpha 2 ( 2003-09-02 )
------- --------------

- Better fit to ADO.NET.

- Bug fixes.

- Improved Command Builder implementation.

- Improved connection string design time support.

- Improved array data type support ( Thanks to Jesus Arevalo for his 
feedback ).

- Added SQL Server like Stored Procedure calls.


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


You can download binarys ( for Windows and .NET Framework 1.0 ) at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Alpha2.exe?download


You can download sources at:

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


You can download documentation at:

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




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] charset parameter for connect

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

Hello:

> Ok i'm going to add a fix for this adding the charsets in a different 
> method and using try ... catch this can be good too for mono that 
> doesn't have all the encodings implemented if i remember well.

The fix is on CVS yet :) thanks.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Minor mispellings

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

Hello:

> Hola Carlos,
> there are some minor mispellings (if I'm correct), for example:
> 
> GdsAttachement.cs (should be GdsAttachment.cs)
> GdsDbAttachement.cs (should be GdsDbAttachment.cs)
> GdsEvtAttachement.cs (should be GdsEvtAttachment.cs)
> GdsSvcAttachement.cs (should be GdsSvcAttachment.cs)

Thanks you very much, fixed on CVS :)

> Now I have some time to help you with ASP.NET examples, tell me what is
> needed.

I think we can try to do a little app using EMPLOYEE.FDB database or 
make anything from scratch ( i was thinkin on make a little bug tracker 
), ideas are wellcome :), in any case i help is appreciated as i don't 
have too much experience with ASP.NET :)





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] MONO

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

Hello:

> im going to try mono on linux with firebird, so i want to ask what 
> problems i have to expect an any other experience will be welcome.
> 
> And i want to ask Carlos whats are diferences in mono and .net builds... 

Windows builds are made using nant and mono/linux build at this moment 
is made using a makefile.

> Whats not working in mono?

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 (in 1.5 version the FbCommandBuilder generates 
parameters naes using named params).

See the KNOWN.TXT file for see other issues :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] charset parameter for connect

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

Hello:

> Okey. I have done this. Problem code for my situation:
> GdsDbAttachement.cs
>     internal class GdsDbAttachement : GdsAttachement
>     {
>     ..
>         public static void InitializeCharSets()
>         {
>         ..
>                charSets.Add(22, "ISO8859_2"    , "iso-8859-2");
>         ......
> I has installed this codepage in my system (win2000) and all work. But
> I think - this is not good decision of problem. Really, can will be
> necessary to install too much codepages... I am a rights?

Ok i'm going to add a fix for this adding the charsets in a different 
method and using try ... catch this can be good too for mono that 
doesn't have all the encodings implemented if i remember well.


Thanks very much.


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] MONO

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

Hi,

im going to try mono on linux with firebird, so i want to ask what 
problems i have to expect an any other experience will be welcome.

And i want to ask Carlos whats are diferences in mono and .net builds... 
Whats not working in mono?

pavol

[Firebird-net-provider] Minor mispellings

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

Hola Carlos,
there are some minor mispellings (if I'm correct), for example:

GdsAttachement.cs (should be GdsAttachment.cs)
GdsDbAttachement.cs (should be GdsDbAttachment.cs)
GdsEvtAttachement.cs (should be GdsEvtAttachment.cs)
GdsSvcAttachement.cs (should be GdsSvcAttachment.cs)

Now I have some time to help you with ASP.NET examples, tell me what is
needed.

Ciao,
Alessandro Petrelli.

Re[2]: [Firebird-net-provider] charset parameter for connect

[Evgeny F. <uf...@pb...>]

Hi, Carlos.

You wrote 2 ñåíòÿáðÿ 2003 ã., 11:48:19:

> Hello:

>> ArgumentException::Inadmissible or not supported type of the code page.
>> (this message from system (!) and socrat translated it from russian...:)
>> 
>> I think what problem in GdsDbAttachement.InitializeCharSets()
>> ...ufff... I don't write english:-/

> I have made a test using WIN1251 without having problems, can you get 
> the source package of the .net provider, build it, and test if you have 
> the same problem ??

Okey. I have done this. Problem code for my situation:
GdsDbAttachement.cs
    internal class GdsDbAttachement : GdsAttachement
    {
    ..
        public static void InitializeCharSets()
        {
        ..
               charSets.Add(22, "ISO8859_2"    , "iso-8859-2");
        ......
I has installed this codepage in my system (win2000) and all work. But
I think - this is not good decision of problem. Really, can will be
necessary to install too much codepages... I am a rights?


-- 
Best regards,
 Evgeny                          mailto:uf...@pb...

Re: [Firebird-net-provider] FirebirdSql.Data.Firebird.Events

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

Hello:
> Can anyone please tell me what I am doing wrong?


Can you send a test case ??

Here the sample of the NUnit test::

FbEvent FbEvent = new FbEvent(connection);

FbEventAlertEventHandler e = new FbEventAlertEventHandler(processEvent);

FbEvent.EventAlert += e;
FbEvent.RegisterEvents("new row", "updated row");
			
FbEvent.QueEvents();

FbCommand command = new FbCommand("UPDATE test_table_01 SET char_field = 
'events test'", connection , transaction);			

command.ExecuteNonQuery();

transaction.Commit();

FbEvent.QueEvents();



-- 
Bets regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] charset parameter for connect

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

Hello:

> ArgumentException::Inadmissible or not supported type of the code page.
> (this message from system (!) and socrat translated it from russian...:)
> 
> I think what problem in GdsDbAttachement.InitializeCharSets()
> ...ufff... I don't write english:-/

I have made a test using WIN1251 without having problems, can you get 
the source package of the .net provider, build it, and test if you have 
the same problem ??




-- 
Best Regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] charset parameter for connect

[Evgeny F. <uf...@pb...>]

Hello, Anybody!

I have problem with NETProvider 1.5 Alpha X (1.0 was correct) NF1.1

...
string connectionString =
       "Database=data.fdb;" +
       "User=SYSDBA;" +
       "Password=masterkey;" +
       "Dialect=3;" +
       "Server=ufff;" +
       "Charset=WIN1251;"; //!!!
FbConnection dbcon = new FbConnection(connectionString);
dbcon.Open();
...

start... and booooh

ArgumentException::Inadmissible or not supported type of the code page.
(this message from system (!) and socrat translated it from russian...:)

I think what problem in GdsDbAttachement.InitializeCharSets()
...ufff... I don't write english:-/

-- 
ufff...
 Evgeny                          mailto:uf...@pb...

[Firebird-net-provider] FirebirdSql.Data.Firebird.Events

[Samrat G. <sam...@ho...>]

Hi,

I had a question about POST_EVENT and register events.

In my procedure I have a line
POST_EVENT('NEW CUST').

In the front end .NET, using FirebirdNETProvider1.5-Alpha1,

I am listening for events as follows:

Public fbEv As FbEvent
  fbEv = New FbEvent(conn)
  fbEv.RegisterEvents(New String() {"NEW CUST"})
  fbEv.QueEvents()
  AddHandler fbEv.EventAlert, AddressOf listenEv
End Sub

Public Sub listenEv(ByVal sender As Object, ByVal e As
FirebirdSql.Data.Firebird.Events.FbEventAlertEventArgs)
  MsgBox("Customer Created")
End Sub

I am not being able to receive the Event.

Can anyone please tell me what I am doing wrong?

Regards,
Sam.

_________________________________________________________________
On the move? Need to access your mails? 
http://server1.msn.co.in/sp03/mobilesms/index.asp Hotmail is now on your 
mobile!

Re: [Firebird-net-provider] net provider data access block

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

Hello:

> It's not available yet.

In any case to use it with Firebird .NET Data Provider 1.5 you can make 
  the conversion by change the SqlXXX objects for FbXXX objects and 
adding comments to XmlReader methods that are not supported by the 
Firebird .NET Data Provider.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] net provider data access block

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

Hello:

> You said you finished the conversion of the ms data blocks to use 
> firebird, 

Yes but finally i have made more changes for allow to be use with than 
one database and i have removed all static methods, as i tell some days 
ago i need to test it, probably with the Sample application when i start 
  with it.

> is that available yet for download and is it totally working 
> and compatible?

It's not available yet.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] net provider data access block

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

Hey Carlos,

You said you finished the conversion of the ms data blocks to use =
firebird, is that available yet for download and is it totally working =
and compatible?

thanks,

LEE CONNELL

Re: [Firebird-net-provider] Invalid PInvoke metadata format exception

[Jim M. <jim...@co...>]

Thanks for your reply.  I looked at the links, had googled them before I =
think.  I have the problem fixed, but not sure exactly why.  I had =
uninstalled .NET 1.1, but that caused problems where my app could not =
find System and other derived classes.  It looked like a config file =
problem, so rather than wade thru that I reinstalled 1.1.  My app then =
worked!.  I'm still not sure exactly what went wrong, but I do =
understand that there was a conflict with the firebird provider and 1.1. =
 I guess I need to get a better understanding of how all the =
machine.config and others work!

"stevyn dembo" <sr...@ya...> wrote in message =
news:200...@we......
  Hello Jim:

  If you are using Visual Studio 2002, it (VS) is rev-locked to =
Framework 1.0.   However if you
  install Framework 1.1, the installation will upgrade any applications =
in IIS to run with Framework 1.1 .
  Then when you use the web application, the application will recompile =
automatically under 1.1.
  I have the exact same situation because I am still doing web app =
development in Visual Studio (2002) and having my applications run in =
FrameWork 1.1.  Works just fine -- this is the great side-by-side =
feature of assemblies and forward version compatibility).   Had to do =
this because
  COM Interop in Framework 1.0 is buggy.  Most applications should =
upgrade to 1.1 without problems, however if you must run under 1.0 =
because of version dependencies then change the IIS mappings(.aspx,etc) =
for
  your application back to 1.0 framework.

  some helpful links for you:

  =
http://msdn.microsoft.com/netframework/technologyinfo/versioncomparison/d=
efault.aspx

  =
http://msdn.microsoft.com/library/en-us/dnnetdep/html/sidexsidenet.asp?fr=
ame=3Dtrue

  regards,
  stevyn r dembo


  Jim Maguire <jim...@co...> wrote:
    Carlos,

    I looked at my working Dev machine, and the References to System use
    1.0.3300.0, BUT in IIS the Mappings for the .asax file is pointing =
to
    Framework\v1.1.4322\aspnet_isapi.dll. Because I'm using Visual =
Studio 1.0,
    and it only works with Net 1.0, I don't see why it works.

    I thought I would have to change the mapping of .aspx to
    Framework\v1.0.xxxx\aspnet_isapi.dll.

    Can you shed any light on this?

    ""Jim Maguire"" wrote in message
    news:bij937$j8n$1...@ne......
    > Went to Add or Remove Programs and sure enough, 1.1 got installed =
somehow.
    > Maybe it was already there as XP came installed. Removing it now =
and will
    > retest. Thanks again!
    >
    > "Carlos Guzman Alvarez" wrote in message
    > news:3F4...@te......
    > > Hello:
    > >
    > > > firebird net provider 1.0.1241.28320.
    > >
    > > Built for .NET 1.0 or 1.1 ?? Ususally this problems is caused =
for a bad
    > > installation of the .NET or for use the provider build for a =
version of
    > > the .net framework with a different version.
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > > --=20
    > > Best regards
    > >
    > > Carlos Guzm=E1n =C1lvarez
    > > 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
    > >
    >
    >
    >
    >
    > -------------------------------------------------------
    > 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
    >




    -------------------------------------------------------
    This sf.net email is sponsored by:ThinkGeek
    Welcome to geek heaven.
    http://thinkgeek.com/sf
    _______________________________________________
    Firebird-net-provider mailing list
    Fireb ird...@li...
    https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


  This message is intended only for the use of the individual or entity =
to which it is addressed, and may contain information that is =
privileged, confidential and exempt from disclosure under applicable =
law. If the reader of this message is not the intended you are hereby =
notified
  that any dissemination, distribution or copying of this=20
  communication is strictly prohibited.


-------------------------------------------------------------------------=
-----
  Do you Yahoo!?
  Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: [Firebird-net-provider] connection time

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

Hello:

> did anyone performance tests with provider an fb1.5? Is connection 
> pooling needed with this??? As i read on FB lists, native connection 
> times was greatlly improved. Is this true???

I have not made tests on this but if i'm not wrong mayor improvements on 
this are in the use of the XNET protocol in Fb 1.5 for local connections 
(if i'm wrong please correct me :)),



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain