http://permalink.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://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8772 <pre>In my App.config I have, &lt;system.data&gt; &lt;DbProviderFactories&gt; &lt;remove invariant="FirebirdSql.Data.FirebirdClient" /&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; &lt;/DbProviderFactories&gt; &lt;/system.data&gt; &lt;connectionStrings&gt; &lt;clear /&gt; &lt;add name="Entities" providerName="FirebirdSql.Data.FirebirdClient" connectionString="User=SYSDBA;Password=masterkey;Database=C:\Pearlpos\Data\Store.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connectionlifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;" /&gt; &lt;/connectionStrings&gt; &lt;entityFramework&gt; &lt;defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework"&gt; &lt;parameters&gt; &lt;par</pre> Muthu Annamalai 2013-05-21T12:03:38 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8771 <pre>The provider factory is not registered in app.config (or machine.config). </pre> Jiri Cincura 2013-05-21T05:36:18 http://permalink.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; } cat</pre> Muthu Annamalai 2013-05-20T22:32:19 http://permalink.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 collectionN</pre> Pavel (JIRA 2013-05-16T11:11:01 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8768 <pre>------------------------------------------------------------------------------ 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> Marco Aurélio Castro 2013-05-09T12:19:15 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8767 <pre>On Thu, May 9, 2013 at 5:34 AM, Muthu Annamalai &lt;pearlamerica-PkbjNfxxIARBDgjK7y7TUQ&lt; at &gt;public.gmane.org&gt; wrote: Yes. This query is very likely to end up with OUTER APPLY in the generated statement and this is not supported by Firebird (yet). You have to rewrite the query. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ 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 </pre> Jiri Cincura 2013-05-09T04:37:12 http://permalink.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.S</pre> Muthu Annamalai 2013-05-09T03:34:13 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8765 <pre> Yes. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ 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 </pre> Jiri Cincura 2013-05-04T07:29:13 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8764 <pre>Hi, Yiannis. I think so. I use the 2.7.7 version only .NET 2.0 and I have no problems. It also works with WineHQ 1.4 and .NET 2.0 2013/5/3 Yiannis Bourkelis &lt;yiannis1234-Re5JQEeQqe8AvxtiuMwx3w&lt; at &gt;public.gmane.org&gt; ------------------------------------------------------------------------------ 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> Oliverio Girondo 2013-05-03T17:07:06 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8763 <pre>Thank you Jiri, v2.7.7 is the most recent version that requires only NET Framework 2.0? (file: NETProvider-2.7.7-NET20.7z) 2013/5/3 Jiri Cincura &lt;diskuze-i04QUkT9ABbR7s880joybQ&lt; at &gt;public.gmane.org&gt; ------------------------------------------------------------------------------ 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-03T14:17:29 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8762 <pre> No call stack available, but I solved it by exiting a bit more gracefully, implementing IDisposable in the object holding the connection and within it closing and disposing the connection. So I am fine for now. /Martin ------------------------------------------------------------------------------ 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 </pre> Martin Ågren 2013-05-03T08:30:33 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8761 <pre> Yes, it does. The .NET 2.0 only version was deprecated few months ago. Now the oldest supported version is .NET 3.5 SP1. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ 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 </pre> Jiri Cincura 2013-05-03T07:13:33 http://permalink.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://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8759 <pre> Place de pdb in the same directory of your .exe. Anyway, did you see the call stack as Jiri said? ------------------------------------------------------------------------------ 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 </pre> Hernan Martinez 2013-05-02T13:51:02 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8758 <pre>You have to mark the property as store generated. It's not Firebird related, you have to do it in EF no matter what DB you use. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ 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 </pre> Jiri Cincura 2013-05-01T07:33:28 http://permalink.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.GdsDataba</pre> Muthu Annamalai 2013-04-30T23:15:11 http://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8756 <pre> I have the pdb-file placed in [program files]\FirebirdClient\ directory which is the same directory where I reference the dll. I never paid attention to symbol loading at debugging so I cant really say if it is loaded or not (I think not). Tried to point it out in VS and load it explicitly and disable the "Just my code" debugger option but no difference. /M ------------------------------------------------------------------------------ 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 </pre> Martin Ågren 2013-04-30T12:17:37 http://permalink.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://permalink.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) </pre> Hayatuddeen Sadiq (JIRA 2013-04-29T06:14:20 http://permalink.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://permalink.gmane.org/gmane.comp.db.firebird.dotnetprovider/8752 <pre> Did you try to running it under a debugger with FirebirdSql.Data.FirebirdClient.pdb in the same directory of the DLL? It might help you trace the origin of the null reference. -H. ------------------------------------------------------------------------------ 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> HERNAN MARTINEZ FOFFANI 2013-04-25T08:37:04 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.firebird.dotnetprovider