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

2016-12-16 Thread Ivan Arabadzhiev
Why would the engine throw such an event in the first place? Does it have an actual reason or is it a bug to be fixed? I don't think the provider should just ignore server messages sent on purpose, but there might be an actual option on whether the current user actually needs them or not.

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

2015-12-01 Thread Ivan Arabadzhiev
Hi, I'm pretty sure https://drive.google.com/file/d/0BxNlh1_CctC4TUJMZ0xqeE81SHM/view?usp=sharing is the version I was using successfully on NET CF 3.5. I have no idea if I compiled it myself at the time (haven't touched any windows-related development in a few years), but it was running on

Re: [Firebird-net-provider] Structs

2015-08-23 Thread Ivan Arabadzhiev
Hi, It seems to me to be mostly a matter of perspective - those 'units' should be small enough not to make a difference at runtime. Personally, I prefer to keep small stuff as a struct, unless it offers functionality, but .net doesn't really run on hw ancient enough for anyone to notice in those

Re: [Firebird-net-provider] FbBatchExecution

2015-06-10 Thread Ivan Arabadzhiev
I did once suggest it should take raw String, a long time ago (did a lot of magic to embed text files to run...). Still think it has uses, but I've mostly moved away from .net now 2015-06-10 16:36 GMT+03:00 Jiří Činčura j...@cincura.net: Hi guys, Looking at FbBatchExecution's ctor I don't see

Re: [Firebird-net-provider] Default pool lifetime

2014-12-29 Thread Ivan Arabadzhiev
Hi, 1 10 seconds sounds way too short to me. I mean, apart from web site/service, most software I`ve come across doesn`t really spawn connections often (if at all) - a lot of people simply keep their connections open and global. When they do open/close connections - it seems perfectly plausible

Re: [Firebird-net-provider] fbBackup on remote Clients

2014-06-04 Thread Ivan Arabadzhiev
Well ... System.ArgumentNullException: Value cannot be null. Parameter name: stream at System.Resources.ResourceReader..ctor(Stream stream) at System.Resources.ResourceSet..ctor(Stream stream) at FirebirdSql.Data.Common.IscException.CreateResourceSet(String resourceName) in

Re: [Firebird-net-provider] fbBackup on remote Clients

2014-06-04 Thread Ivan Arabadzhiev
) System.ArgumentNullException: Value cannot be null. Parameter name: stream at System.Resources.ResourceReader..ctor(Stream stream) 2014-06-04 12:08 GMT+03:00 Jiri Cincura disk...@cincura.net: On Wed, Jun 4, 2014 at 10:55 AM, Ivan Arabadzhiev intelru...@unrealsoft.net wrote: Won`t

Re: [Firebird-net-provider] fbBackup on remote Clients

2014-06-04 Thread Ivan Arabadzhiev
Sorry for the trouble :( I specifically tested importing to check if the network would break. Looks like there is some host dependency. Don`t have a reliable host for virtual machines and I move way too much to give you access to my laptop :) Please tell me you have the same restore issues now

Re: [Firebird-net-provider] fbBackup on remote Clients

2014-06-04 Thread Ivan Arabadzhiev
Confirmed - restore now works :) Thanks a lot 2014-06-04 18:04 GMT+03:00 Ivan Arabadzhiev intelru...@unrealsoft.net: Sorry for the trouble :( I specifically tested importing to check if the network would break. Looks like there is some host dependency. Don`t have a reliable host for virtual

Re: [Firebird-net-provider] fbBackup on remote Clients

2014-06-04 Thread Ivan Arabadzhiev
You`re welcome :) 2014-06-04 21:39 GMT+03:00 Jiri Cincura disk...@cincura.net: Great. Now to pack it, test everything else works, add a nice wrap and ship it. :) Thanks for helping to test it! Appreciate it. On Wednesday, June 4, 2014, Ivan Arabadzhiev intelru...@unrealsoft.net wrote

Re: [Firebird-net-provider] fbBackup on remote Clients

2014-06-03 Thread Ivan Arabadzhiev
to help debug if I can get my hands on sources :) 2014-06-03 8:50 GMT+03:00 Jiri Cincura disk...@cincura.net: On Mon, Jun 2, 2014 at 10:21 PM, Ivan Arabadzhiev intelru...@unrealsoft.net wrote: Should anything be done to the stream apart from construction? Any special modes or anything

