http://blog.gmane.org/gmane.comp.db.firebird.dotnetprovider hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8770 <pre>I am using EF Code First in VS 2012 Ultimate with Firebird Dot Net Provider 3.0.2.0. I need to change the connection string run time as to connect to different machine as required. In order to do that, I store the connection string in settings and create the DBProviderFactory in code and pass the connection string to it. It is working fine in my dev machine. Here is the code that is use to create my connection, private static DbConnection CreateDbConnection(string providerName, string connectionString) { // Assume failure. DbConnection connection = null; // Create the DbProviderFactory and DbConnection. if (connectionString != null) { try { var factory = DbProviderFactories.GetFactory(providerName); connection = factory.CreateConnection(); if (connection != null) connection.ConnectionString = connectionString; } catch (Exception ex) { // Set the connection to null if it was not created. connection = null; MessageBox.Show(EmailException.FormatException(ex)); } } // Return the connection. return connection; } But in my customer machine (Firebird Dot Net Provider 3.0.2.0. installed) it throws "Unable to Find .Net Framework Data Provider". Here is the stack An Unhandled Exception has occured in PearlPOS ---------------------------------------------- System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed. at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) at System.Data.Entity.Internal.LazyInternalConnection.CreateConnectionFromProvi derName(String providerInvariantName) at System.Data.Entity.Internal.LazyInternalConnection.InitializeFromConnectionS tringSetting(ConnectionStringSettings appConfigConnection) at System.Data.Entity.Internal.LazyInternalConnection.TryInitializeFromAppConfi g(String name, AppConfig config) at System.Data.Entity.Internal.LazyInternalConnection.Initialize() at System.Data.Entity.Internal.LazyInternalConnection.get_Connection() at System.Data.Entity.Internal.LazyInternalContext.get_Connection() at Pearlpos.Data.Utils.Database.get_DataSource() at My.MyApplication.ConnectDatabase() at My.MyApplication.Application_Startup(Object sender, StartupEventArgs e) at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnStar tup(StartupEventArgs eventArgs) at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoAppl icationModel() at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(St ring[] commandLine) at My.MyApplication.Main(String[] Args) ---------------------------------------------- Thanks, Muthu Annamalai ------------------------------------------------------------------------------ AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d </pre> Muthu Annamalai 2013-05-20T22:32:19 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8769 <pre>NullReferenceException with Connection.GetSchema ------------------------------------------------- Key: DNET-501 URL: http://tracker.firebirdsql.org/browse/DNET-501 Project: .NET Data provider Issue Type: Bug Affects Versions: 2.5.2 Environment: .NET Compact Framework 3.5 SP2/ Firebird 2.5.1 Reporter: Pavel Assignee: Jiri Cincura Priority: Blocker I try to use GetSchema in FirebirdClient-NETCF-2.5.2: command.Connection.GetSchema("Generators"); - NullReferenceException Exception at FirebirdSql.Data.Schema.FbSchemaFactory.GetSchema(FbConnection connection, String collectionName, String[] restrictions) at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.GetSchema(String collectionName, String[] restrictions) at FirebirdSql.Data.FirebirdClient.FbConnection.GetSchema(String collectionName, String[] restrictions) at FirebirdSql.Data.FirebirdClient.FbConnection.GetSchema(String collectionName) // Also the same exception: DataTable parmsDataTable = connection.GetSchema("procedurearameters", new string[] { null, null, spName }); return parmsDataTable.Rows.Count; // Also the same exception: FbCommandBuilder.DeriveParameters(command); Tests runs on real device with WinCE 6.0 </pre> Pavel (JIRA 2013-05-16T11:11:01 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8766 <pre>I Use VS 2012 Ultimate, EF 5.0 Code First, Firebird Provider 3.0.2.0 When I use the following LINQ query public IQueryable&lt;SalesTotalCount&gt; ZDepartmentSalesPeriod { get { return (from r in ReceiptRepository.NoTracking() where r.RECEIPTDATE &gt;= ReportEndDate &amp; r.RECEIPTDATE &lt;= ReportEndDate from l in r.RECEIPTLINEs let department = l.ITEMSTYLE != null ? l.ITEMSTYLE.ITEM.CATEGORY.DEPARTMENT : l.RECEIPTITEMs.FirstOrDefault().DEPARTMENT group l by department into receiptLines select new SalesTotalCount { Name = receiptLines.Key.DEPARTMENTNAME, Total = (double)receiptLines.Sum(l =&gt; l.QUANTITY * l.PRICE - (l.RECEIPTDISCOUNTs.Any() ? l.RECEIPTDISCOUNTs.Sum(d =&gt; d.DISCOUNT) : 0)), Count = receiptLines.Count(), Listed = receiptLines.Key.LISTED }); } } Firebird is throwing this exception SQL error code = -104 Token unknown - line 35, column 4 OUTER ---&amp;amp;gt; Dynamic SQL Error SQL error code = -104 Token unknown - line 35, column 4 OUTER at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavio r behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(Entity Command entityCommand, CommandBehavior behavior)&lt;/ExceptionString&gt;&lt;InnerException&gt;&lt;ExceptionType&gt;FirebirdSql.Data.C ommon.IscException, FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c&lt;/ExceptionType&gt;&lt;Message&gt;Dynamic SQL Error ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/firebird-net-provider </pre> Muthu Annamalai 2013-05-09T03:34:13 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8760 <pre>Hello, I have a .NET 2.0 project and I want to use the firebird provider. Which one should I choose from the downloads page here: http://www.firebirdsql.org/en/net-provider/ ? I see a NETProvider-3.0.2.0-NET35.7z file but does this require NET 3.5 installed? ------------------------------------------------------------------------------ Get 100% visibility into Java/.NET code with AppDynamics Lite It's a free troubleshooting tool designed for production Get down to code-level detail for bottlenecks, with &lt;2% overhead. Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap2_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/firebird-net-provider </pre> Yiannis Bourkelis 2013-05-03T06:22:48 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8757 <pre>I am using Provider 3.0.2.0 with EF 5.0 code First. When I call save changes it is giving FirebirdSql.Data.Common.IscException: attempted update of read-only column. I have trigger for id column and I don't include values for those columns in code and there is no other computed column. I also tried saving a different table, but no use, when savechanges is called it is throwing the exception. Here is the exception stack details. ---------------------------------------------------------------------------- --------------------- (System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---&gt; System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---&gt; FirebirdSql.Data.FirebirdClient.FbException: attempted update of read-only column ---&gt; FirebirdSql.Data.Common.IscException: attempted update of read-only column at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IRespo nse response) at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() at FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) --- End of inner exception stack trace --- at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavio r behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTrans lator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateMana ger stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateMana ger stateManager, IEntityAdapter adapter) at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() --- End of inner exception stack trace --- at System.Data.Entity.Internal.InternalContext.SaveChanges() at System.Data.Entity.Internal.LazyInternalContext.SaveChanges() at System.Data.Entity.DbContext.SaveChanges() at Pearlpos.Data.Models.Entities.SaveChanges() in c:\Users\Muthu Annamalai\Documents\Visual Studio 2012\Projects\Pearlpos\Pearlpos.Data\Models\Entities.cs:line 85 at Pearlpos.Data.Repository`1.SaveChanges() in c:\Users\Muthu Annamalai\Documents\Visual Studio 2012\Projects\Pearlpos\Pearlpos.Data\Repository.cs:line 93 at Pearlpos.Data.Utils.DataInit.SetDefaultUser() in c:\Users\Muthu Annamalai\Documents\Visual Studio 2012\Projects\Pearlpos\Pearlpos.Data\Utils\DataInit.cs:line 295 at Pearlpos.Data.Utils.DataInit.DatabaseConnection() in c:\Users\Muthu Annamalai\Documents\Visual Studio 2012\Projects\Pearlpos\Pearlpos.Data\Utils\DataInit.cs:line 42} System.Exception {System.Data.Entity.Infrastructure.DbUpdateException} ---------------------------------------------------------------------------- --------------------- Thanks, Muthu Annamalai ------------------------------------------------------------------------------ Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET Get 100% visibility into your production application - at no cost. Code-level diagnostics for performance bottlenecks with &lt;2% overhead Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap1_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/firebird-net-provider </pre> Muthu Annamalai 2013-04-30T23:15:11 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8755 <pre>GetExecutionPlan() minor bug ---------------------------- Key: DNET-500 URL: http://tracker.firebirdsql.org/browse/DNET-500 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 3.0.2.0 Environment: VS 2010 Windows 7 Firebird 2.5 Reporter: Toni Martir Assignee: Jiri Cincura Priority: Minor GetExecutionPlan functions throws exeptions when the query has no plan (ALTER TABLE...) File StatetementBase.cs Function, GetExecutionPlan Line: int len = buffer[1]; throws execption because buffer length is 1 Just before this line the fix may be: if (buffer[0] == IscCodes.isc_info_end) return ""; I tested this bugfix and works ok. </pre> Toni Martir (JIRA 2013-04-30T10:59:19 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8754 <pre>Backup problem in Windows 7 --------------------------- Key: DNET-499 URL: http://tracker.firebirdsql.org/browse/DNET-499 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 2.5.1 Environment: Windows 7 Reporter: Hayatuddeen Sadiq Assignee: Jiri Cincura Hello, I have a desktop application that the backup is working fine but when i move it to window 7 the backup is not working. This is the code: Private Sub BackupDatabase(ByVal backupFile As String) 'Dim cs As New FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder 'cs.UserID = "sysdba" 'cs.Password = "masterkey" 'cs.Database = "localhost:ndahrm" Dim bkp As New FirebirdSql.Data.Services.FbBackup bkp.ConnectionString = DB.ConnectionString Dim bp As New FirebirdSql.Data.Services.FbBackupFile(backupFile, 2048) bkp.BackupFiles.Add(bp) bkp.Verbose = True bkp.Options = FirebirdSql.Data.Services.FbBackupFlags.IgnoreLimbo Try bkp.Execute() Timer1.Stop() prgBar.Value = 100 MessageBox.Show("Processing Completed Successfully.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information) Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub And this is the error code: Invalid clumplet buffer structure: buffer end before end of clumplet - no length component </pre> Hayatuddeen Sadiq (JIRA 2013-04-29T06:14:20 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8753 <pre>Hello! I try connect do Firebird database from Windows CE 5.2. I install Microsoft Compact Framework 3.5 on PDA, and NETProvider-2.5.2-CF. String cs2 = "character set=UTF8;data source=192.168.91.101;initial catalog=D:\\D\\P.FDB;user id=SYSDBA;password=xxx"; FbConnection fbc = new FbConnection(); fbc.ConnectionString = cs2; fbc.Open(); Open command get error: {"MissingMethodException"}. Any idea? w DeviceApplication3.Form1.button2_Click() w System.Windows.Forms.Control.OnClick() w System.Windows.Forms.Button.OnClick() w System.Windows.Forms.ButtonBase.WnProc() w System.Windows.Forms.Control._InternalWnProc() w Microsoft.AGL.Forms.EVL.EnterMainLoop() w System.Windows.Forms.Application.Run() w DeviceApplication3.Program.Main() </pre> Arkadiusz Widera 2013-04-27T16:39:57 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8746 <pre>Hi, I have a wpf application, and when exiting I always get a debug output: A first chance exception of type 'System.NullReferenceException' occurred in FirebirdSql.Data.FirebirdClient.dll Firebird 2.5, Firebird Client 3.0.2.0, Runtime v4.0.30319 I havn't been able to track down a cause for this. Any clues? /Martin ------------------------------------------------------------------------------ Try New Relic Now &amp; We'll Send You this Cool Shirt New Relic is the only SaaS-based application performance monitoring service that delivers powerful full stack analytics. Optimize and monitor your browser, app, &amp; servers with just a few lines of code. Try New Relic and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/firebird-net-provider </pre> Martin Ågren 2013-04-25T07:46:29 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8741 <pre>Hi *, is there an interest in Migrations provider (for EF) for Firebird? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis &amp; visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter </pre> Jiri Cincura 2013-04-20T06:18:38 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8739 <pre>Error in double quoting database object names (tables, columns) --------------------------------------------------------------- Key: DNET-498 URL: http://tracker.firebirdsql.org/browse/DNET-498 Project: .NET Data provider Issue Type: Bug Components: DDEX Provider Affects Versions: 3.0.0.0 Environment: 1. Windows 7 SP1 x86, Visual Studio 2012, Firebird 2.5.2 x86, DDEX Provider 3.0.0.0, .NET Provider 3.0.2.0 2. Windows 7 SP1 x64, Visual Studio 2012 Update 2, Firebird 2.5.2 x64, DDEX Provider 3.0.0.0, .NET Provider 3.0.2.0 Reporter: Phosgen Tepes Assignee: Jiri Cincura Priority: Critical I create strongly typed data set, drag table which have double quoted name and columns, in this stage everything is ok, but if i delete or cut any column in data table via designer (real column from database or added via designer) in select command in designer double quoting are dissapearing, and nothing not work because need double quoting. please fix this bug. thank you! </pre> Phosgen Tepes (JIRA 2013-04-18T20:41:20 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8735 <pre>Hello all, I'm trying to update an application that uses Factories from version 2.1 to 3.0.2 of the provider. I've registered the dll in the gac by using gacutil.exe from VS2010 command line. This is the output of /l option: FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL I've added the next lines to machine.config from v2 and v4 of the config directory: 2: &lt;section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt; &lt;add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" /&gt; 4: &lt;section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt; &lt;add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/&gt; But my app crashes every time I'm trying to execute it. Could you please help me to fix this issue?? What is wrong? Thanks in advance. Regards, ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis &amp; visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter </pre> Alex Castillo 2013-04-18T03:58:59 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8734 <pre>.Net provider Generates "Outer aplly statement" ----------------------------------------------- Key: DNET-497 URL: http://tracker.firebirdsql.org/browse/DNET-497 Project: .NET Data provider Issue Type: Bug Components: Entity Framework support Affects Versions: 3.0.2.0 Environment: Win 7x64, Reporter: Wojciech Kmiecik Assignee: Jiri Cincura hi. We are using Database First Approach, after linq query AIds = (from x in context.RISK_T_ASSESS_HIST where (x.ID_RISKOBJECT.HasValue &amp;&amp; x.F_CREATEDON &gt;= Freq.StartDate &amp;&amp; x.F_CREATEDON &lt;= Freq.EndDate) group x by x.ID_RISKOBJECT into gr let lastCreated = gr.Max(p =&gt; p.F_CREATEDON) select new { ObjId = gr.Key , LastStatus = gr.Where(p =&gt; p.F_CREATEDON == lastCreated &amp;&amp; p.ID_RISKOBJECT == gr.Key).Select(p =&gt; p.F_STATUS).FirstOrDefault() }).Where(x =&gt; x.LastStatus == 0 || x.LastStatus == 1).Select(x =&gt; x.ObjId.Value).ToArray(); FB receives query with Outer Apply Query generowane przez EF SELECT "Project1"."ID_RISKOBJECT" AS "ID_RISKOBJECT" FROM (SELECT "GroupBy1"."A1" AS "C1", "GroupBy1"."K1" AS "ID_RISKOBJECT" FROM ( SELECT "Extent1"."ID_RISKOBJECT" AS "K1", MAX("Extent1"."F_CREATEDON") AS "A1" FROM "RISK_T_ASSESS_HIST" AS "Extent1" WHERE (("Extent1"."ID_RISKOBJECT" IS NOT NULL) AND ("Extent1"."F_CREATEDON" &gt;= 2013-04-17)) AND ("Extent1"."F_CREATEDON" &lt;= 2013-04-17) GROUP BY "Extent1"."ID_RISKOBJECT" ) AS "GroupBy1" ) AS "Project1" OUTER APPLY (SELECT FIRST (1) "Extent2"."F_STATUS" AS "F_STATUS" FROM "RISK_T_ASSESS_HIST" AS "Extent2" WHERE (((("Extent2"."ID_RISKOBJECT" IS NOT NULL) AND ("Extent2"."F_CREATEDON" &gt;= 2013-04-17)) AND ("Extent2"."F_CREATEDON" &lt;= &lt; at &gt;2013-04-17)) AND (("Project1"."ID_RISKOBJECT" = "Extent2"."ID_RISKOBJECT") OR (("Project1"."ID_RISKOBJECT" IS NULL) AND ("Extent2"."ID_RISKOBJECT" IS NULL)))) AND (("Extent2"."F_CREATEDON" = "Project1"."C1") AND ("Extent2"."ID_RISKOBJECT" = "Project1"."ID_RISKOBJECT")) ) AS "Limit1" WHERE (0 = "Limit1"."F_STATUS") OR (1 = "Limit1"."F_STATUS") </pre> Wojciech Kmiecik (JIRA 2013-04-17T16:41:13 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8733 <pre> Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5? ---------------------------------------------------------------- Key: DNET-496 URL: http://tracker.firebirdsql.org/browse/DNET-496 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 1.7.2 Environment: Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5? Reporter: Sergey Prochoghev Assignee: Jiri Cincura Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5? </pre> Sergey Prochoghev (JIRA 2013-04-17T12:41:02 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8729 <pre>Hi *, I just found behavior that surprised me. Suppose pooling is on and (all connections to same database): Open connection1. Open connection2. Close connection2. FbConnection.ClearAllPools(); Try to use connection1. On this ^ line you'll get exception as the connection1 was also cleared aka closed/disposed. I always used ClearAllPools with all connections closed so I had no idea it behaves like that. But do you think is correct? Should the ClearAllPools clear even the opened connections? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis &amp; visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter </pre> Jiri Cincura 2013-04-17T08:29:57 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8728 <pre>Please, I need Data creation of football bet -------------------------------------------- Key: DNET-495 URL: http://tracker.firebirdsql.org/browse/DNET-495 Project: .NET Data provider Issue Type: New Feature Components: ASP.NET Providers Affects Versions: 2.1.0 Environment: Port Harcourt Reporter: Joseph Ogbuke Assignee: Jiri Cincura software platform </pre> Joseph Ogbuke (JIRA 2013-04-16T09:51:02 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8727 <pre>GCC --- Key: DNET-494 URL: http://tracker.firebirdsql.org/browse/DNET-494 Project: .NET Data provider Issue Type: Bug Components: Borland Data Provider Affects Versions: 2.1.0 Environment: lagos Reporter: Joseph Ogbuke Assignee: Jiri Cincura software platform </pre> Joseph Ogbuke (JIRA 2013-04-16T08:10:02 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8726 <pre>Multiple websites in IIS with native dll use 100% or core CPU ------------------------------------------------------------- Key: DNET-493 URL: http://tracker.firebirdsql.org/browse/DNET-493 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 2.5.0 Environment: Windows 7, IIS7 Reporter: Icemedia Assignee: Jiri Cincura http://stackoverflow.com/questions/16029488/multiple-websites-in-iis-with-native-dll-use-100-or-core-cpu I have an application which makes uses of firebird embedded. There are five instances of this application in IIS all in the same Application Pool. Whenever one of the sites in the pool is stopped or recycled the other four websites will then have a thread each that uses 100% of the CPU for the core it's running on (I can't tell if it's a new thread of an existing one that jumps to 100%) . So there are four threads using 100% CPU of four cores. I've been using Process Explorer to try and find out more. The threads all have a call stack that looks mostly like this: ntoskrnl.exe!KiCpuId+0xb6 ntoskrnl.exe!KeWaitForMutexObject+0x13c0 ntoskrnl.exe!KeUpdateRunTime+0x51 ntdll.dll!NtWaitForSingleObject+0xa KERNELBASE.dll!WaitForSingleObjectEx+0x9a fbembed.dll!BLOB_edit+0x3430c fbembed.dll!BLOB_edit+0x1faa6c fbembed.dll!BLOB_edit+0x1fb5f9 fbembed.dll!isc_dsql_execute_immediate+0x1c1 MSVCR80.dll!endthreadex+0x47 MSVCR80.dll!endthreadex+0x104 KERNEL32.DLL!BaseThreadInitThunk+0x1a ntdll.dll!RtlUserThreadStart+0x21 This is running in IIS7 and IIS8 with .NET framework version is 2.0 I think firebird is trying to acquire some kind of lock? </pre> Icemedia (JIRA 2013-04-16T07:08:04 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8725 <pre>Greetings to everybody, It seems I cannot get the Firebird DDEX provider to be installed correctly. I've used the manual method (before a working setup came out) and the new setup that has been made for the different VS versions. Whatever method I use, it seems that the provider cannot stay registered in Visual Studio continuously. After a few sessions, the provider isn't displayed anymore. Server-explorer connections with this provider are still there, but throw an error on opening. * Datatools in the gac -&gt; it's there * Provider in the gac -&gt; it's there * machineconfig 32-bit and 64-bit for .NET v4.0.30319 contains both an entry * Registry files are still there Every time, I try manual install steps and/or the setup to get the provider back and start VS2010/VS2012 with the /resetpckgs option (I need it since I'm working with EF 5) and it seems to restore the registration to visual studio. To be frank, I am still unable to recognize the exact step that solves the problem (temporarily)and every time I just try to reset everything back to zero (what it would look like if firebird DDEX-provider wasn't installed). For this problem to appear, it could as well take up to 30 windows restarts or just even one. I also noticed that this never happens "in-between". The provider only goes missing after a restart of windows, but not vs2012 or vs2010. Does anyone have similar problems? p.s: I am sorry if the format of this mail doesn't match the conventions for posting to this mailing list. I didn't use any mailing list until now. Alexandre De Riemaecker ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis &amp; visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/firebird-net-provider </pre> De Riemaecker Alexandre 2013-04-12T12:58:30 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8724 <pre>An event is not registered (QueueEvents) ----------------------------------------- Key: DNET-492 URL: http://tracker.firebirdsql.org/browse/DNET-492 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 1.7.2 Reporter: Sergey Prochoghev Assignee: Jiri Cincura Priority: Critical It's works like a charm for the Firebird 2.0 but doesn't for the Firebird 2.5 Here is the example code: ... EvLOGP200:= FirebirdSql.Data.Firebird.FbRemoteEvent.Create(FbConnectionFDB , ['INS_FDB001_TAB001']); Include(EvLOGP200.RemoteEventCounts, FbConnectionFDB001_InfoMessage) ; EvLOGP200.QueueEvents; Here is an error message: encountered unhandled exception class FirebirdSql.Data.common.IscException Here is the debug: -&gt; interruption ... "Unable to complete network request to host "0.0.0.0"." </pre> Sergey Prochoghev (JIRA 2013-04-10T10:15:10 http://comments.gmane.org/gmane.comp.db.firebird.dotnetprovider/8723 <pre> interruption for QueueEvents ------------------------------ Key: DNET-491 URL: http://tracker.firebirdsql.org/browse/DNET-491 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 1.7.2 Environment: Не регистрируется событие (QueueEvents) Reporter: Sergey Prochoghev Assignee: Jiri Cincura Priority: Critical Для Firebird 2.0 - всё работает - OK. Для Firebird 2.5 не работает : ... EvLOGP200:= FirebirdSql.Data.Firebird.FbRemoteEvent.Create(FbConnectionFDB , ['INS_FDB001_TAB001']); Include(EvLOGP200.RemoteEventCounts, FbConnectionFDB001_InfoMessage) ; EvLOGP200.QueueEvents; -&gt; interruption ... "Unable to complete network request to host "0.0.0.0"." </pre> Sergey Prochoghev (JIRA 2013-04-10T09:36:11 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.firebird.dotnetprovider