Re: [Firebird-net-provider] problem with a query (maybe a bug)

Any reason why you are not doing it simpler like this: to get list of user id's for specific view SELECT USER_VIEWS_MAP.USER_ID FROM USER_VIEWS_MAP WHERE USER_VIEWS_MAP.VIEW_ID = @viewid and something like this get the user table: SELECT USER_INFOS.* FROM USER_INFOS INNER JOIN

[Firebird-net-provider] [FB-Tracker] Created: (DNET-316) Null reference exception on fbcommand dispose

Affects Versions: 2.5.2 Environment: Windows 7, .net 3.5 sp1, visual studio 2008 Reporter: Gerdus van Zyl Assignee: Jiri Cincura I have been getting the following exception if I close an connection (or forget to close connection manually) before explicitly

Re: [Firebird-net-provider] DDEX Provider installed and works....but not correctly

Try right clicking on eg notepad Run as Administrator and opening and saving using that. On Sun, Jun 13, 2010 at 5:46 PM, Jiri Cincura disk...@cincura.net wrote: On Sat, Jun 12, 2010 at 02:54, will ferguson willfergu...@westruss.com.au wrote: I'm a local admin. But I notice the permissions on

Re: [Firebird-net-provider] the NETProvider- Install Failed

You can install it manually. get the dll file from http://netprovider.cincura.net/ Open the Visual Studio Command Prompt goto the folder you downloaded the dll run: gacutil /i FirebirdSql.Data.FirebirdClient.dll On Wed, Jun 30, 2010 at 2:16 PM, Peter Gore pg...@martinmccoll.co.uk wrote: Thanks

Re: [Firebird-net-provider] Data types returned by FbDataReader.GetValue

-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Gerdus van Zyl -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer

Re: [Firebird-net-provider] problem with parameters

now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Gerdus van Zyl

Re: [Firebird-net-provider] INSERT work but nothing do...

list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Gerdus van Zyl http://about.me/gerdus -- vRanger cuts backup time in half-while increasing

[Firebird-net-provider] connection pooling - connection not closing after lifetime over

to be the culprit since commenting it out gives the expected behavior of the the cleanup being performed and the callback being called multiple times. Is this a bug or is it by design? Thank You -- Gerdus van Zyl http://about.me/gerdus

Re: [Firebird-net-provider] How to build Firebird connection string

___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Gerdus van Zyl http://about.me/gerdus -- Write

[Firebird-net-provider] [FB-Tracker] Created: (DNET-408) Connection pool cleanup timer is executed only once because timer is disposed in worker method

Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 2.7 Reporter: Gerdus van Zyl Assignee: Jiri Cincura Priority: Minor Attachments: FbConnectionPool.cs.patch

Re: [Firebird-net-provider] fbbackup

It will give an exception if there is a problem. you have to set Verbose = True on FbRestore/FbBackup so that the program blocks until the backup is complete. restore.Verbose = True AddHandler restore.ServiceOutput, Sub(sender As Object, e As ServiceOutputEventArgs)

Re: [Firebird-net-provider] ClearAllPools and opened connections

/lists/listinfo/firebird-net-provider -- Gerdus van Zyl http://about.me/gerdus -- Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs

Re: [Firebird-net-provider] Error: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

Remove role=; from your connectionstring, don't know why but if I add it to my working connection string it gives the same error. FbConnectionStringBuilder is recommended to build a connectionstring. http://about.me/gerdus

Re: [Firebird-net-provider] RES: RES: Error reading data from the connection

What is the values on your connection string for ConnectionLifeTime and MinPoolSize ? On Tue, Jan 27, 2015 at 1:57 PM, Nicolas F. Timmers nftimm...@hotmail.com wrote: I think probably the application pool is not running again for this case see I have. A customer connected early on the

Re: [Firebird-net-provider] RES: RES: RES: Error reading data from the connection