Re: [Firebird-net-provider] fbBackup on remote Clients

2014-06-03 Thread Ivan Arabadzhiev
whether you`ll have the same issue :) 2014-06-03 13:59 GMT+03:00 Jiri Cincura disk...@cincura.net: On Tue, Jun 3, 2014 at 10:46 AM, Ivan Arabadzhiev intelru...@unrealsoft.net wrote: Here's the restore function (in case it helps) using(io.FileStream BackupInputStream = new FileStream

Re: [Firebird-net-provider] fbBackup on remote Clients

2014-06-03 Thread Ivan Arabadzhiev
Not using mono:) I`m refactoring a backup tool for windows. I need xp support so I keep things on .net 4.0 Client Profile and VS2010. It`s just that most of the servers worth backing up run linux. What do you mean by first chance exception ? A callstack perhaps? 2014-06-03 20:55 GMT+03:00 Jiri

Re: [Firebird-net-provider] fbBackup on remote Clients

2014-06-02 Thread Ivan Arabadzhiev
Backup part works great :) Managed to backup a 18GB database (took about 2:30 hours by the VPN, so I consider it as stable as it gets). Restore, however keeps throwing FirebirdSql.Data.FirebirdClient.FbException (0x80004005): expected backup description record --- expected backup description

Re: [Firebird-net-provider] Database triggers

2012-04-17 Thread Ivan Arabadzhiev
I agree on that one - Open(triggers=false) should imply 'pooling=false' in the connection string. That way it will not pollute the pool (if it is used) and no further handling will be needed. Well suppressTriggers is not something you would routinely use so I think it should bypass

[Firebird-net-provider] Is CF still supported?

2012-02-01 Thread Ivan Arabadzhiev
I decided to update an old project of mine to the 2.7.0 .net provider and VS2008 grew an arm and punched me in the face :) Is the provider expected to still work on .Net CF? Does anyone actually use/test it? If I find the time to work around (most probably #ifdef the missing stuff, don`t think

Re: [Firebird-net-provider] firebird.net Compact Framework

2011-03-07 Thread Ivan Arabadzhiev
Hi, Sorry it took me that long, but I don`t tend to read the mail too often. Don`t know Why you have problems with rebuilding, but including the sources is quite literal in fact - Simply Add existing files to your project. If memory serves, you should be able to drag`n`drop the sources

Re: [Firebird-net-provider] Getting an assembly to accept more than one provider version?

2011-03-07 Thread Ivan Arabadzhiev
Hi, Don`t know if it helps much, but I`ve never done it myself. You should be able to achieve something with reflection (dynamic loading, matching only runtime version), but .NET itself is based on some ideas (including no more dll nightmares), so I don`t think you`ll find a right-click way

Re: [Firebird-net-provider] firebird.net Compact Framework

2011-02-28 Thread Ivan Arabadzhiev
And you have rebuild the FirebirdClient project (with target framework==2.0)? It is not enough to simply change the version of the project itself. If things do seem imposible, do like I do - include the FirebirdClient sources in your application. It does slow down compilation a bit, but the

Re: [Firebird-net-provider] firebird.net Compact Framework

