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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-597) Access violation in FesStatement.Finalize

[Hennadii (JIRA) <tr...@fi...>]

Access violation in FesStatement.Finalize
-----------------------------------------

                 Key: DNET-597
                 URL: http://tracker.firebirdsql.org/browse/DNET-597
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, Entity Framework support
    Affects Versions: 4.6.1.0
         Environment: Firebird 2.5.2. x86 FB ADO .NET 4.6.1.0
            Reporter: Hennadii
            Assignee: Jiri Cincura


In our CI I've experienced access violation while running firebird.sqlclient.tests with following managed stack:

   at FB_965910463_Class.isc_dsql_free_statement(IntPtr[], Int32 ByRef, Int16)
   at FB_965910463_Class.IFbClient.isc_dsql_free_statement(IntPtr[], Int32 ByRef, Int16)
   at FirebirdSql.Data.Client.Native.FesStatement.Free(Int32)
   at FirebirdSql.Data.Common.StatementBase.Release()
   at FirebirdSql.Data.Client.Native.FesStatement.Release()
   at FirebirdSql.Data.Client.Native.FesStatement.Dispose(Boolean)
   at FirebirdSql.Data.Common.StatementBase.Finalize()

I don't have a native stack for this, but I look forward get it.

My suggestion bases on this:
 "isc_dsql_allocate_statement2() 
function is similar to the isc_dsql_alloc_statement() function except that 
statement handles allocated using isc_dsql_allocate_statement2() are 
automatically reset to NULL when the database under which they are allocated 
is detached" (taken from ib6.0 beta docs)

I think a database was already deallocated before finalization of statement got to the queue. I think it needs somehow propagate deallocation of the database in managed statement objects.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Connect to Firebird database throws type initializer exception

[Jiří Č. <ji...@ci...>]

> I need the the one for .NET 4.0 and installing from NuGet will give me version 4.5. 

No. It will not.


-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] Connect to Firebird database throws type initializer exception

[Victor B. <niv...@gm...>]

Hi Jiri,

I need the the one for .NET 4.0 and installing from NuGet will give me
version 4.5.

Is there a way for me to install
FirebirdSql.Data.FirebirdClient-4.6.1.0-NET40.7z
<http://sourceforge.net/projects/firebird/files/firebird-net-provider/4.6.1/FirebirdSql.Data.FirebirdClient-4.6.1.0-NET40.7z/download>?
How do I install this version my Visual Studio 2010?

Thank you, and regards.

VICTOR

On Mon, Mar 30, 2015 at 1:14 PM, Jiří Činčura <ji...@ci...> wrote:

> Then just install it from NuGet and you’re fine.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Connect to Firebird database throws type initializer exception

[Jiří Č. <ji...@ci...>]

Then just install it from NuGet and you’re fine.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] Connect to Firebird database throws type initializer exception

[Victor B. <niv...@gm...>]

Hi Jiri,

This exception is coming from the application.

On Sun, Mar 29, 2015 at 12:38 AM, Jiří Činčura <ji...@ci...> wrote:

> Is that exception from DDEX/VS or from your application?
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Connect to Firebird database throws type initializer exception

[Jiří Č. <ji...@ci...>]

Is that exception from DDEX/VS or from your application?

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] Connect to Firebird database throws type initializer exception

[Victor B. <niv...@gm...>]

Hi Everyone,

First of all, a big shout-out to Jiri for his excellent work creating the
providers for us to use.

My issue is that I get this exception "type inializer" when connecting to
the database. I am using Visual Studio 2010 with
FirebirdSql.Data.FirebirdClient-4.6.1.0-NET45 installed.

I realize this issue was brought
According to several articles I've read the solution is to install the
Firebird client for .net 4.0 so I donwloaded
FirebirdSql.Data.FirebirdClient-4.6.1.0-NET40.7z from firebirdsql.org.

Please help me, I do not how to install the .pdb and .dll files into my
solution.

Regards,

VICTOR

[Firebird-net-provider] [FB-Tracker] Created: (DNET-596) Unable to complete network request to host

[Anton V. (JIRA) <tr...@fi...>]

Unable to complete network request to host
------------------------------------------

                 Key: DNET-596
                 URL: http://tracker.firebirdsql.org/browse/DNET-596
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.1.0
         Environment: Client: Windows 7 Home basic x64, Windows 8 Home 
Server: SLES 11.1, 
LI-V2.5.1.26351 Firebird 2.5

            Reporter: Anton Veretennikov
            Assignee: Jiri Cincura
            Priority: Blocker


Unable to complete network request to host "No message for error code 335544721 found.

   at FirebirdSql.Data.Client.Managed.Version10.GdsConnection.Identify(String database) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsConnection.cs:line 198
   at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateManagedDatabase(FbConnectionString options) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\ClientFactory.cs:line 73
   at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateDatabase(FbConnectionString options) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\ClientFactory.cs:line 37
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:line 178

Programm is runned under Admin rights. Windows Firewall is disabled. programm was added to antivirus exceptions.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-595) FbConnectionPoolManager not closing connections

[Thomas K. (JIRA) <tr...@fi...>]

FbConnectionPoolManager not closing connections
-----------------------------------------------

                 Key: DNET-595
                 URL: http://tracker.firebirdsql.org/browse/DNET-595
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
         Environment: any
            Reporter: Thomas Kragh
            Assignee: Jiri Cincura


I believe to have found at problem in FbConnectionPoolManager. In my case the problem shows on a website where there is a spike in user activity in the morning, the user activity results in about 75-100 attachments to the database. However after the spike, the connections/attachments to the database remains. The Connection lifetime is set to 15 in my connectionstring. 

After digging around in the sourcecode I believe I have found the problem in FbConnectionPoolManager, where a Queue<Item> is used to hold available connections. The FIFO nature of the Queue results in every available connections to be checked out of the pool within 15 seconds if there is enough database activity. Thus keeping the 75-100 connection/attachment to the database open for a long period (usually 6-8 hours) 

