[Firebird-net-provider] [FB-Tracker] Created: (DNET-969) GFix force sweep

GFix force sweep Key: DNET-969 URL: http://tracker.firebirdsql.org/browse/DNET-969 Project: .NET Data provider Issue Type: New Feature Reporter: Alexander Muylaert Assignee: Jiri Cincura Do a sweep

Re: [Firebird-net-provider] .NET 4 support

Hi Gerdus The question is... should "we" be affected by "your" difficulties upgrading 500 pcs. I have the same problem, it is even thousands and all running on different locations, but we try to manage. (Failing miserably, but that is another story) I agree with your opinion that you can st

Re: [Firebird-net-provider] Firing event when event count is 0

I say ney. It doesn’t make sense to raise unraised events. Sent from Mail for Windows 10 From: Jiří Činčura Sent: vrijdag 16 december 2016 17:15 To: For users & developers of the Firebird .NET providers

Re: [Firebird-net-provider] Stored procedures etc. in .NET

Hi Jiri There is interest on our behalf. But we will only switch to FB 3... after release 2 or something like that.That doesn't mean we are not interested in kicking this into motion. Thanks Alexander > From: j...@cincura.net > To: firebird-net-provider@lists.sourceforge.net > Date: Mon, 27 Ju

[Firebird-net-provider] [FB-Tracker] Created: (DNET-669) rare null reference exception in OnRemoteEventCounts

: 4.10.0.0 Reporter: Alexander Muylaert-Gelein Assignee: Jiri Cincura Hi Jiri@Jira On rare occasions we found a null reference exception log inside our exception system. During the FbRemoveEnvet.OnRemoveEventCounts it fails somewhere. I've checked the code and the

[Firebird-net-provider] [FB-Tracker] Created: (DNET-657) Lots of exceptions by transaction destructor

Affects Versions: 4.9.0.0 Reporter: Alexander Muylaert-Gelein Assignee: Jiri Cincura Priority: Critical FbTransaction doesn't dispose the internal GDSTransaction anymore. If you look at FbTransaction.Commit, you'll notice it calls UpdateTransacti

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

I had likewise errors on multiple computers in the past weeks. They all had failed windows updates in common. Completely updating windows solved it for me on multiple occasions. Sent from my Windows Phone From: Jiří Činčura Sent: ‎2/‎12/‎

Re: [Firebird-net-provider] Parser class/library

I know we are sponsoring This... But it sounds to me like so much work and so little gain. Sure, the current parse thing is slow and buggy, but only a few minor bugs and performance gain Will be limited as well. I think looking at 3th party parsers isn,'t a bad idea at All. Sent from my Windows

Re: [Firebird-net-provider] Migrations

Hi all Jiri asked me to kick in because we have two products. One with one generator per column, one with one generator per database. Pro's of generator per table are You have the feeling of a sequence. There shouldn't be a gap, you can do "math" on it.This is how other db's have it since DBase

Re: [Firebird-net-provider] Compiling error

Yes... If you switch to Visual Studio 2015... it is solved.Looks to me that Jiri is already on the next level. From: nftimm...@hotmail.com To: firebird-net-provider@lists.sourceforge.net Date: Wed, 23 Sep 2015 10:53:57 -0300 Subject: [Firebird-net-provider] Compiling error Hello When i download

Re: [Firebird-net-provider] Multithread insert

I don't think there is even an issue here. inside two different transactions, you simply cannot update the same record. Who would win in the end and what would be the end result. I'm pretty sure if you can solve this, the firebird team would gladly implement this. a > Date: Sun, 20 Sep 2015

[Firebird-net-provider] [FB-Tracker] Created: (DNET-622) Performance optimization for FbCommand.LogCommand

: ADO.NET Provider Affects Versions: 4.7.0.0 Reporter: Alexander Muylaert-Gelein Assignee: Jiri Cincura Hi I noticed that the emitting of the trace code is relatively slow. It takes a few percentages (6%) of the total duration of a restore script. Including

Re: [Firebird-net-provider] ADO.NET provider 4.7.0.0 and DDEX 3.0.2