2011-02-27 Thread Ivan Arabadzhiev
Hi, Why don`t you simple compile it yourself? It seemed quicker to me to define NET_CF, change the target framework and build when I came across the same issue:) Hi.. Thanks for your reply..if so which dll should i download(please provide the linke also..) -- Sanity is a sin!

Re: [Firebird-net-provider] .Net Data Provider for 2.1.3

2011-02-26 Thread Ivan Arabadzhiev
Hi, Sorry about the delay but I saw the mail a few seconds ago. 2.6 and 2.5.2 are provider versions :) They work with basically every firebird server there is (including 2.1.3, which I also use). As far as I know (and I'm not the most experienced person - but I'll try to answer anyway), the

Re: [Firebird-net-provider] problem with a random io exception

2011-02-24 Thread Ivan Arabadzhiev
Hi, Do you close(and reopen) the connection at some point? Any chance there is a not-yet-closed connection you don`t use somewhere out there which would block others from using the DB ? Have you tested on any other systems (personally, in such cases I use a virtual PC with clean Windows

Re: [Firebird-net-provider] Help please

2011-02-13 Thread Ivan Arabadzhiev
Hi, What exactly is your problem? Usually (atleast in my case) all there is to do is to run the installer (which I don`t think is mandatory if you put the assembly in app dir) and to add a reference. Hi, I've been trying to install the firebird .net provider for the whole day and I

Re: [Firebird-net-provider] Help ME

2010-05-23 Thread Ivan Arabadzhiev
Hi, The way I see it - you`re trying to target .net 3.5 (or less) with a 4.0 provider dll. Since I stayed on 2.0 for sometime after 3.5 came out, I had the same issue - download the sources, open the project and change the target framework from project properties. It will most probably

Re: [Firebird-net-provider] RFC: FbScript changes

2010-05-16 Thread Ivan Arabadzhiev
Hi, 1. Only one constructor, taking string. - the FbScript internally works with string so why bother with something else Meaning it will accept the script itself or again filename? Personally, I agree with 2 and have no problems with 3. Since it`s brought up - the only issue I`ve had

[Firebird-net-provider] [FB-Tracker] Created: (DNET-315) isc_dpb_num_buffers support

2010-05-13 Thread Ivan Arabadzhiev (JIRA)
isc_dpb_num_buffers support --- Key: DNET-315 URL: http://tracker.firebirdsql.org/browse/DNET-315 Project: .NET Data provider Issue Type: New Feature Components: ADO.NET Provider Reporter: Ivan

[Firebird-net-provider] isc_dpb_num_buffers support?

2010-05-12 Thread Ivan Arabadzhiev
If I got it right - this should be a runtime setting for the pagecache of the current connection (at least on fb classic; ignored by the superserver). 1 Did i get it right ? :) 2 Is there support in the provider (and if not - should I add it to the tracker as a feature request)? PS The

[Firebird-net-provider] Any way to view transaction ID without a query?

2010-05-09 Thread Ivan Arabadzhiev
I see there is no member of fbTransaction to describe the ID, but is there any way in the provider (through the connection object somehow or whatever) or do I have to Select current_transaction from something ? -- Sanity is a sin!

Re: [Firebird-net-provider] Recoverable exceptions, fatalities

2010-05-06 Thread Ivan Arabadzhiev
Hi, Alexander How about adding a fatal event to the connection object? Most probably passing the connection itself and an exception struct of some sort, allowing the handler to suppress rethrowing of the exepctions? I`ve seen this done by MS in gridviews and so on and it seems handy - if

[Firebird-net-provider] Should statements be freed?

2010-05-04 Thread Ivan Arabadzhiev
I am looking through a database of mine and can`t help noticing that MON$STATEMENTS contains thing which should be done with a long time ago. I don`t use fbcommand outside of using(){} but should anything else be done? Or is that table expected to show inactive querys (a history of some

Re: [Firebird-net-provider] Should statements be freed?

2010-05-04 Thread Ivan Arabadzhiev
Tue, 04 May 2010 20:44:51 +0300, Jiri Cincura disk...@cincura.net: On Tue, May 4, 2010 at 15:25, Ivan Arabadzhiev intelru...@unrealsoft.net wrote: So having inactive queries a few hours after their transactions have ended does not mean I messed up? :) Not necessarily. Ok, so the reason

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

2010-05-03 Thread Ivan Arabadzhiev
Mon, 03 May 2010 12:55:16 +0300, Jiri Cincura disk...@cincura.net: On Sat, Apr 17, 2010 at 18:54, Ivan Arabadzhiev intelru...@unrealsoft.net wrote: Actually I just don`t like the idea of unnesesary connections(I have a thing about wasted resources) so I use just one, doing one thing

Re: [Firebird-net-provider] Is FbCommand.CommandTimeout expected to work?

2010-04-22 Thread Ivan Arabadzhiev
, Apr 21, 2010 at 16:32, Ivan Arabadzhiev intelru...@unrealsoft.net wrote: 3 The network problem happens this way : 3.1 The database server and the work station are working perfectly 3.2 The internet (and vpn connection) fails, but the network interfaces of the station/server

[Firebird-net-provider] Socket change suggestions

2010-04-22 Thread Ivan Arabadzhiev
After a paste in the other options - I googled someting more specific about the socketoptions in .Net, and here`s what I came up with - The intervals are static, but it`s quick and clean. I`d appreciate them appearing in the main source tree (if it does not break standards, expectations

Re: [Firebird-net-provider] Socket change suggestions

2010-04-22 Thread Ivan Arabadzhiev
One by one :) Thu, 22 Apr 2010 13:37:23 +0400, Jiri Cincura disk...@cincura.net: On Thu, Apr 22, 2010 at 08:25, Ivan Arabadzhiev intelru...@unrealsoft.net wrote: I`d appreciate them appearing in the main source tree No problem. Let's see what others say. private void SetKeepalives(ref

Re: [Firebird-net-provider] Execution of query hangs up/freezes

2010-04-22 Thread Ivan Arabadzhiev
How stable is your connection and how big is the query? Thu, 22 Apr 2010 14:06:21 +0400, Lucjan Łyczak luce...@o2.pl: Hi! I have a problem that succeeds sometimes when I execute some queries (select, insert etc.) A program simply hangs up/freezes and I have to break debugging. Then I

[Firebird-net-provider] Disabling database triggers on connection

2010-04-18 Thread Ivan Arabadzhiev
Would it be possible to add it to the feature request list? I get into a wierd situation where a fbserver with not more than 10 connections at any given time says it cannot allocate resources for a DBT (a simple cleanup of the database, Delete from table where id @ID). PS If the idea

[Firebird-net-provider] [FB-Tracker] Created: (DNET-312) Database triggers suppresion

2010-04-18 Thread Ivan Arabadzhiev (JIRA)
: Ivan Arabadzhiev Assignee: Jiri Cincura Priority: Minor An option to suppress Database Triggers when connecting to a database could proof useful as a backdoor to a problematic database. -- This message is automatically generated by JIRA. - If you think it was sent

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

2010-04-17 Thread Ivan Arabadzhiev
, but nothing more), and I don`t really On Fri, Apr 16, 2010 at 18:18, Ivan Arabadzhiev intelru...@unrealsoft.net wrote: Hi, I`ve asked before (and yes, I remember the provider is not thread safe), but I recently started using the 3.5 framework and was hit by a lightning. Could

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