I believe using a Stack<Item> instead of Queue<Item> could solve the problem.  


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7]inhttp://www.firebirdsql.org/en/net-examples-of-use/

[Paulo C. A. <alt...@gm...>]

Gentlemen,

I want to make a record here: A big thanks to Gerdus van Zyl.

In a very elegant way he solved the problem I did not solve on 40 days.

Works perfectly. Now it's time to get creative and implement.

Again: Thank you.

Paulo Cezar Altafin .·.
Cambé - Pr - Brasil

From: Gerdus van Zyl 
Sent: Wednesday, March 04, 2015 12:53 PM
To: For users and developers of the Firebird .NET providers 
Subject: Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7]inhttp://www.firebirdsql.org/en/net-examples-of-use/

Sorry it seems the converter is not translating the event binding correct or maybe for more recent version of VB.

Anyway instead of
revent.RemoteEventCounts += New FbRemoteEventEventHandler(AddressOf EventCounts)

use this:
AddHandler revent.RemoteEventCounts, New FbRemoteEventEventHandler(AddressOf EventCounts) 




On Wed, Mar 4, 2015 at 5:05 PM, <alt...@gm...> wrote:

  Dearest,

  I had already tried this option. I should have put in the email. Does not work because the "RemoteEventCounts" does not exist for Visual Basic. There is the "RemoteEventId as Integer" option. I am, in this reasoning, be possible to monitor events, but in a different form of language C#, with the handler of Visual Basic events.

  Again, can you help me? Thank U.

  Paulo Cezar Altafin .·.
  Cambé - Pr - Brasil

  From: Gerdus van Zyl 
  Sent: Wednesday, March 04, 2015 6:56 AM
  To: For users and developers of the Firebird .NET providers 
  Subject: Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7] inhttp://www.firebirdsql.org/en/net-examples-of-use/

  Just run the code through telerik code converter here: http://converter.telerik.com/


  On Wed, Mar 4, 2015 at 3:06 AM, <alt...@gm...> wrote:

    Hi, 

    The sample noted is writed in C# and work fine. I’m try in VS 2013 Desktop Express.

    To make it clear, I join it here...
    static void Main(string[] args)
    {

    FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
    cs.DataSource = "localhost";
    cs.Database = "employee.fdb";
    cs.UserID = "SYSDBA";
    cs.Password = "masterkey";
    cs.Charset = "NONE";
    cs.Pooling = false;

    FbConnection connection = new FbConnection(cs.ToString());
    connection.Open();

    FbRemoteEvent revent = new FbRemoteEvent(connection);
    revent.AddEvents(new string[] { "new_order" });

    // Add callback to the Firebird events
    revent.RemoteEventCounts += new FbRemoteEventEventHandler(EventCounts);

    // Queue events
    revent.QueueEvents();

    string sql = "INSERT INTO SALES (PO_NUMBER, CUST_NO, SALES_REP, ORDER_STATUS, " +

    "ORDER_DATE, SHIP_DATE, DATE_NEEDED, PAID, QTY_ORDERED, TOTAL_VALUE, " +
    "DISCOUNT, ITEM_TYPE) VALUES (@po_number, 1004, 11, 'new', " +
    "'1991-03-04 00:00:00', '1991-03-05 00:00:00', NULL, 'y', 10, 5000, " +
    "0.100000001490116, 'hardware');";

    FbCommand command = new FbCommand(sql, connection);
    command.Parameters.Add("@po_number", FbDbType.Char, 8);

    for (int i = 360; i < 365; i++)
    {

    command.Parameters[0].Value = "V91E0" + i.ToString();
    command.ExecuteNonQuery();

    }


    System.Threading.Thread.Sleep(2000);
    connection.Close();
    }

    static void EventCounts(object sender, FbRemoteEventEventArgs args)
    {
    Console.WriteLine("Event {0} has {1} counts.", args.Name, args.Counts);
    }


    My need: A sample writer in Visual Basic .Net (VB.NET). Sameone can put a answer for me? Tanks a lot. 

    Paulo Cezar Altafin .·.
    Cambé - Pr - Brasil

    ------------------------------------------------------------------------------
    Dive into the World of Parallel Programming The Go Parallel Website, sponsored
    by Intel and developed in partnership with Slashdot Media, is your hub for all
    things parallel software development, from weekly thought leadership blogs to
    news, videos, case studies, tutorials and more. Take a look and join the
    conversation now. http://goparallel.sourceforge.net/
    _______________________________________________
    Firebird-net-provider mailing list
    Fir...@li...
    https://lists.sourceforge.net/lists/listinfo/firebird-net-provider





  -- 

  ------------------------------------------------------------------------
  Gerdus van Zyl

  www.infireal.com


------------------------------------------------------------------------------
  ------------------------------------------------------------------------------
  Dive into the World of Parallel Programming The Go Parallel Website, sponsored
  by Intel and developed in partnership with Slashdot Media, is your hub for all
  things parallel software development, from weekly thought leadership blogs to
  news, videos, case studies, tutorials and more. Take a look and join the 
  conversation now. http://goparallel.sourceforge.net/ 
------------------------------------------------------------------------------
  _______________________________________________
  Firebird-net-provider mailing list
  Fir...@li...
  https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


  ------------------------------------------------------------------------------
  Dive into the World of Parallel Programming The Go Parallel Website, sponsored
  by Intel and developed in partnership with Slashdot Media, is your hub for all
  things parallel software development, from weekly thought leadership blogs to
  news, videos, case studies, tutorials and more. Take a look and join the
  conversation now. http://goparallel.sourceforge.net/
  _______________________________________________
  Firebird-net-provider mailing list
  Fir...@li...
  https://lists.sourceforge.net/lists/listinfo/firebird-net-provider





-- 

