Re: [Firebird-net-provider] Backup with fbembed cannot open database file

2013-10-21 Thread Pierre Arnaud
oct. 2013 à 09:47, Jiri Cincura a écrit : > >> On Sun, Oct 20, 2013 at 10:40 PM, Pierre Arnaud >> wrote: >> It's an FbException wrapping an IscException with the following message: >> >> I/O error during "CreateFile (open)" operation for file &g

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

2013-10-20 Thread Pierre Arnaud
> > Calling FbBackup.Execute throws the exception because of the sharing > > violation. > > What's the message exactly? It's an FbException wrapping an IscException with the following message: I/O error during "CreateFile (open)" operation for file "C:\PROGRAMDATA\FOO\BAR.FIREBIRD" Error w

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

2013-10-20 Thread Pierre Arnaud
> You mean FbBackup? Ah, yes, sorry. The interface IDbServiceTools.Backup is not part of the .NET Provider, but part of one of our DB layers. We are calling FbBackup.Execute with just one path in BackupFiles, a ConnectionString which specifies the Embedded server type and as the Options, just 'Ig

[Firebird-net-provider] Backup with fbembed cannot open database file

2013-10-20 Thread Pierre Arnaud
Hello, We had been using successfully IDbServiceTools.Backup with the Embedded Firebird DLL. For some time now, and with no apparent reason (i.e. we cannot figure out what changed in our source control tracking system), the backup fails with a sharing violation, when the backup tries to open the d

Re: [Firebird-net-provider] Checking database existence

2013-06-15 Thread Pierre Arnaud
Hi Jiri, We have gone the "try to connect to database" route. Trying to create the database requires that you also cleanup afterwards in order not to leave an empty database lying around; and what if you can't delete it? Or what if some other process tries to do the same thing at the same time? O

Re: [Firebird-net-provider] Dropping (pure) .NET 2.0 support

2012-08-09 Thread Pierre Arnaud
It's always nice being able to clean up code :-) -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: mercredi 1 août 2012 14:25 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Dropping (pure) .NET 2.0 support As we don

[Firebird-net-provider] What is the API to backup the database to a local file

2011-09-27 Thread Pierre Arnaud
I wanted to know if there is some hidden API in the Firebird .NET provider which would allow me to backup a remote database to a local file (I mean local on the client machine), just like what can be achieved with GBAK : http://www.firebirdfaq.org/faq62/ Pierre -

Re: [Firebird-net-provider] Transaction configuration with the ADO.NET Data provider for Firebird

2010-08-08 Thread Pierre Arnaud
07, 2010 3:41 PM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] Transaction configuration with the > ADO.NET Data provider for Firebird > > On Sat, Aug 7, 2010 at 14:45, Pierre Arnaud wrote: > > Would you consider adding

[Firebird-net-provider] [FB-Tracker] Created: (DNET-338) Implement table locking in the provider

2010-08-07 Thread Pierre Arnaud (JIRA)
Environment: Any Reporter: Pierre Arnaud Assignee: Jiri Cincura Allow the provider to request table locking when creating a transaction. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators

Re: [Firebird-net-provider] Transaction configuration with the ADO.NET Data provider for Firebird

2010-08-07 Thread Pierre Arnaud
Hello Jiri, > On Tue, Aug 3, 2010 at 10:36, Marc Bettex wrote: > > new FbTransactionOptions() > > { > >        TransactionBehavior = FbTransactionBehavior.Concurrency | > > FbTransactionBehavior.Wait | FbTransactionBehavior.LockWrite | > > FbTransactionBehavior.Protected > > }; > > You can't spe

Re: [Firebird-net-provider] FbDataAdapter, commands and transactions

2010-06-13 Thread Pierre Arnaud
t: Sunday, June 13, 2010 5:49 PM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] FbDataAdapter, commands and > transactions > > On Sat, Jun 12, 2010 at 13:55, Pierre Arnaud > wrote: > > No, I do not call SqlCommandBuilder.G

Re: [Firebird-net-provider] FbDataAdapter, commands and transactions

2010-06-12 Thread Pierre Arnaud
ET providers > Subject: Re: [Firebird-net-provider] FbDataAdapter, commands and > transactions > > On Wed, Jun 9, 2010 at 22:39, Pierre Arnaud wrote: > > Because adapter.UpdateCommand stays null for the whole execution of > > my program! > > Are you calling GetUp