Hi Jiri Thanks, I'll make sure it is tested this weekend on our servers.Already available on nuget, because update-package doesn't work yet? thanks a > From: j...@cincura.net > To: firebird-net-provider@lists.sourceforge.net; > firebird-de...@lists.sourceforge.net; firebird-to...@yahoogroups.com

Re: [Firebird-net-provider] OutOfMemoryException

You might already have expected this. I don't think Jiri is aware of any leaks inside the provider, otherwise they would have been resolved. Can you make a reproducible scenario? thanks a > From: lo...@nucleo.co.za > To: firebird-net-provider@lists.sourceforge.net > Date: Thu, 18 Jun 2015 16:34:

Re: [Firebird-net-provider] Keep-alive packets

Yes, I was planning to reply on facebook as well. I was a bit surprised, but this could be the reason why 1. It is random2. It is on some networks often, on others rarely or never3. It is for no reason. In all honesty, I always try to keep a socket live with actual CHANGING bytes every 30 se

Re: [Firebird-net-provider] Random crashes in Finalizers

the Fes* namespace > doesn't work well in finalizers as we see. > > On Wed, Apr 8, 2015 at 6:12 PM, Alexander Muylaert-Gelein > wrote: > > Hi > > > > I intensively use firebird and provider... I always use the dispose method > > (using) and I don't depend

Re: [Firebird-net-provider] Random crashes in Finalizers

Hi I intensively use firebird and provider... I always use the dispose method (using) and I don't depend on the GC for this. I never had any of the exceptions refererred to. Wouldn't it be better *not* to depend on something horrible as the gc for something as important as your db connectivit

Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB

r. I think I need to try to optimize the read logic, then move on to the Write Logic. I read somewhere that Looping in .NET is somewhat slower than in Delphi, but there are things you can do optimize the .NET loops. Thank you, Edward Mendez From: Alexander Muylaert-Gelein [mailto:amuylaert_ge

Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB

I personally really like the one from red-gate but the visual studio profiler is also good. a > From: emendez...@nc.rr.com > To: firebird-net-provider@lists.sourceforge.net > Date: Fri, 8 Aug 2014 09:51:52 -0400 > Subject: Re: [Firebird-net-provider] Questions with performance metrics > doi

Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB

Hi Edward I'm also coming from a delphi background (using FIB) and we have ported/are already porting for 5 years our applications to .net. I have noticed indeed that Delphi/fib is faster then .net provider. But never in the magnitude of 500%. It looked acceptable slower. Your "write" code se

Re: [Firebird-net-provider] Character Set Confusion For Spanish Characters

Hi UTF8 Both your database and your connectionstrings (Everywhere…) Van: Steve Harp [mailto:st...@abelscreening.com] Verzonden: dinsdag 13 november 2012 21:20 Aan: firebird-net-provider@lists.sourceforge.net Onderwerp: [Firebird-net-provider] Character Set Confusion For Spanish Cha

Re: [Firebird-net-provider] Empty string for "Role" invalid in 3.x

Why not use the FBConnectionStringBuilder? That is what I always do and indeed, I don't set the role explicitly to empty. So this might indeed be your problem. -Oorspronkelijk bericht- Van: André Knappstein [mailto:knappst...@beta-eigenheim.de] Verzonden: maandag 5 november 2012 14:48

Re: [Firebird-net-provider] Empty string for "Role" invalid in 3.x

Hi I migrated from 2.6 and 2.7 to 3.0 without changing any code. I also never fill in the role. It must be something else. -Oorspronkelijk bericht- Van: Jiri Cincura [mailto:disk...@cincura.net] Verzonden: maandag 5 november 2012 12:32 Aan: For users and developers of the Firebird .NET

Re: [Firebird-net-provider] Changing transaction isolation levels [huge break]

Default should be the current read_uncommitted. I really spend a lot of time on asking people to check their connectionstrings. -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: maandag 24 september 2012 17:33 To: For users and developers of the Firebird .NET pro

[Firebird-net-provider] [FB-Tracker] Created: (DNET-430) Make Events connection independent

Reporter: Alexander Muylaert-Gelein Assignee: Jiri Cincura Priority: Minor Would it be possible to make the events connection independent. Now your connection needs to remain open for the events. It would be nice if this would be needed. Snip from mail from Jiri AFAIK

Re: [Firebird-net-provider] CheckMaxPoolSize error

Hi Erick You are not closing your connections, that is your fault. Check all the "new fbconnection()" statements and verify if they are inside a using statement. Unless you have a million users, you'll hardly ever hit the "100 truly concurrent" users if you have normal website. Some connections

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-409) Inserting large BLOB field (>500 MB) - System.OutOfMemoryException