------------------------------------------------------------------------
Gerdus van Zyl

www.infireal.com



--------------------------------------------------------------------------------
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/ 


--------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7] inhttp://www.firebirdsql.org/en/net-examples-of-use/

[Gerdus v. Z. <ger...@gm...>]

Sorry it seems the converter is not translating the event binding correct
or maybe for more recent version of VB.

Anyway instead of
revent.RemoteEventCounts += New FbRemoteEventEventHandler(AddressOf
EventCounts)

use this:
*AddHandler revent.RemoteEventCounts, New
FbRemoteEventEventHandler(AddressOf EventCounts) *



On Wed, Mar 4, 2015 at 5:05 PM, <alt...@gm...> wrote:

>   Dearest,
>
> I had already tried this option. I should have put in the email. Does not
> work because the "RemoteEventCounts" does not exist for Visual Basic. There
> is the "RemoteEventId as Integer" option. I am, in this reasoning, be
> possible to monitor events, but in a different form of language C#, with
> the handler of Visual Basic events.
>
> Again, can you help me? Thank U.
>
> Paulo Cezar Altafin .·.
> Cambé - Pr - Brasil
>
>  *From:* Gerdus van Zyl <ger...@gm...>
> *Sent:* Wednesday, March 04, 2015 6:56 AM
> *To:* For users and developers of the Firebird .NET providers
> <fir...@li...>
> *Subject:* Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7]
> inhttp://www.firebirdsql.org/en/net-examples-of-use/
>
>  Just run the code through telerik code converter here:
> http://converter.telerik.com/
>
> On Wed, Mar 4, 2015 at 3:06 AM, <alt...@gm...> wrote:
>
>>   Hi,
>>
>> The sample noted is writed in C# and work fine. I’m try in VS 2013
>> Desktop Express.
>>
>> To make it clear, I join it here...
>> static void Main(string[] args)
>> {
>> FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
>> cs.DataSource = "localhost";
>> cs.Database = "employee.fdb";
>> cs.UserID = "SYSDBA";
>> cs.Password = "masterkey";
>> cs.Charset = "NONE";
>> cs.Pooling = false;
>>
>> FbConnection connection = new FbConnection(cs.ToString());
>> connection.Open();
>>
>> FbRemoteEvent revent = new FbRemoteEvent(connection);
>> revent.AddEvents(new string[] { "new_order" });
>>
>> // Add callback to the Firebird events
>> revent.RemoteEventCounts += new FbRemoteEventEventHandler(EventCounts);
>>
>> // Queue events
>> revent.QueueEvents();
>>
>> string sql = "INSERT INTO SALES (PO_NUMBER, CUST_NO, SALES_REP,
>> ORDER_STATUS, " +
>> "ORDER_DATE, SHIP_DATE, DATE_NEEDED, PAID, QTY_ORDERED, TOTAL_VALUE, " +
>> "DISCOUNT, ITEM_TYPE) VALUES (@po_number, 1004, 11, 'new', " +
>> "'1991-03-04 00:00:00', '1991-03-05 00:00:00', NULL, 'y', 10, 5000, " +
>> "0.100000001490116, 'hardware');";
>>
>> FbCommand command = new FbCommand(sql, connection);
>> command.Parameters.Add("@po_number", FbDbType.Char, 8);
>>
>> for (int i = 360; i < 365; i++)
>> {
>> command.Parameters[0].Value = "V91E0" + i.ToString();
>> command.ExecuteNonQuery();
>> }
>>
>> System.Threading.Thread.Sleep(2000);
>> connection.Close();
>> }
>>
>> static void EventCounts(object sender, FbRemoteEventEventArgs args)
>> {
>> Console.WriteLine("Event {0} has {1} counts.", args.Name, args.Counts);
>> }
>>
>> My need: A sample writer in Visual Basic .Net (VB.NET). Sameone can put
>> a answer for me? Tanks a lot.
>>
>> Paulo Cezar Altafin .·.
>> Cambé - Pr - Brasil
>>
>>
>> ------------------------------------------------------------------------------
>> Dive into the World of Parallel Programming The Go Parallel Website,
>> sponsored
>> by Intel and developed in partnership with Slashdot Media, is your hub
>> for all
>> things parallel software development, from weekly thought leadership
>> blogs to
>> news, videos, case studies, tutorials and more. Take a look and join the
>> conversation now. http://goparallel.sourceforge.net/
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>>
>
>
> --
>      ------------------------------------------------
> ------------------------
> Gerdus van Zyl
> www.infireal.com
>
> ------------------------------
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
>
> ------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


-- 
------------------------------------------------------------------------
Gerdus van Zyl
www.infireal.com

Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7] inhttp://www.firebirdsql.org/en/net-examples-of-use/

[<alt...@gm...>]

Dearest,

I had already tried this option. I should have put in the email. Does not work because the "RemoteEventCounts" does not exist for Visual Basic. There is the "RemoteEventId as Integer" option. I am, in this reasoning, be possible to monitor events, but in a different form of language C#, with the handler of Visual Basic events.

Again, can you help me? Thank U.

Paulo Cezar Altafin .·.
Cambé - Pr - Brasil

From: Gerdus van Zyl 
Sent: Wednesday, March 04, 2015 6:56 AM
To: For users and developers of the Firebird .NET providers 
Subject: Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7] inhttp://www.firebirdsql.org/en/net-examples-of-use/

Just run the code through telerik code converter here: http://converter.telerik.com/