Re: [Firebird-net-provider] FbDataAdapter, commands and transactions

2010-06-09 Thread Pierre Arnaud
> > Is there some official means of getting the adapter to use the new > > transaction when it refreshes its update command, other than my > > current hack ? > > Maybe I'm missing something, but why not to set > adapter.UpdateCommand's transaction? Because adapter.UpdateCommand stays null for the

[Firebird-net-provider] FbDataAdapter, commands and transactions

2010-06-09 Thread Pierre Arnaud
Hello Jiří, I have been struggling with FbDataAdapter for years now (it goes back to the days when Carlos was in charge), and I had finally given up and used a hack to fix my problem; I've come across it again and I'd like to know if there is a proper way to solve it. Here is what I do: - I crea

Re: [Firebird-net-provider] Comparing performance measurements on Fb.NET 2.5.0 and 2.5.2

2010-05-17 Thread Pierre Arnaud
Hello Jiri, Thank you for your quick reply. > What profiling technique are you using? Instrumentation? Sampling? ... Sampling, as this is the less intrusive of the performance tools. There is only a slight "wall clock" difference between a run with and without the performance monitoring. > > -

[Firebird-net-provider] Comparing performance measurements on Fb.NET 2.5.0 and 2.5.2

2010-05-17 Thread Pierre Arnaud
Hello Jiri et al, I am working on a large project which we migrated from .NET 2 to .NET 4 a few weeks ago. Up to this morning, I was still linking against the 2.5.0 build of FirebirdSql.Data.FirebirdClient (built for .NET 2.0). After updating to 2.5.2, compiled on VS 2010 for .NET 4.0, I ran our

Re: [Firebird-net-provider] FbTransactionOptions.Read / Write

2008-10-21 Thread Pierre Arnaud
oviders > Subject: Re: [Firebird-net-provider] FbTransactionOptions.Read / Write > > On Tue, Oct 21, 2008 at 3:41 PM, Pierre Arnaud <[EMAIL PROTECTED]> > wrote: > > Well, I am lost here. I am referring to following SVN file : > > > > > <https://firebird.sv

Re: [Firebird-net-provider] How to build from SVN sources

2008-10-21 Thread Pierre Arnaud
> -Original Message- > From: Jiri Cincura [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 21, 2008 11:57 AM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] How to build from SVN sources [...] > I'm building using VS2008 and/or msbui

Re: [Firebird-net-provider] FbTransactionOptions.Read / Write

2008-10-21 Thread Pierre Arnaud
Hi Jiri, > > I've just discovered that I can no longer specify an > > FbTransactionOptions.Read or FbTransactionOptions.Write flag when I > > call FbTransaction.BeginTransaction with .NET Provider 2.5. > > You mean Alpha 2? It's same as 2.1. You will just specify > FbTransactionOptions.Foo | FbTr

[Firebird-net-provider] How to build from SVN sources

2008-10-21 Thread Pierre Arnaud
Hello Jiri, I've been away for over a year from the Firebird .NET scene and now I'd like to build the latest version of the source tree. I've checked out the full "trunk" of NETProvider and I naively tried to just do a nant build in the /build/win32/ado.net/ folder. I got compile errors caused by

[Firebird-net-provider] FbTransactionOptions.Read / Write

2008-10-21 Thread Pierre Arnaud
Hi, I've just discovered that I can no longer specify an FbTransactionOptions.Read or FbTransactionOptions.Write flag when I call FbTransaction.BeginTransaction with .NET Provider 2.5. What is the official means of stating that a transaction will not modify anything and should be "read only" ? A

Re: [Firebird-net-provider] Leaving the project

2008-01-07 Thread Pierre Arnaud
Hello Carlos, How sad that you leave us alone in the dark ;-) but nevertheless, I hope you'll enjoy your spare time and find other exciting things to do, which have nothing in common with keyboards and mice. Is there any official maintainer who is in charge of collecting bug fixes and putting up

Re: [Firebird-net-provider] UTF8 character set in connection string breaks CHAR(n)

2006-11-19 Thread Pierre Arnaud
On Sunday, November 19, 2006 1:27 AM [GMT+1=CET], Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: > Hello: >> Disabling the constraint checking on the DataSet loads a column >> which now has 128 characters in length, not 32 ! The first 32 chars >> are correct and then I see 96 spaces. > > Huummm