No offence, but sounds like a bad plan anyway... -Original Message- From: Zsák Szabolcs (JIRA) [mailto:trac...@firebirdsql.org] Sent: vrijdag 17 februari 2012 15:59 To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-409) Insertin

Re: [Firebird-net-provider] UTF8 issue and Firebird Dot Net Data Provider

I don’t have this problem. Is your connectionstring correct? Use FbConnectionstringBuilder and make sure you set it to utf8? Good luck Alexander Van: Brad Swearingen [mailto:swear...@yadasystems.com] Verzonden: woensdag 18 januari 2012 14:52 Aan: firebird-net-provider@lists.sourceforge.

Re: [Firebird-net-provider] Executing Firebird stored procedure from ASP.NET

http://www.amazon.com/ADO-Programming-Dummies-CD-ROM-Krumm/dp/0764507478 -Oorspronkelijk bericht- Van: Net Developer [mailto:netfireb...@gmail.com] Verzonden: zondag 30 oktober 2011 23:41 Aan: firebird-net-provider@lists.sourceforge.net Onderwerp: [Firebird-net-provider] Executing Firebir

[Firebird-net-provider] Console app for failing events

Hi Jiri As expected, I cannot easiliy simulate the failing events ;-) I'm now switching my apps to the latest version and if it is still there I'll investigate harder. Thanks Alexander -- All of the data generated in

Re: [Firebird-net-provider] DNet - 234

ceived in thread 52 Event received RGN Event received Operation received in thread 52 Operation received in thread 0 Operation received in thread 0 Operation received in thread 0 Operation received in thread 50 threadStarted Create Transaction Commit transaction force close -Original Messag

[Firebird-net-provider] DNet - 234

Hi Jiri We were having some issues with the events system again. In combination with stored procedures. After executing a stored proc, some of the events on the network don't get triggered anymore. http://webcache.googleusercontent.com/search?q=cache:60r72F44y-sJ:tracker.fi rebirdsql.org/brows

[Firebird-net-provider] [FB-Tracker] Created: (DNET-335) The nullable flag of a stored procedure parameter seems to be wrong

: Bug Components: ADO.NET Provider Affects Versions: 2.5.2 Reporter: Alexander Muylaert Assignee: Jiri Cincura Hi Jiri I was having an argument with the guys from llblgenpro. They said that there is no way to know if a stored procedure parameter is nullable

Re: [Firebird-net-provider] Firebird 2.5, firebirdclient 2.5.2 issues with llblgenpro 3

Jiri Cincura [mailto:disk...@cincura.net] Sent: zaterdag 17 juli 2010 15:05 To: For users and developers of the Firebird .NET providers Cc: supp...@llblgen.com Subject: Re: [Firebird-net-provider] Firebird 2.5, firebirdclient 2.5.2 issues with llblgenpro 3 On Wed, Jul 14, 2010 at 16:37, Alexander Muy

Re: [Firebird-net-provider] Firebird 2.5, firebirdclient 2.5.2 issues with llblgenpro 3

Hi Jiri Aha, getting closer to the bug. Could you please have a look at http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=18291&StartAtMessage =0𘿮. We are having some issues with the metadata returned from the database through your provider. Thanks in advance. Alexander -

Re: [Firebird-net-provider] Firebird 2.5, firebirdclient 2.5.2 issues with llblgenpro 3