On Wed, Mar 4, 2015 at 3:06 AM, <alt...@gm...> wrote:

  Hi, 

  The sample noted is writed in C# and work fine. I’m try in VS 2013 Desktop Express.

  To make it clear, I join it here...
  static void Main(string[] args)
  {

  FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
  cs.DataSource = "localhost";
  cs.Database = "employee.fdb";
  cs.UserID = "SYSDBA";
  cs.Password = "masterkey";
  cs.Charset = "NONE";
  cs.Pooling = false;

  FbConnection connection = new FbConnection(cs.ToString());
  connection.Open();

  FbRemoteEvent revent = new FbRemoteEvent(connection);
  revent.AddEvents(new string[] { "new_order" });

  // Add callback to the Firebird events
  revent.RemoteEventCounts += new FbRemoteEventEventHandler(EventCounts);

  // Queue events
  revent.QueueEvents();

  string sql = "INSERT INTO SALES (PO_NUMBER, CUST_NO, SALES_REP, ORDER_STATUS, " +

  "ORDER_DATE, SHIP_DATE, DATE_NEEDED, PAID, QTY_ORDERED, TOTAL_VALUE, " +
  "DISCOUNT, ITEM_TYPE) VALUES (@po_number, 1004, 11, 'new', " +
  "'1991-03-04 00:00:00', '1991-03-05 00:00:00', NULL, 'y', 10, 5000, " +
  "0.100000001490116, 'hardware');";

  FbCommand command = new FbCommand(sql, connection);
  command.Parameters.Add("@po_number", FbDbType.Char, 8);

  for (int i = 360; i < 365; i++)
  {

  command.Parameters[0].Value = "V91E0" + i.ToString();
  command.ExecuteNonQuery();

  }


  System.Threading.Thread.Sleep(2000);
  connection.Close();
  }

  static void EventCounts(object sender, FbRemoteEventEventArgs args)
  {
  Console.WriteLine("Event {0} has {1} counts.", args.Name, args.Counts);
  }


  My need: A sample writer in Visual Basic .Net (VB.NET). Sameone can put a answer for me? Tanks a lot. 

  Paulo Cezar Altafin .·.
  Cambé - Pr - Brasil

  ------------------------------------------------------------------------------
  Dive into the World of Parallel Programming The Go Parallel Website, sponsored
  by Intel and developed in partnership with Slashdot Media, is your hub for all
  things parallel software development, from weekly thought leadership blogs to
  news, videos, case studies, tutorials and more. Take a look and join the
  conversation now. http://goparallel.sourceforge.net/
  _______________________________________________
  Firebird-net-provider mailing list
  Fir...@li...
  https://lists.sourceforge.net/lists/listinfo/firebird-net-provider





-- 

------------------------------------------------------------------------
Gerdus van Zyl

www.infireal.com



--------------------------------------------------------------------------------
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/ 


--------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7] in http://www.firebirdsql.org/en/net-examples-of-use/

[Gerdus v. Z. <ger...@gm...>]

Just run the code through telerik code converter here:
http://converter.telerik.com/

On Wed, Mar 4, 2015 at 3:06 AM, <alt...@gm...> wrote:

>   Hi,
>
> The sample noted is writed in C# and work fine. I’m try in VS 2013 Desktop
> Express.
>
> To make it clear, I join it here...
> static void Main(string[] args)
> {
> FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
> cs.DataSource = "localhost";
> cs.Database = "employee.fdb";
> cs.UserID = "SYSDBA";
> cs.Password = "masterkey";
> cs.Charset = "NONE";
> cs.Pooling = false;
>
> FbConnection connection = new FbConnection(cs.ToString());
> connection.Open();
>
> FbRemoteEvent revent = new FbRemoteEvent(connection);
> revent.AddEvents(new string[] { "new_order" });
>
> // Add callback to the Firebird events
> revent.RemoteEventCounts += new FbRemoteEventEventHandler(EventCounts);
>
> // Queue events
> revent.QueueEvents();
>
> string sql = "INSERT INTO SALES (PO_NUMBER, CUST_NO, SALES_REP,
> ORDER_STATUS, " +
> "ORDER_DATE, SHIP_DATE, DATE_NEEDED, PAID, QTY_ORDERED, TOTAL_VALUE, " +
> "DISCOUNT, ITEM_TYPE) VALUES (@po_number, 1004, 11, 'new', " +
> "'1991-03-04 00:00:00', '1991-03-05 00:00:00', NULL, 'y', 10, 5000, " +
> "0.100000001490116, 'hardware');";
>
> FbCommand command = new FbCommand(sql, connection);
> command.Parameters.Add("@po_number", FbDbType.Char, 8);
>
> for (int i = 360; i < 365; i++)
> {
> command.Parameters[0].Value = "V91E0" + i.ToString();
> command.ExecuteNonQuery();
> }
>
> System.Threading.Thread.Sleep(2000);
> connection.Close();
> }
>
> static void EventCounts(object sender, FbRemoteEventEventArgs args)
> {
> Console.WriteLine("Event {0} has {1} counts.", args.Name, args.Counts);
> }
>
> My need: A sample writer in Visual Basic .Net (VB.NET). Sameone can put a
> answer for me? Tanks a lot.
>
> Paulo Cezar Altafin .·.
> Cambé - Pr - Brasil
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


-- 
------------------------------------------------------------------------
Gerdus van Zyl
www.infireal.com

[Firebird-net-provider] Sample 3. Firebird events [v1.7] in http://www.firebirdsql.org/en/net-examples-of-use/

[<alt...@gm...>]

Hi, 

The sample noted is writed in C# and work fine. I’m try in VS 2013 Desktop Express.