2010-04-17 Thread Ivan Arabadzhiev
threads(gui or background). I find the idea useful and thought other people might like it :) Thanks anyway, a second opinion usually saves me a few weeks of recode :D Sat, 17 Apr 2010 21:38:07 +0400, Jiri Cincura disk...@cincura.net: On Sat, Apr 17, 2010 at 14:35, Ivan Arabadzhiev intelru

[Firebird-net-provider] A thread-safety workarround

2010-04-16 Thread Ivan Arabadzhiev
Hi, I`ve asked before (and yes, I remember the provider is not thread safe), but I recently started using the 3.5 framework and was hit by a lightning. Could the FirebirdConnection object get a public ReaderWriterLockSlim member? It would be just about one line of code (definition ...), and

Re: [Firebird-net-provider] FbBackup v 1.7 code

2010-04-13 Thread Ivan Arabadzhiev
Hi, First of all - http://sourceforge.net/projects/firebird/files/firebird-net-provider/1.7.2/FirebirdNETProvider-1.7.2-Doc.7z/download is about as latest as documentation gets, there was a site with examples but I can`t seem to find it atm; Second, The FbBackup seems to be part of

[Firebird-net-provider] Named transactions

2010-04-13 Thread Ivan Arabadzhiev
Hi, I just wanted to ask what`s the point (and possible use) of a named transaction. Actually, what I`m more interested in is if the provider has a way of starting concurrent transactions (last i checked it threw an exception). Will it handle them if I name them? -- Sanity is a sin!

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

2010-01-03 Thread Ivan Arabadzhiev
Happy new year :) Just to express a modes oppinion. 2.0 Support seems old enough to be dropped (although I am still actively using it). Sooner or later, Microsoft will forget it and there will be no other choice(like they did with the 2.0 sp2, which is not provided standalone). I haven`t

[Firebird-net-provider] PlatformNotSupportedException On windows CE

2009-10-22 Thread Ivan Arabadzhiev
I had a few glitches on my way to get the emulator working properly (still unable to build a .cab file for it though ...), so I decided to run my application directly (with no instalation). I`ve setup .net compact framework 3.5, but now I get : System.PlatformNotSupportedException:

Re: [Firebird-net-provider] PlatformNotSupportedException On windows CE

2009-10-22 Thread Ivan Arabadzhiev
Thu, 22 Oct 2009 20:52:48 +0300, Jiri Cincura disk...@cincura.net: Looks like you're using some character set, that is not supported in this version of framework. OK ... but my DB is WIN1251 ... If I were to open a UTF8 connection for example ... wouldn`t that corrupt the data in some way?

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

