Victor Bautista | 28 Mar 07:13 2015
Picon

Connect to Firebird database throws type initializer exception

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
------------------------------------------------------------------------------
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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Anton Veretennikov (JIRA | 26 Mar 15:31 2015

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

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

------------------------------------------------------------------------------
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/
Thomas Kragh (JIRA | 6 Mar 15:43 2015

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

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

------------------------------------------------------------------------------
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/
altafinpc | 4 Mar 02:06 2015
Picon

http://www.firebirdsql.org/en/net-examples-of-use/

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 ( <at> 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(" <at> 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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Anton Veretennikov (JIRA | 27 Feb 13:52 2015

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

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 '%' | |  <at> 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

------------------------------------------------------------------------------
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/
MIHIR KADAM (JIRA | 21 Feb 16:08 2015

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

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

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
MIHIR KADAM (JIRA | 21 Feb 16:02 2015

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

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

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
Parzival | 20 Feb 18:16 2015
Picon
Picon

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

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Kjell Rilbe | 11 Feb 13:56 2015
Picon

Prepare/reprepare?

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

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

DataDIA AB
Ulvsundavägen 106
168 67 Bromma
www.datadia.se
08-514 905 90


Företagskontakt.se - urval av företag och kontaktinformation
Personkontakt.se - urval av hushållsadresser

------------------------------------------------------------------------------
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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Serj Dolzhenko (JIRA | 9 Feb 11:07 2015

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

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

------------------------------------------------------------------------------
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/
Jiri Cincura (JIRA | 5 Feb 09:06 2015

[FB-Tracker] Created: (DNET-590) Use constants for defaults for FbConnectionString and FbConnectionStringBuilder

Use constants for defaults for FbConnectionString and FbConnectionStringBuilder
-------------------------------------------------------------------------------

                 Key: DNET-590
                 URL: http://tracker.firebirdsql.org/browse/DNET-590
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Trivial

--

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

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

Gmane