To make it clear, I join it here...
static void Main(string[] args)
{

FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.DataSource = "localhost";
cs.Database = "employee.fdb";
cs.UserID = "SYSDBA";
cs.Password = "masterkey";
cs.Charset = "NONE";
cs.Pooling = false;

FbConnection connection = new FbConnection(cs.ToString());
connection.Open();

FbRemoteEvent revent = new FbRemoteEvent(connection);
revent.AddEvents(new string[] { "new_order" });

// Add callback to the Firebird events
revent.RemoteEventCounts += new FbRemoteEventEventHandler(EventCounts);

// Queue events
revent.QueueEvents();

string sql = "INSERT INTO SALES (PO_NUMBER, CUST_NO, SALES_REP, ORDER_STATUS, " +

"ORDER_DATE, SHIP_DATE, DATE_NEEDED, PAID, QTY_ORDERED, TOTAL_VALUE, " +
"DISCOUNT, ITEM_TYPE) VALUES (@po_number, 1004, 11, 'new', " +
"'1991-03-04 00:00:00', '1991-03-05 00:00:00', NULL, 'y', 10, 5000, " +
"0.100000001490116, 'hardware');";

FbCommand command = new FbCommand(sql, connection);
command.Parameters.Add("@po_number", FbDbType.Char, 8);

for (int i = 360; i < 365; i++)
{

command.Parameters[0].Value = "V91E0" + i.ToString();
command.ExecuteNonQuery();

}


System.Threading.Thread.Sleep(2000);
connection.Close();
}

static void EventCounts(object sender, FbRemoteEventEventArgs args)
{
Console.WriteLine("Event {0} has {1} counts.", args.Name, args.Counts);
}


My need: A sample writer in Visual Basic .Net (VB.NET). Sameone can put a answer for me? Tanks a lot. 

Paulo Cezar Altafin .·.
Cambé - Pr - Brasil

[Firebird-net-provider] [FB-Tracker] Created: (DNET-594) In DDEX "|" is not recognized.

[Anton V. (JIRA) <tr...@fi...>]

In DDEX "|" is not recognized.
------------------------------

                 Key: DNET-594
                 URL: http://tracker.firebirdsql.org/browse/DNET-594
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
    Affects Versions: 4.6.1.0
         Environment: Windows 7
Firebird 2.5
VS 2013 ultimate

            Reporter: Anton Veretennikov
            Assignee: Jiri Cincura


I try to create TableAdapter with select comand for fill. 

SQL for Select comand:

SELECT        FIRM.FIRM_NAME, FIRM.FIRM_ADRESS, FIRM.PHONE, FIRM.FAX, FIRM.EMAIL, list(f.FORM_INCORPORATION | | ' ' | | lp.LEGAL_PERSON) 
                         AS LEGAL_PERSONS_LIST
FROM            FIRM LEFT OUTER JOIN
                         LEGAL_PERSON lp ON FIRM.ID_FIRM = lp.ID_FIRM INNER JOIN
                         FORM_INCORPORATION f ON lp.ID_FORM_INCORPORATION = f.ID_FORM_INCORPORATION
WHERE        (lower(trim(FIRM.FIRM_NAME)) LIKE '%' | | @name | | '%')
GROUP BY FIRM.FIRM_NAME, FIRM.FIRM_ADRESS, FIRM.PHONE, FIRM.FAX, FIRM.EMAIL

