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.
2016-12-
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
Pocket
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 ca
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 :
> Hi guys,
>
> Looking at FbBatchExecution's ctor I don't see a reason why
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 to
You`re welcome :)
2014-06-04 21:39 GMT+03:00 Jiri Cincura :
> 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
> wrote:
>
>&
Confirmed - restore now works :) Thanks a lot
2014-06-04 18:04 GMT+03:00 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 a
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 tha
ess)
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 :
> On Wed, Jun 4, 2014 at 10:55 AM, Ivan Arabadzhiev
> wrote:
> > Won`t that be a problem?
>
> Not
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 \FirebirdSql\D
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
ous whether
you`ll have the same issue :)
2014-06-03 13:59 GMT+03:00 Jiri Cincura :
> On Tue, Jun 3, 2014 at 10:46 AM, Ivan Arabadzhiev
> wrote:
> > Here's the restore function (in case it helps)
> >
> >using(io.FileStream BackupInputStream = new
> &g
he end of time). I'm willing to help
debug if I can get my hands on sources :)
2014-06-03 8:50 GMT+03:00 Jiri Cincura :
> On Mon, Jun 2, 2014 at 10:21 PM, Ivan Arabadzhiev
> wrote:
> > Should anything be done to the stream apart from construction? Any
> special
> > mo
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 recor
Hi,
I haven`t used scripts in a while but I think if it fails to Commit it
will throw an exception ...
> Hi all,
>
> Is there any way of determining if there is an active transaction being
> used
> by an FbCommand? I have searched the properties of FbCommand,
> FbConnection,
> FbTransaction
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 connect
One more vote for the .Open method. I think it`s quite firebird-specific
and therefore has no place in the connection string.
> On Wed, Apr 11, 2012 at 1:50 PM, Mercea Paul
> wrote:
>> As i remember well there is a option on restore proces to start without
>> activating database triggers.
>
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 thi
Ok, I`ll post a diff from 2.7.0 if I get it to run (hope to find time in
2-3 weeks).
> On Wed, Feb 1, 2012 at 4:14 PM, Ivan Arabadzhiev
> wrote:
>> Is the provider expected to still work on .Net CF? Does anyone actually
>
> Yes, it is. But you'll probably need to do some
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 any
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
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
fo
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
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!
ht
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), th
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 Set
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
Hi,
You have no problems with that (running .net compact 3.5 in my case).
However, as a "victim" of windows CE, I can warn you that it has fewer
character sets than Windows mobile:)
> The sync function in .net (allows you to sync databases together)
>
> I have a Firebird database running on
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 compla
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
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
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 rea
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!
--
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 t
Tue, 04 May 2010 20:44:51 +0300, Jiri Cincura :
> On Tue, May 4, 2010 at 15:25, Ivan Arabadzhiev
> wrote:
>> So having inactive queries a few hours after their transactions have
>> ended
>> does not mean I messed up? :)
>
> Not necessarily.
>
Ok, so the reas
Tue, 04 May 2010 16:21:14 +0300, Jiri Cincura :
> On Tue, May 4, 2010 at 13:51, Ivan Arabadzhiev
> wrote:
>> Or is that table expected to show inactive querys (a history of some
>> sort)?
>
> It's a stable snapshot of time when issued. Also note whether the
>
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
sor
Mon, 03 May 2010 12:55:16 +0300, Jiri Cincura :
> On Sat, Apr 17, 2010 at 18:54, Ivan Arabadzhiev
> 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 at a
>> time
>&g
How stable is your connection and how big is the query?
Thu, 22 Apr 2010 14:06:21 +0400, Lucjan Łyczak :
> 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
> get
> t
One by one :)
Thu, 22 Apr 2010 13:37:23 +0400, Jiri Cincura :
> On Thu, Apr 22, 2010 at 08:25, Ivan Arabadzhiev
> wrote:
>> I`d appreciate them
>> appearing in the main source tree
>
> No problem. Let's see what others say.
>
>> private void SetKeepali
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 and
Thu, 22 Apr 2010 10:55:57 +0400, Jiri Cincura :
Well, yes but AFAIR firebird mentions possible issues with the dummy
packet, and is considered unneeded because of the SO_KEEPALIVE default on
the new versions. I can`t really say I always follow standards, but in
this case - it does seem like
r 21, 2010 at 16:32, Ivan Arabadzhiev
> 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
>&g
connection string or FbConnection
member?) or should I keep them to myself?
Thanks a lot - looking forward to the next version :)
Thu, 22 Apr 2010 01:06:16 +0400, Jiri Cincura :
> On Wed, Apr 21, 2010 at 16:32, Ivan Arabadzhiev
> wrote:
>> 1 Would .Cancel() work if I execute it on an
1 Would .Cancel() work if I execute it on another thread (the watchdog
one) ? I can live with 'wait till fb 2.5 finall' since I`m really eager to
update anyway :)
2 2.1 Mon tables don`t seem to work every time (I`ve had about 10% success
in "delete from mon$statements" on such long-lasting o
From time to time I happen to perform procedures which require a lot of
time (10+ minutes sometimes). The actual problem is that if the connection
happens to drop during those 10 minutes since there is no actual transfer
(it is a really, really long stored procedure which might have to go
: 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
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
on different 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 :
> On Sat, Apr 17, 2010 at 14:35, Ivan Arabadzhiev
> wr
ction, but nothing more), and I don`t really
> On Fri, Apr 16, 2010 at 18:18, Ivan Arabadzhiev
> 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
Really, really sorry about the previous post but I guess I hit some sort
of "quick send" button on the Opera :(
To say it shorter - you are probably right, but I still believe in
thread-safety (and I hate mutexes) :). I guess I`ll get some sort of
wrapper for the provider to handle threads .
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
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!
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 Fire
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 read
Thu, 22 Oct 2009 20:52:48 +0300, Jiri Cincura :
> 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?
--
Sanity is a s
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: PlatformNot
Tue, 16 Jun 2009 10:43:13 +0300, Alexander Muylaert
:
> 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
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
i
Mon, 11 May 2009 17:46:31 +0300, Jiri Cincura :
> 2009/5/11 Ivan Arabadzhiev :
>> 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 (consistency, con
Mon, 11 May 2009 14:24:16 +0300, Jiri Cincura :
> 2009/5/11 Ivan Arabadzhiev :
>> public FbTransaction BeginTransaction(FbTransactionOptions options,
>> string transactionName)
>>
>> overload of the function, but according to google fb 2.1 checks the
>> header
Fri, 08 May 2009 19:03:12 +0300, Jiri Cincura :
> 2009/5/8 Ivan Arabadzhiev :
>> 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.ReadCom
Thu, 07 May 2009 15:09:31 +0300, Jiri Cincura :
> 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,
> Protected
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
Can anyone provide a link to a compiled dll? Or suggest source
modification so that I could build it agains the "old" framework? Visual
Studio has objections against using a 3.5 dll with .net 2.0 :)
--
Ние лудите сме на изчезване, трябва да се подкрепяме !
---
Hi,
I did have that very same issue. Currently I have two possible solutions :
1 Start a transaction every once in a while (though this does tend to
increase server load when you have multiple clients)
2 Check the "connectioncount" of the server using
FirebirdSql.Data.Services.FbServerProperti
Wed, 22 Apr 2009 21:00:01 +0300, Jiri Cincura :
> 2009/4/19 Ivan Arabadzhiev :
>> 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 mess
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 fireb
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,
ta shold not conflict with
> your bussiness at all.
>
> 2009/3/29 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
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,
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
72 matches
Mail list logo