2009-06-16 Thread Ivan Arabadzhiev
Tue, 16 Jun 2009 10:43:13 +0300, Alexander Muylaert amuylaert_gel...@hotmail.com: 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

[Firebird-net-provider] A control for setting connection properties

2009-05-22 Thread Ivan Arabadzhiev
I spent a some time today on building a really basic control capable of setting a host, database path, port, user and password. It does ping the server to check connectivity and has a button to validate login info ;) Anyone interested in the .cs file ? I haven`t translated it in English but

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Ivan Arabadzhiev
Fri, 08 May 2009 19:03:12 +0300, Jiri Cincura disk...@cincura.net: 2009/5/8 Ivan Arabadzhiev intelru...@unrealsoft.net: Yes, I do mean those, but for example LockRead | Shared throws an exception upon connect. If I use only ReadCommited it`s ok. Could you Use IsolationLevel.ReadCommited

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Ivan Arabadzhiev
Mon, 11 May 2009 14:24:16 +0300, Jiri Cincura disk...@cincura.net: 2009/5/11 Ivan Arabadzhiev intelru...@gmail.com:  public FbTransaction BeginTransaction(FbTransactionOptions options, string transactionName) overload of the function, but according to google fb 2.1 checks the header

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-11 Thread Ivan Arabadzhiev
Mon, 11 May 2009 17:46:31 +0300, Jiri Cincura disk...@cincura.net: 2009/5/11 Ivan Arabadzhiev intelru...@gmail.com: well ... pretty much anything I could think of. From what I googled - I need a (Shared | LockRead | NoWait | RecordVersion) transaction. I have tried several variations

Re: [Firebird-net-provider] fbTransactionoptions

2009-05-08 Thread Ivan Arabadzhiev
Thu, 07 May 2009 15:09:31 +0300, Jiri Cincura disk...@cincura.net: The FbTransactionOptions has no valid combinations. It's just a holder for transaction params. Maybe you mean FbTransactionBehavior. There you have Consistency = 1, Concurrency = 2, Shared = 4,

[Firebird-net-provider] fbTransactionoptions

2009-05-07 Thread Ivan Arabadzhiev
It`s not actually a provider issue but I was unable to find documentation on the available valid combinations of options, and I can`t really find a reason why firebird doeasn`t like my combinations... can anyone give a hand or should I continue in (the not really successful) trial-and-error

Re: [Firebird-net-provider] Event Issues

2009-04-22 Thread Ivan Arabadzhiev
Wed, 22 Apr 2009 21:00:01 +0300, Jiri Cincura disk...@cincura.net: 2009/4/19 Ivan Arabadzhiev intelru...@gmail.com: I am using firebird .net provider 2.1.0, with a minor backport to be able to register the events on the firebird 2.1.* server (currently 2.1.2). Could it be that I have

[Firebird-net-provider] Event Issues

2009-04-19 Thread Ivan Arabadzhiev
I`m not really sure wether it comes down to the .net provider, but I suppose asking won`t hurt. I have a relatively big database (about 900 MB) handling 5 shops at the moment. Until yesterday it was hosted on a penti...@3ghz machine with 512MB RAM, running Windows XP. At that config the

Re: [Firebird-net-provider] A way to monitor connection state

2009-03-30 Thread Ivan Arabadzhiev
Having multiple connections was a nice idea ... until latency started messing with the data :) I had cases of commited transactions which are not seen by the secondary connection (despite semaphore/lock synchornization ...), which is why I switched to the single connection method ... Mon,

[Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Ivan Arabadzhiev
I am currently developing an application which is supposed to silently ignore lack of database connectivity and continue working transparantly to the end user. There is indication on the GUI about the state of the connection, but I noticed it doesn`t change until an operation is attempted, so I do

[Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Ivan Arabadzhiev
I am currently developing an application which is supposed to silently ignore lack of database connectivity and continue working transparantly to the end user. There is indication on the GUI about the state of the connection, but I noticed it doesn`t change until an operation is attempted,

Re: [Firebird-net-provider] A way to monitor connection state

2009-03-29 Thread Ivan Arabadzhiev
not conflict with your bussiness at all. 2009/3/29 Ivan Arabadzhiev intelru...@unrealsoft.net I am currently developing an application which is supposed to silently ignore lack of database connectivity and continue working transparantly to the end user. There is indication on the GUI