wrote: I do not modify these values even inform them in the connection string, I'm wondering because he is giving this error even after hours after the User no longer used *De:* Gerdus van Zyl [mailto:gerdusvan...@gmail.com] *Enviada em:* terça-feira, 27 de janeiro de 2015 10:04 *Para

Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7] inhttp://www.firebirdsql.org/en/net-examples-of-use/

, in this reasoning, be possible to monitor events, but in a different form of language C#, with the handler of Visual Basic events. Again, can you help me? Thank U. Paulo Cezar Altafin .·. Cambé - Pr - Brasil *From:* Gerdus van Zyl gerdusvan...@gmail.com *Sent:* Wednesday, March 04, 2015 6:56 AM

Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7] in http://www.firebirdsql.org/en/net-examples-of-use/

/listinfo/firebird-net-provider -- Gerdus van Zyl www.infireal.com -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored

Re: [Firebird-net-provider] visual studio doesn't accept my firebird connection string?

t-provider > -- Gerdus van Zyl www.infireal.com -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Zlib library

t; Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Gerdus van Zyl www.infireal.com -

Re: [Firebird-net-provider] Disconnection Problem In Vb.net with Firebird

What I do in my code is issue the database shutdown command(see http://firebirdsql.org/manual/gfix-dbstartstop.html) after closing all connections I can. Imports FirebirdSql.Data.Services Dim s As New FbConfiguration() s.ConnectionString = Me.Connection.ConnectionString

Re: [Firebird-net-provider] Testing the compression?

Mgr. Jiří Činčura > Independent IT Specialist > > > -- > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- ------------

Re: [Firebird-net-provider] Finalizers

lizer thread. > > Of course it will be new major version. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > > -- > > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforg

Re: [Firebird-net-provider] EntitiyFramework and Update

> Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- -----------

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

d-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > -- Gerdus van Zyl www.infireal.com -- Developer Access Program for Intel Xeon Phi Processors Access to I

Re: [Firebird-net-provider] Prepared statements cache inside .NET provider

ot > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > --

Re: [Firebird-net-provider] Connecting to encrypted databases

I think it makes more sense on the connection string. It already contains sensitive info (username,password) and needing to provide connection related info by another method would be counter intuitive. On 12 July 2017 at 08:55, Jiří Činčura wrote: > Hi *, > > thanks to

Re: [Firebird-net-provider] Connecting to encrypted databases

What about a callback on Connection that returns a Connection Info (ConnectionStringBuilder-like) object. Could also add a connection constructor overload that accepts a Connection Info object. Can then provide all connection data in one place with convenience of not converting from/to a string.

Re: [Firebird-net-provider] FbTrace for Firebird 3

Option 2 - ctor with target version sounds the best. You could name pre3 version enum "Version1" and the new format "Version2" so it's not linked to FB version. A nice to have would be to have default enum value be "DetectVersion" which would do the roundtrip server check. On 17 July 2017 at

Re: [Firebird-net-provider] Connecting to encrypted databases

Not exactly sure what you mean with right away. The reason to not use the existing ConnectionStringBuilder is that it is implicit that it can be converted to a string. Which would not be true anymore, except if you add EncryptionKey to connection string parsing anyway. On 12 July 2017 at 13:51,

Re: [Firebird-net-provider] Error reading data from the connection

You can just catch the exception, rollback the batch transaction if possible, reconnect and retry that batch again. Having retry logic is the only way to ensure reliability. On 16 November 2017 at 16:33, LtColRDSChauhan wrote: > Hello, > > 1. I need to frequently copy a

Re: [Firebird-net-provider] FbDatabaseInfo.ActiveTransactions

Normal if it reverts to 0. Check that NextTransaction and OldestActiveTransaction do increase after every transaction. On Thu, 7 Jun 2018 at 18:33, Norbert Saint Georges wrote: > the value never changes despite several transactions. > normal? > > -- > Norbert Saint Georges > http://tetrasys.fi