Hi Jiri The results of GetSchema("ProcedureParameters", new[] { null, null, "SYS_CHECK_COUNTRY" }) seems to be 100% correct. All data should be in there, I don't think *you* need to worry now. I'll come back to this. (or not... and then you don't have to do anything ;-)) Thanks Alexander ---

[Firebird-net-provider] Firebird 2.5, firebirdclient 2.5.2 issues with llblgenpro 3

Hi Jiri I'm having some issues on getting llblgenpro mapping to work in combination with firebird 2.5. The guys from llblgenpro blame you ;-) I'm pretty sure your driver works, can you confirm or deny the text below? I use 2.5.2 from the website as firebirdclient. Thanks Alexande

[Firebird-net-provider] More info from llblgenpro

Hi Jiri This might also help? Thanks Alexander Muylaert wrote: Otis wrote: As you use a non-final Firebird build, it might be you use features not supported by the Firebird ADO.NET provider yet. The thing is, we use the GetSchema "ProcedureParameters" call of the ADO.NET provider

Re: [Firebird-net-provider] Rename a table

Then stick with oracle, it is a good/better database, but stop spamming my mail account. I'm subscribed to this newsgroup because I care and sponsor the .net provider. Not to listen to some hysterical chicken threatening to go back to oracle. Did you know firebird doesn't support fulltext search

[Firebird-net-provider] Recoverable exceptions, fatalities

Hi Jiri I would like to make a seperation between recoverable exceptions and fatal exceptions coming from the database. A fatal error might be network lost, database gone, ... If this happens I would like to try to "reconnect" the client or even shutdown the application. A recoverable error,

Re: [Firebird-net-provider] A "thread-safety" workarround

I have too admit that I have written multithreaded servers and made many multithreaded things in my life. I'm also a specialist in debugging issues made by people who economized on resources and lacks in a threading environment. Don't do this to yourself... Alexander -

Re: [Firebird-net-provider] Building my own FirebirdSQL

Just to let you know I asked with subversion for the tagged 2.5.2 source again, opened it in 2010. Had it converted, switched the framework to 4.0. Made a fix inside the eventmanager and now everything works again. So I think something went wrong in your changes since 2.5.2, probably last Sunday

Re: [Firebird-net-provider] Building my own FirebirdSQL

Hi Jiri The line is there and if I play around in this procedure, like putting extra exceptions in here, I can see it it perfectly called. I can also open the model. I just can't "update" it anymore. If I do an update with your build, no "connection info" is asked. If I do it with my build, a po

Re: [Firebird-net-provider] Building my own FirebirdSQL

Yep, -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: maandag 26 april 2010 10:29 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Building my own FirebirdSQL On Mon, Apr 26, 2010 at 10:18, Alexander Muylaert

[Firebird-net-provider] Building my own FirebirdSQL

Hi Jiri I checked out the sourcecode of firebirdprovider and I got a working build of the provider. Well, in runtime everything works, in visual studio I have the following problem. Do you have an idea what it could be? I'm building on VS2010, Premium, for .net 4.0? (I just put it on release).

[Firebird-net-provider] [FB-Tracker] Created: (DNET-309) Possible workaround for CORE-1239, Left outer - inner join

Components: ADO.NET Provider Affects Versions: 2.5.2 Environment: All Reporter: Alexander Muylaert Assignee: Jiri Cincura The entity framework often generates statements that go like from table a left outer join table b on a.bid = b.id inner join table c

Re: [Firebird-net-provider] EF query > natural scan

ubject: Re: [Firebird-net-provider] EF query > natural scan Hi, On Sun, Apr 11, 2010 at 08:03, Alexander Muylaert wrote: > inners > first and then the outers well it's possible. I don't know how much work it is, because it's done via visitor pattern and sometimes you don

Re: [Firebird-net-provider] EF query > natural scan

also be to remove the reason (FK) why it is causing this left outer join. But adapting the db design to do a bugfix is actually worse... Although... it solves my issue... Any thoughts are appreciated. Thanks Alexander -Original Message----- From: Alexander Muylaert [mailto:amu

[Firebird-net-provider] EF query > natural scan

Hi Jiri I just discover something weird in FB RC2. I posted it on tracker, but maybe you might be able to solve (workaround) it? Could you have a quick look at this? Maybe I'm just plain wrong. http://tracker.firebirdsql.org/browse/CORE-2963 Thanks Alexander ---

Re: [Firebird-net-provider] VS2010 solution/projects conversion

Because it is 2010 times better as 2008? Kind regards Alexander -Original Message- From: Douglas Tosi [mailto:dougla...@gmail.com] Sent: zaterdag 10 april 2010 19:34 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] VS2010 solution/projec

[Firebird-net-provider] [FB-Tracker] Created: (DNET-307) TransactionScope

TransactionScope Key: DNET-307 URL: http://tracker.firebirdsql.org/browse/DNET-307 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider Reporter: Alexander Muylaert

[Firebird-net-provider] [FB-Tracker] Created: (DNET-306) Conditional loggin / debugging

: Alexander Muylaert Assignee: Jiri Cincura Hi Jiri Danny just showed me a new conditional debugging possibility. If you put the Conditional Attribute on certain methods, you could have the jit compiler solve this issue for you. Instead of having a debug and release build of your

[Firebird-net-provider] [FB-Tracker] Created: (DNET-303) Unit tests on entity framework

4, vs 2010, EF4 Reporter: Alexander Muylaert Assignee: Jiri Cincura Priority: Minor Hi Jiri I have hundreds of unittest running to check our logic. Many of these tests restore an empty firebird DB and create a new EF model to this database. At the end of each

[Firebird-net-provider] Entity Framework 4.0 delete statements

Hi Jiri I have a question for you. It looks like the generation of the delete statement has changed inside ef4.0. (I'm not sure if it has changed, but I'm sure it is not the behavior i'm expecting) When one is deleting a record with foreign navigation properties, it includes these properties

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-287) MemoryProblem when not dispose the DbCommand

Hi André Yes, this is way better. Because now you are doing less (you don't allocate a new client command, you don't ask your server to parse your statement 50.000 times, you don't ask your server to dispose his handle 50.000 times). But still you should dispose what you don't need. It alwa

Re: [Firebird-net-provider] Generated primary key columns in EF

I have to admit that I allready wrote a tool for me that "fixes" the edmx file on every build. For me it is easy, If the fieldname is ID, I set the pattern. But I can imagine that for some people this is not possible. -- From: "Jiri Cincura" Sent:

Re: [Firebird-net-provider] Using the .NET providerwithInterbasedatabases

nd I am in a position where I need to deploy access from a bunch of 64 bit servers. I can configure the web apps to run in a 32 bit worker process, but I am looking to avoid that if possible. Cheers, David Clegg ---

Re: [Firebird-net-provider] Using the .NET provider with Interbasedatabases

Hi David Maybe it does, maybe it doesn't. Who knows... It is for sure not designed to work with Interbase. Ask Embarcadero for an appropriate driver for interbase. They have their own. kind regards Alexander From: David Clegg Sent: Monday, September 21, 2009 10:17 PM To: firebird-net-pr

Re: [Firebird-net-provider] Hi everyone : new to this list, problem with DDEX

Hi Richard Maybe this is interesting. http://cc.embarcadero.com/Free.aspx?id=25497 kind regards Alexander From: Richard Clarke Sent: Thursday, September 10, 2009 3:56 PM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Hi everyone : new to this list,problem wi

Re: [Firebird-net-provider] Hi everyone : new to this list, problem with DDEX

Hi Richard I wouldn't use the firebird provider for interbase access. It is not supported at all. I would seek for .net providers for interbase. kind regards Alexander From: Richard Clarke Sent: Thursday, September 10, 2009 3:56 PM To: firebird-net-provider@lists.sourceforge.net Subjec

Re: [Firebird-net-provider] Generated primary key columns in EF

We actually solved this by writing a small command line tool that we call from our pre build events. It prepares the XML file for real usage. (Don't save the edmx file if you haven't changed anything, our your build will take minutes each time). Since all our ID's always are called "ID" we just

[Firebird-net-provider] Firebird 2.5 QueueEvents > CPU goes to 100%

Hi Jiri I would like you to inform you about an issue we reported earlier. You know that we had issues with the event system. Sometimes the 2.5 core went berserk and started writing errors to the logfile. Making the logfile huge after a while. The current state of the firebird is the follo

Re: [Firebird-net-provider] Visual Studio 2010, Firebird and the Entity Framework

hi I works perfectly, but make sure you update the machineconfig in the 4.0 repository of net. kind regards Alexander From: Jonas Blaausgedacht Sent: Thursday, June 11, 2009 4:34 PM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Visual Studio 2010,Firebird