[Firebird-net-provider] UTF8 character set in connection string breaks CHAR(n)

2006-11-18 Thread Pierre Arnaud
Hello Carlos, I've been using the UNICODE_FSS character set specification in my connection string successfully when accessing fixed length CHAR(n) columns defined as UTF8. I have a column with CHAR(32) CHARACTER SET UTF8 specified and when I fill a DataSet through a DataAdapter, I get back my 32

Re: [Firebird-net-provider] Complex bug/problem with transactions

2006-11-03 Thread Pierre Arnaud
On Friday, November 03, 2006 7:16 PM [GMT+1=CET], Pierre Arnaud <[EMAIL PROTECTED]> wrote: > (6) I create a transaction, associate it with my original SELECT >command, then I call Update on the adapter. However, at this >point, the InsertCommand already exists; it is

[Firebird-net-provider] Complex bug/problem with transactions

2006-11-03 Thread Pierre Arnaud
Hello Carlos, Sorry to bother you again. I've spent the whole day trying to pin down a problem I had never experienced with the 1.7 provider and that I have now with the latest 2.1 from CVS. I cannot provide you with a demo code for now, as it is very difficult to get to the point where the probl

[Firebird-net-provider] Intellisense support

2006-10-30 Thread Pierre Arnaud
With the 1.7 version of FirebirdSql.Data.Firebird.dll, I could generate a FirebirdSql.Data.Firebird.xml file which helped Visual Studio in pro- viding better Intellisense support. I have not been able to generate the XML file for the 2.0 provider. Has anybody some hints as to how I should proceed?

Re: [Firebird-net-provider] Crash in Update

2006-10-30 Thread Pierre Arnaud
command.Transaction = null; transaction.Commit (); dataSet.Tables[0].Rows.Add (300, "Pierre", "Arnaud", System.DBNull.Value, System.DateTime.Now, 622, "Eng", 5, "Switzerland", 0.0, "Arnaud, Pierre"

Re: [Firebird-net-provider] Crash in Update

2006-10-30 Thread Pierre Arnaud
Here is an update on the previously described bug. If I edit the SelectCommmand of the DataApter in the FbCommandBuilder RowUpdatingHandler to remove the "WHERE (0 = 1)" condition, the code no longer crashes. This should really narrow down the problem :-) If you find a fix, how can I get the upda

[Firebird-net-provider] Crash in Update

2006-10-30 Thread Pierre Arnaud
Hello Carlos, It has been quite some time since I did not update my code with respect to Firebird and the FirebirdClient library. I have downloaded and compiled FirebirdClient ADO.NET 2.0 provider for .NET 2.0. It is the final 2.0 version. And I am running a RC5 Firebird server on my 2003 server.

Re: [Firebird-net-provider] System.Transactions and TransactionScope

2006-02-23 Thread Pierre Arnaud
On Tuesday, February 21, 2006 11:52 AM [GMT+1=CET], Alexander Gräf <[EMAIL PROTECTED]> wrote: Ah, yes, the database seems to need support for two-phase commits If Ann or Helen would read that! Of course, Firebird *does* support two-phase/limbo transaction. However, don't ask me how to utilize

Re: [Firebird-net-provider] System.Transactions and TransactionScope

2006-02-21 Thread Pierre Arnaud
On Sunday, February 19, 2006 9:41 PM [GMT+1=CET], Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello: Thank you for this wonderfully concise answer ;-) hehehe :) Any plans for doing it in some not too distant future ? In first place no, i should give a review to that but in first place t

Re: [Firebird-net-provider] System.Transactions and TransactionScope

2006-02-19 Thread Pierre Arnaud
On Wednesday, February 15, 2006 7:20 PM [GMT+1=CET], Carlos Guzmán Álvarez wrote: Hello: I wonder what the relationship between the Firebird .NET provider and System.Transactions is. I've searched the archives of the list and not found any mention of TransactionScope. Did you already implemen

[Firebird-net-provider] System.Transactions and TransactionScope

2006-02-15 Thread Pierre Arnaud
Hello Carlos, I wonder what the relationship between the Firebird .NET provider and System.Transactions is. I've searched the archives of the list and not found any mention of TransactionScope. Did you already implement support for these system transactions ? Pierre -