I get next error message. Query Builder throws exception.
It`s translated from russian text by me


"Error in functions arguments list: "|" is not recognized.
Unable to parse query text"

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

[SUKHEN D. <suk...@ya...>]

actually the problem is for the firebird database as some locking issues as all work is happening inside a transaction. as you had suggest it belong to .net provider but they said post it in firebird database group 

     On Monday, February 23, 2015 2:04 PM, SUKHEN DASS <suk...@ya...> wrote:
   

 Please, give some light

      On Monday, February 23, 2015 1:58 PM, "Helen Borrie he...@ii... [firebird-support]" <fir...@ya...> wrote:
   

     At 09:04 p.m. 23/02/2015, SUKHEN DASS suk...@ya... [firebird-support] wrote:

>please, somone guide me where i am wrong

This support list is for the Firebird database. For the .NET providers, you need to subscribe to the firebird-net-provider list:
List-Subscribe: <https://lists.sourceforge.net/lists/listinfo/firebird-net-provider>,
 <mailto:fir...@li...?subject=subscribe>

^ heLen ^ (Moderator)
----------------------------------------------------------

>On Monday, February 23, 2015 11:11 AM, "SUKHEN DASS suk...@ya... [firebird-support]" <fir...@ya...> wrote:
>
>
> 
>Hi,
>Greetings For The Day.
>
>I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. The insertion will take place if product id does not exist else record to be update.
>But inside the loop while executing ExecuteNonQuery control does not come back wait for 10 hours still not came and no error message and it happens on random rows not always for the same recrod
>I am struck past 7 days i am working googled but no solution Finally i decided to firebird support team
>
>My project is getting delayed please, help
>
>Thanks
>Sukhen Dass
>
>
>
>
>
>

  __._,_.___     Posted by: Helen Borrie <he...@ii...>     
|  Reply via web post  | • |   Reply to sender   | • |   Reply to group   | • |  Start a New Topic  | • |  Messages in this topic (3)  |

  ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++   Visit Your Group    
   -  New Members 5 
    • Privacy • Unsubscribe • Terms of Use 
     .  
 __,_._,___#yiv0792418345 -- #yiv0792418345ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0792418345 #yiv0792418345ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0792418345 #yiv0792418345ygrp-mkp #yiv0792418345hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0792418345 #yiv0792418345ygrp-mkp #yiv0792418345ads {margin-bottom:10px;}#yiv0792418345 #yiv0792418345ygrp-mkp .yiv0792418345ad {padding:0 0;}#yiv0792418345 #yiv0792418345ygrp-mkp .yiv0792418345ad p {margin:0;}#yiv0792418345 #yiv0792418345ygrp-mkp .yiv0792418345ad a {color:#0000ff;text-decoration:none;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ygrp-lc {font-family:Arial;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ygrp-lc #yiv0792418345hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ygrp-lc .yiv0792418345ad {margin-bottom:10px;padding:0 0;}#yiv0792418345 #yiv0792418345actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0792418345 #yiv0792418345activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0792418345 #yiv0792418345activity span {font-weight:700;}#yiv0792418345 #yiv0792418345activity span:first-child {text-transform:uppercase;}#yiv0792418345 #yiv0792418345activity span a {color:#5085b6;text-decoration:none;}#yiv0792418345 #yiv0792418345activity span span {color:#ff7900;}#yiv0792418345 #yiv0792418345activity span .yiv0792418345underline {text-decoration:underline;}#yiv0792418345 .yiv0792418345attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0792418345 .yiv0792418345attach div a {text-decoration:none;}#yiv0792418345 .yiv0792418345attach img {border:none;padding-right:5px;}#yiv0792418345 .yiv0792418345attach label {display:block;margin-bottom:5px;}#yiv0792418345 .yiv0792418345attach label a {text-decoration:none;}#yiv0792418345 blockquote {margin:0 0 0 4px;}#yiv0792418345 .yiv0792418345bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0792418345 .yiv0792418345bold a {text-decoration:none;}#yiv0792418345 dd.yiv0792418345last p a {font-family:Verdana;font-weight:700;}#yiv0792418345 dd.yiv0792418345last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0792418345 dd.yiv0792418345last p span.yiv0792418345yshortcuts {margin-right:0;}#yiv0792418345 div.yiv0792418345attach-table div div a {text-decoration:none;}#yiv0792418345 div.yiv0792418345attach-table {width:400px;}#yiv0792418345 div.yiv0792418345file-title a, #yiv0792418345 div.yiv0792418345file-title a:active, #yiv0792418345 div.yiv0792418345file-title a:hover, #yiv0792418345 div.yiv0792418345file-title a:visited {text-decoration:none;}#yiv0792418345 div.yiv0792418345photo-title a, #yiv0792418345 div.yiv0792418345photo-title a:active, #yiv0792418345 div.yiv0792418345photo-title a:hover, #yiv0792418345 div.yiv0792418345photo-title a:visited {text-decoration:none;}#yiv0792418345 div#yiv0792418345ygrp-mlmsg #yiv0792418345ygrp-msg p a span.yiv0792418345yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0792418345 .yiv0792418345green {color:#628c2a;}#yiv0792418345 .yiv0792418345MsoNormal {margin:0 0 0 0;}#yiv0792418345 o {font-size:0;}#yiv0792418345 #yiv0792418345photos div {float:left;width:72px;}#yiv0792418345 #yiv0792418345photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0792418345 #yiv0792418345photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0792418345  #yiv0792418345reco-category {font-size:77%;}#yiv0792418345 #yiv0792418345reco-desc {font-size:77%;}#yiv0792418345 .yiv0792418345replbq {margin:4px;}#yiv0792418345 #yiv0792418345ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0792418345 #yiv0792418345ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0792418345 #yiv0792418345ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0792418345 #yiv0792418345ygrp-mlmsg select, #yiv0792418345 input, #yiv0792418345 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0792418345 #yiv0792418345ygrp-mlmsg pre, #yiv0792418345 code {font:115% monospace;}#yiv0792418345 #yiv0792418345ygrp-mlmsg * {line-height:1.22em;}#yiv0792418345 #yiv0792418345ygrp-mlmsg #yiv0792418345logo {padding-bottom:10px;}#yiv0792418345 #yiv0792418345ygrp-msg p a {font-family:Verdana;}#yiv0792418345 #yiv0792418345ygrp-msg p#yiv0792418345attach-count span {color:#1E66AE;font-weight:700;}#yiv0792418345 #yiv0792418345ygrp-reco #yiv0792418345reco-head {color:#ff7900;font-weight:700;}#yiv0792418345 #yiv0792418345ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ov li a {font-size:130%;text-decoration:none;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ov ul {margin:0;padding:0 0 0 8px;}#yiv0792418345 #yiv0792418345ygrp-text {font-family:Georgia;}#yiv0792418345 #yiv0792418345ygrp-text p {margin:0 0 1em 0;}#yiv0792418345 #yiv0792418345ygrp-text tt {font-size:120%;}#yiv0792418345 #yiv0792418345ygrp-vital ul li:last-child {border-right:none !important;}#yiv0792418345 

    

   

[Firebird-net-provider] Fw: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

[SUKHEN D. <suk...@ya...>]

Please, give some light

      On Monday, February 23, 2015 1:58 PM, "Helen Borrie he...@ii... [firebird-support]" <fir...@ya...> wrote:
   

     At 09:04 p.m. 23/02/2015, SUKHEN DASS suk...@ya... [firebird-support] wrote:

>please, somone guide me where i am wrong

This support list is for the Firebird database. For the .NET providers, you need to subscribe to the firebird-net-provider list:
List-Subscribe: <https://lists.sourceforge.net/lists/listinfo/firebird-net-provider>,
 <mailto:fir...@li...?subject=subscribe>

^ heLen ^ (Moderator)
----------------------------------------------------------

>On Monday, February 23, 2015 11:11 AM, "SUKHEN DASS suk...@ya... [firebird-support]" <fir...@ya...> wrote:
>
>
> 
>Hi,
>Greetings For The Day.
>
>I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. The insertion will take place if product id does not exist else record to be update.
>But inside the loop while executing ExecuteNonQuery control does not come back wait for 10 hours still not came and no error message and it happens on random rows not always for the same recrod
>I am struck past 7 days i am working googled but no solution Finally i decided to firebird support team
>
>My project is getting delayed please, help
>
>Thanks
>Sukhen Dass
>
>
>
>
>
>

  __._,_.___     Posted by: Helen Borrie <he...@ii...>     
|  Reply via web post  | • |   Reply to sender   | • |   Reply to group   | • |  Start a New Topic  | • |  Messages in this topic (3)  |

  ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++   Visit Your Group    
   -  New Members 5 
    • Privacy • Unsubscribe • Terms of Use 
     .  
 __,_._,___#yiv2465211619 #yiv2465211619 -- #yiv2465211619ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2465211619 #yiv2465211619ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2465211619 #yiv2465211619ygrp-mkp #yiv2465211619hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2465211619 #yiv2465211619ygrp-mkp #yiv2465211619ads {margin-bottom:10px;}#yiv2465211619 #yiv2465211619ygrp-mkp .yiv2465211619ad {padding:0 0;}#yiv2465211619 #yiv2465211619ygrp-mkp .yiv2465211619ad p {margin:0;}#yiv2465211619 #yiv2465211619ygrp-mkp .yiv2465211619ad a {color:#0000ff;text-decoration:none;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ygrp-lc {font-family:Arial;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ygrp-lc #yiv2465211619hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ygrp-lc .yiv2465211619ad {margin-bottom:10px;padding:0 0;}#yiv2465211619 #yiv2465211619actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2465211619 #yiv2465211619activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2465211619 #yiv2465211619activity span {font-weight:700;}#yiv2465211619 #yiv2465211619activity span:first-child {text-transform:uppercase;}#yiv2465211619 #yiv2465211619activity span a {color:#5085b6;text-decoration:none;}#yiv2465211619 #yiv2465211619activity span span {color:#ff7900;}#yiv2465211619 #yiv2465211619activity span .yiv2465211619underline {text-decoration:underline;}#yiv2465211619 .yiv2465211619attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2465211619 .yiv2465211619attach div a {text-decoration:none;}#yiv2465211619 .yiv2465211619attach img {border:none;padding-right:5px;}#yiv2465211619 .yiv2465211619attach label {display:block;margin-bottom:5px;}#yiv2465211619 .yiv2465211619attach label a {text-decoration:none;}#yiv2465211619 blockquote {margin:0 0 0 4px;}#yiv2465211619 .yiv2465211619bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2465211619 .yiv2465211619bold a {text-decoration:none;}#yiv2465211619 dd.yiv2465211619last p a {font-family:Verdana;font-weight:700;}#yiv2465211619 dd.yiv2465211619last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2465211619 dd.yiv2465211619last p span.yiv2465211619yshortcuts {margin-right:0;}#yiv2465211619 div.yiv2465211619attach-table div div a {text-decoration:none;}#yiv2465211619 div.yiv2465211619attach-table {width:400px;}#yiv2465211619 div.yiv2465211619file-title a, #yiv2465211619 div.yiv2465211619file-title a:active, #yiv2465211619 div.yiv2465211619file-title a:hover, #yiv2465211619 div.yiv2465211619file-title a:visited {text-decoration:none;}#yiv2465211619 div.yiv2465211619photo-title a, #yiv2465211619 div.yiv2465211619photo-title a:active, #yiv2465211619 div.yiv2465211619photo-title a:hover, #yiv2465211619 div.yiv2465211619photo-title a:visited {text-decoration:none;}#yiv2465211619 div#yiv2465211619ygrp-mlmsg #yiv2465211619ygrp-msg p a span.yiv2465211619yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2465211619 .yiv2465211619green {color:#628c2a;}#yiv2465211619 .yiv2465211619MsoNormal {margin:0 0 0 0;}#yiv2465211619 o {font-size:0;}#yiv2465211619 #yiv2465211619photos div {float:left;width:72px;}#yiv2465211619 #yiv2465211619photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2465211619 #yiv2465211619photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2465211619 #yiv2465211619reco-category {font-size:77%;}#yiv2465211619 #yiv2465211619reco-desc {font-size:77%;}#yiv2465211619 .yiv2465211619replbq {margin:4px;}#yiv2465211619 #yiv2465211619ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2465211619 #yiv2465211619ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2465211619 #yiv2465211619ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2465211619 #yiv2465211619ygrp-mlmsg select, #yiv2465211619 input, #yiv2465211619 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2465211619 #yiv2465211619ygrp-mlmsg pre, #yiv2465211619 code {font:115% monospace;}#yiv2465211619 #yiv2465211619ygrp-mlmsg * {line-height:1.22em;}#yiv2465211619 #yiv2465211619ygrp-mlmsg #yiv2465211619logo {padding-bottom:10px;}#yiv2465211619 #yiv2465211619ygrp-msg p a {font-family:Verdana;}#yiv2465211619 #yiv2465211619ygrp-msg p#yiv2465211619attach-count span {color:#1E66AE;font-weight:700;}#yiv2465211619 #yiv2465211619ygrp-reco #yiv2465211619reco-head {color:#ff7900;font-weight:700;}#yiv2465211619 #yiv2465211619ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ov li a {font-size:130%;text-decoration:none;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ov ul {margin:0;padding:0 0 0 8px;}#yiv2465211619 #yiv2465211619ygrp-text {font-family:Georgia;}#yiv2465211619 #yiv2465211619ygrp-text p {margin:0 0 1em 0;}#yiv2465211619 #yiv2465211619ygrp-text tt {font-size:120%;}#yiv2465211619 #yiv2465211619ygrp-vital ul li:last-child {border-right:none !important;}#yiv2465211619 

   

[Firebird-net-provider] [FB-Tracker] Created: (DNET-593) lock conflict on no wait transaction deadlock update conflicts with concurrent update

[MIHIR K. (JIRA) <tr...@fi...>]

lock conflict on no wait transaction deadlock update conflicts with concurrent update 
--------------------------------------------------------------------------------------

                 Key: DNET-593
                 URL: http://tracker.firebirdsql.org/browse/DNET-593
             Project: .NET Data provider
          Issue Type: Bug
         Environment: Windows service 
            Reporter: MIHIR KADAM
            Assignee: Jiri Cincura


Widows service running which continues listing to firebird database events. I received following exception when service is running. 

2015-02-18 08:51:18,107 [9] ERROR WindowsService.FirebirdListener - FirebirdSql.Data.FirebirdClient.FbException (0x80004005): lock conflict on no wait transaction
deadlock
update conflicts with concurrent update ---> lock conflict on no wait transaction
deadlock
update conflicts with concurrent update

Server stack trace: 
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 514
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-592) unable to allocate memory from operating system GDSCODE: 335544430 SYMBOlL: virmemexh

[MIHIR K. (JIRA) <tr...@fi...>]

unable to allocate memory from operating system GDSCODE: 335544430 SYMBOlL: virmemexh
-------------------------------------------------------------------------------------

                 Key: DNET-592
                 URL: http://tracker.firebirdsql.org/browse/DNET-592
             Project: .NET Data provider
          Issue Type: Bug
          Components: ASP.NET Providers
    Affects Versions: 2.1.0
         Environment: Windows
            Reporter: MIHIR KADAM
            Assignee: Jiri Cincura



Widows service running which continues listing to firebird database events. I received following exception when service is running.After this exception service stop working. 
  
2015-02-19 13:49:59,364 [87] ERROR WindowsService.FirebirdListener - FirebirdSql.Data.FirebirdClient.FbException (0x80004005): unable to allocate memory from operating system ---> unable to allocate memory from operating system

Server stack trace: 
   at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbTransaction.cs:line 367
   at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1140
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1201
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 556
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] EF connectionstring with trusted authentication

[Parzival <par...@gm...>]

Hello all,

 

my mistake: I don´t have to send username nor password at all :-(

 

Niko

 

Von: Parzival [mailto:par...@gm...] 
Gesendet: Freitag, 20. Februar 2015 18:17
An: 'For users and developers of the Firebird .NET providers'
Betreff: [Firebird-net-provider] EF connectionstring with trusted
authentication

 

Hello all,

 

I am using firebird .net provider and EF to connect to the firebird DB. The
connection with the .net provider works fine with trusted authentication.
The Windows Username of the current user is sent without a password to the
database and it connects as expected.

 

 

When I try to do the same with EF I fail by removing the password.

 

   cU := System.Security.Principal.WindowsIdentity.GetCurrent()

   _currentUser := cU:Name

// this works

_efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" +
_server + ";initial catalog=" + _database + ";user id=" + _currentUser +
";role=BAURADAR_ADMIN;"  

 

// this does not work

_efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" +
_server + ";initial catalog=" + _database + ";user id=" + _currentUser +
";password=mypassword;role=BAURADAR_ADMIN;"  

 

I have removed the connectionstring section from the app.config in order to
read the essential parameters (server, database) from a config file. 

 

Is there any special setting I have to add that trusted authentication works
with EF as well as it does with the .net provider?

 

Thanks

 

Niko

[Firebird-net-provider] EF connectionstring with trusted authentication

[Parzival <par...@gm...>]

Hello all,

 

I am using firebird .net provider and EF to connect to the firebird DB. The
connection with the .net provider works fine with trusted authentication.
The Windows Username of the current user is sent without a password to the
database and it connects as expected.

 

 

When I try to do the same with EF I fail by removing the password.

 

   cU := System.Security.Principal.WindowsIdentity.GetCurrent()

   _currentUser := cU:Name

// this works

_efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" +
_server + ";initial catalog=" + _database + ";user id=" + _currentUser +
";role=BAURADAR_ADMIN;"  

 

// this does not work

_efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" +
_server + ";initial catalog=" + _database + ";user id=" + _currentUser +
";password=mypassword;role=BAURADAR_ADMIN;"  

 

I have removed the connectionstring section from the app.config in order to
read the essential parameters (server, database) from a config file. 

 

Is there any special setting I have to add that trusted authentication works
with EF as well as it does with the .net provider?

 

Thanks

 

Niko

Re: [Firebird-net-provider] Prepare/reprepare?

[Jiří Č. <ji...@ci...>]

> Do I need to call Prepare() again on each FbCommand after the commit and new transaction assignment?

You don't have to. As long as you keep it on same connection and same command.

> Btw, is there any way to check if a FbCommand is prepared or not?

Not directly.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] Prepare/reprepare?

[Kjell R. <kje...@da...>]

Hi,

I'm writing a loop where a few FbCommands will be executed several 
times, so of course I call Prepare() before the loop starts.

But I would also like to commit the transaction at regular intervals in 
the loop, and start a new transaction. I assign the new transaction to 
each FbCommand.

Do I need to call Prepare() again on each FbCommand after the commit and 
new transaction assignment?

Btw, is there any way to check if a FbCommand is prepared or not?

Regards,
Kjell
-- 

DataDIA logotyp

Kjell Rilbe
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

DataDIA AB
Ulvsundavägen 106
168 67 Bromma
www.datadia.se <http://www.datadia.se>
08-514 905 90

Företagskontakt.se <http://xn--fretagskontakt-vpb.se> - urval av företag 
och kontaktinformation
Personkontakt.se <http://personkontakt.se> - urval av hushållsadresser

[Firebird-net-provider] [FB-Tracker] Created: (DNET-591) Problem with FbConnect

[Serj D. (JIRA) <tr...@fi...>]

Problem with FbConnect
----------------------

                 Key: DNET-591
                 URL: http://tracker.firebirdsql.org/browse/DNET-591
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.1.0
         Environment: Windows 7/Windows 2008R2, C# 4.0 
            Reporter: Serj Dolzhenko
            Assignee: Jiri Cincura


In my code i have one FbConnection for listening events from DB, it opens at programm starts and normaly closes only with program, but if there is no events for some reason for long interval of time i made close connection and try to open it again. Then i'm testing this version of .Net data provider i found that open connection didn't throw any exception and open connection to remote DB then there is no link to lan and DB at all. Previous version that i test (4.1.0.0) throws here exception - unable to complete network request.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Decorators for FbConnectionString properties

[Hernan M. <her...@ob...>]

Thanks a lot!

> El 5/2/2015, a las 9:06, Jiří Činčura <ji...@ci...> escribió:
> 
> Thanks. Merged.
> 
> -- 
> Mgr. Jiří Činčura
> Independent IT Specialist
> 
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider