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

[Gerdus van Zyl]

If OldestActiveTransaction does not increase it means there is an old
transaction is still busy and has not commited/rolledback.
You can use the monitoring tables and the transaction ID that
OldestActiveTransaction gives to find out about the transaction that is
stuck.

find the application/connection:
http://www.firebirdfaq.org/faq352/

queries in transaction:
select * from MON$STATEMENTS where MON$TRANSACTION_ID = XX


On Fri, 8 Jun 2018 at 12:30, Norbert Saint Georges  wrote:

> Gerdus van Zyl a écrit :
> > Normal if it reverts to 0.
> he does not reverts to 0, it keeps an old transaction
>
> > Check that NextTransaction and OldestActiveTransaction do increase after
> > every transaction.
>
> OldestActiveTransaction remain imperturbably always the same.
>
> however, NextTransaction returns the active transaction :-(
>
> thank you very much.
>
> --
> Norbert Saint Georges
> http://tetrasys.fi
>
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

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
>
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

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 table from one database to another. This
> has started to fail now, apparently due to increase in number of records.
> Attempting to copy about 13,26,000 records fails reporting “Error reading
> data from the connection”. Number of records that I can still successful
> copy is about 13,24,510.
>
> 3. I copy the in batches of 50,000 records (variable) each. For each
> batch, i open and close connection. I have tried setting connection pooling
> true and false both. Also varied the batch size to 5000, 10 etc.
>
> 2. My database and client are on the same machine. Other details:
>
> RAM 16 GB
>
> Client application 64 Bit
>
> OS Windows 10 64 Bit
>
> Firebird ADO.NET Data Provider – tried both: 5.11.0.0 and 5.12.0
>
> Firebird 3.0.2.32703_0_Win64
>
> 3. Please suggest possible solutions.
>
> Regards,
>
> Rajiv
>
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

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 14:18, Jiří Činčura  wrote:

> Hi *,
>
> Firebird 3 changed the format for trace configuration (yeah, I know) and
> thus the FbTrace now needs to handle this. I'm currently banging my head
> how to nicely present it to you - developers. I came up with these
> solutions.
>
> 1. Provide 2 methods for starting. Like StartPre3 and Start. I like that
> it's discoverable from IntelliSense. And it's just a different method to
> call for developer.
> 2. Have Start method or ctor take enum with target version. Not sure
> about the naming though. Putting "3" might become confusing when v4
> comes out (hopefully without format change).
> 3. Have different FbDatabaseTraceConfiguration classes and developer
> needs to instantiate correct one. I don't feel this is a clean design
> (not that the format change was a good design...).
> 4. Have a FbTrace and FbTrace3 (for example). Again as in 3. Maybe bit
> easier to discover. Don't like the idea of another class that will be
> there "forever".
> 5. Before connecting automagically check server version. Although most
> pleasant from outside, I don't like the idea of extra roundtrip to get
> this information.
>
> Ideas?
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
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

[Gerdus van Zyl]

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, Jiří Činčura  wrote:

> > 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.
>
> Then the ConnectionStringBuilder can be used right away, no?
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
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

[Gerdus van Zyl]

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.


On 12 July 2017 at 10:44, Jiří Činčura  wrote:

> > 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.
>
> Good point.
>
> In my thinking I saw two problems, slightly different from what password
> does. The key can be binary data and that's difficult to pass in string.
> And the key might be stored on some HSM.
>
> Not that it would rule out connection string completely, it just makes
> fit less, IMO.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
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

[Gerdus van Zyl]

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 IBPhoenix I have an plugin
> (http://www.ibphoenix.com/products/software/encryptionplugin) to create
> encrypted database and I have a working prototype for passing the key.
> Now the question of the day. :)
>
> How to pass the key? The two obvious options are in connection string
> and callback on i.e. FbConnection. The callback seems to be an obvious
> choice, because it's most versatile. But I'd like to hear some other
> opinions as well.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

Sound interesting to have in the provider.

Is this only for commands that has Prepare() explicitly called on?
Is there a scenario where performance will be slower than currently?

On 29 March 2017 at 11:58, Slavomir Skopalik  wrote:

> Hi all,
>
> after discussion with Jiri Cincura I prepare proposal for prepared
> statement cache that will be implemented inside .NET provider.
>
> Motivation:
>
> Preparation of SQL statement take a time and also server resources. Many
> SQL server has this functionality build in in engine, but FB not.
>
> More reading for example here:
> http://stackoverflow.com/questions/12141036/preparedstatement-caching-
> what-does-it-mean-how-does-it-work
>
> We implement this to speed up our web application (cache is persistent
> across web requests).
>
>
> Ideas:
>
> Each connection that already exists in pool well keep a private
> dictionary of cached statements (can be disable by config).
>
> Not used SQL will be released after some time out, also cache will have
> maximum statements like default 100.
>
> When application obtaining new connection from pool, provider will look
> for free connection with higher number of cached statements.
>
>
> The question:
>
> Is this interesting to have this functionality inside provider and fully
> transparent?
>
> Slavek
>
> PS: We combine this with RO transaction pool and also with data caching,
> but this is different story.
>
>
> --
> Ing. Slavomir Skopalik
> Executive Head
> Elekt Labs s.r.o.
> Collection and evaluation of data from machines and laboratories
> by means of system MASA (http://www.elektlabs.cz/m2demo)
> -
> Address:
> Elekt Labs s.r.o.
> Chaloupky 158
> 783 72 Velky Tynec
> Czech Republic
> ---
> Mobile: +420 724 207 851
> icq:199 118 333
> skype:skopaliks
> e-mail:skopa...@elektlabs.cz
> http://www.elektlabs.cz
>
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 

Gerdus van Zyl
www.infireal.com
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
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

[Gerdus van Zyl]

I am still using 4.0 due to the difficulty upgrading 500+ computers and a
painful amount of customers still on XP. The downside of desktop software.
That being said the current code is stable and fast in our experience so
would be happy to stay on the current version until we are ready to upgrade
.net version.

On 15 January 2017 at 15:11, Jiří Činčura  wrote:

> Hello *,
>
> reading the
> ===
> As previously announced, starting January 12, 2016 Microsoft will no
> longer provide security updates, technical support or hotfixes for .NET 4,
> 4.5, and 4.5.1 frameworks. All other framework versions, including 3.5,
> 4.5.2, 4.6 and 4.6.1, will be supported for the duration of their
> established lifecycle. The decision to end support for these versions will
> allow us to invest more resources towards improvements of the .NET
> Framework.
> ===
>
> makes me wonder who here is using strictly 4.0, still one year after it's
> no longer supported. ;) It would make my life easier to drop .NET 4 support
> and invest my resources to moving forward faster. 4.5.2+ would still be
> supported, of course.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> 
> --
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> ___
> Firebird-net-provider mailing list
> Firebird-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 Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

I suspect the default transaction option might not be the same in firebird
and other databases.
Try setting the IsolationLevel to SERIALIZABLE on the transaction.

On Wed, Oct 26, 2016 at 10:19 AM, Jiří Činčura  wrote:

> There's really nothing EF related. You can try it with multiple console
> windows with multiple transactions together. It's fundamental way how
> transactions work.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> 
> --
> The Command Line: Reinvented for Modern Developers
> Did the resurgence of CLI tooling catch you by surprise?
> Reconnect with the command line and become more productive.
> Learn the new .NET and ASP.NET CLI. Get your free copy!
> http://sdm.link/telerik
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
------------
Gerdus van Zyl
www.infireal.com
--
The Command Line: Reinvented for Modern Developers
Did the resurgence of CLI tooling catch you by surprise?
Reconnect with the command line and become more productive. 
Learn the new .NET and ASP.NET CLI. Get your free copy!
http://sdm.link/telerik___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

I have run my application's test suite on Firebird 3 with and without
compression and all seems OK.
Verified it's using compression by looking at the server version string
returned by connection (ends with P13:Z).

Have also run tests with compression on high latency connection on database
hosted on Azure.
The difference in transfer time is highly variable but the best case I saw
was almost half; eg without compression 6 seconds vs 3.4s with compression.
Increasing the PacketSize and FetchSize to maximum 32767 also has a large
positive impact on transfer time over internet connection.

Thanks.


On Mon, Sep 19, 2016 at 7:39 PM, Jiří Činčura  wrote:

> Hi *,
>
> anybody testing the compression:
> http://blog.cincura.net/233572-compression-support-in-firebirdclient-beta/
> ?
>
> If not, there's no point in holding the beta. I'll just release it and
> let's see what happens [1]. I can't test it much more myself.
>
> [1]: As it's said. You need to break an egg to make an omelette.
>
> --
> 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
>



-- 

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] Finalizers

[Gerdus van Zyl]

I agree finalizers should not be used to mask or 'fix' incorrect provider
usage. I try to avoid finalizers as much as possible since they run at
unpredictable times causing hard to debug scenarios.

On Sun, Aug 28, 2016 at 5:40 PM, Jiří Činčura  wrote:

> Hi *,
>
> Talking about finalizers in my last email. As I was getting through these,
> I found few that are wrong-ish. In 99% cases failing with exception, that's
> just swallowed. Confirmed from runtime. Although in 1% these might be lucky
> I don't think it's correct usage.
>
> What the finalizers are mostly trying to do is something like close
> connection gracefully with server or free some resources on server.
>
> And I believe this is wrong.
>
> First of all, this should be responsibility of developer to have correct
> Dispose calls. Provider should not try to band aid it unless absolutely
> necessary. Which brings me to the next point. The unmanaged resources,
> where the finalizers make sense, are not something on server. We don't
> manage that. Server should handle just fine when developer doesn’t close
> the connection. Though some resources might be wasted. Unmanaged resources
> directly allocated by provider are really a few around Embedded support
> (mostly pointers and pieces of memory for marshalling). And these are
> properly handled by SafeHandle. And finally finalizers introduce reentrancy
> issues (anybody interested in details?) and it's really not correct in
> provider as it grow out of hands.
>
> So in the foreseeable future I'll go through all of them and do massive
> cleanup together with locking cleanup.
>
> It's probably going to cause some issues for some people, but their code
> was wrong before, they were just "lucky".
>
> I believe it will make the code slightly faster and also solve some rare
> bugs, often NREs from finalizer 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.sourceforge.net/lists/listinfo/firebird-net-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

[Gerdus van Zyl]

SharpZipLib looks to be more actively maintained and with clearer and more
permissive licensing. It's a dependency of most of my project anyway so I
would not mind it.
An alternative to an external dependency is an intree copy with unnecesary
bits(eg. bzip2,tar) removed.

Out of curiosity why is DeflateStream/GZipStream not enough?

On Mon, Jun 20, 2016 at 6:57 PM, Jiří Činčura  wrote:

> Hi *,
>
> Other topic to think about. The compression is Firebird is based on zlib
> compression. That one is not in the framework. So unless somebody
> contributes solid and proven implementation, when and if the compression
> will make it to master, I'd have to introduce dependency. Maybe some sort
> of optional.
>
> I successfully tested zlib from Ionic and SharpZipLib libraries.
>
> Discuss… ;)
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> --
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning
> reports. http://sdm.link/zohomanageengine
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 

Gerdus van Zyl
www.infireal.com
--
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

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
s.DatabaseShutdown(FbShutdownMode.Forced, 1) 'aborts all connections and
transactions, 1 second timeout

'Copy File,etc

s.DatabaseOnline() 'bring database online again

But if you want to make a backup... FbBackup is of course much better and
safer.
Dim bkp As New FbBackup()
bkp.BackupFiles.Add(New FbBackupFile(bkpfn, Nothing))
bkp.ConnectionString = constr

bkp.Options = FbBackupFlags.IgnoreLimbo + FbBackupFlags.Expand

'so that program blocks till complete
bkp.Verbose = True
AddHandler bkp.ServiceOutput, Sub(sender As Object, e As
ServiceOutputEventArgs)

  End Sub
RaiseEvent BackupProgressEvent(String.Format("{0}: Creating
Database Backup...", database.DatabaseName), 0)
bkp.Execute()


On Tue, Feb 2, 2016 at 8:26 AM, SUKHEN DASS  wrote:

> its a single user application which only i am using and i am using
> this code before IO.File.Replace is being called... which i forgot to
> include in the code
> For iLoop = 0 To 100
> Application.DoEvents()
> Next
>
>
> On Tuesday, February 2, 2016 11:28 AM, Jiří Činčura 
> wrote:
>
>
> Calling `FbConnection.ClearAllPools` is enough. You don't have to call
> anything else. Though you might give server few ms to release the file -
> it's not guaranteed that closing all connections will immediately
> release the file.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

Sounds like troubles I had when I still used datasets. If possible try
using EF or something else.
Try removing the Role=; part I have in the past had problems with that when
using the visual studio components.
Also try reinstalling Firebird DDEX Provider for Visual Studio.

On Mon, Sep 21, 2015 at 4:01 PM, Heine Ferreira 
wrote:

> Hi,
>
> I am using visual studio 2013 community edition on windows 7 prof.
> with service pack 1.
> My firebird is the latest firebird with the latest dot net provider
> and the latest plugin for visual studio. I am not sure whether my
> firebird is superserver or superclassic.
> It definately isn't classic or embedded.
>
> When I try the connection string below in visual studio I get the
> error that follows:
>
>
> User=SYSDBA;Password=masterkey;Database=c:\employee.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;
> Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;
> Packet Size=8192;ServerType=0;
>
> Failure has occurred while loading a type.
>
> What does this mean and how can I fix it?
>
> Thanks
>
> Heine Ferreira
>
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-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] Sample 3. Firebird events [v1.7] inhttp://www.firebirdsql.org/en/net-examples-of-use/

[Gerdus van Zyl]

Sorry it seems the converter is not translating the event binding correct
or maybe for more recent version of VB.

Anyway instead of
revent.RemoteEventCounts += New FbRemoteEventEventHandler(AddressOf
EventCounts)

use this:
*AddHandler revent.RemoteEventCounts, New
FbRemoteEventEventHandler(AddressOf EventCounts) *



On Wed, Mar 4, 2015 at 5:05 PM,  wrote:

>   Dearest,
>
> I had already tried this option. I should have put in the email. Does not
> work because the "RemoteEventCounts" does not exist for Visual Basic. There
> is the "RemoteEventId as Integer" option. I am, 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 
> *Sent:* Wednesday, March 04, 2015 6:56 AM
> *To:* For users and developers of the Firebird .NET providers
> 
> *Subject:* Re: [Firebird-net-provider] Sample 3. Firebird events [v1.7]
> inhttp://www.firebirdsql.org/en/net-examples-of-use/
>
>  Just run the code through telerik code converter here:
> http://converter.telerik.com/
>
> On Wed, Mar 4, 2015 at 3:06 AM,  wrote:
>
>>   Hi,
>>
>> The sample noted is writed in C# and work fine. I’m try in VS 2013
>> Desktop Express.
>>
>> To make it clear, I join it here...
>> static void Main(string[] args)
>> {
>> FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
>> cs.DataSource = "localhost";
>> cs.Database = "employee.fdb";
>> cs.UserID = "SYSDBA";
>> cs.Password = "masterkey";
>> cs.Charset = "NONE";
>> cs.Pooling = false;
>>
>> FbConnection connection = new FbConnection(cs.ToString());
>> connection.Open();
>>
>> FbRemoteEvent revent = new FbRemoteEvent(connection);
>> revent.AddEvents(new string[] { "new_order" });
>>
>> // Add callback to the Firebird events
>> revent.RemoteEventCounts += new FbRemoteEventEventHandler(EventCounts);
>>
>> // Queue events
>> revent.QueueEvents();
>>
>> string sql = "INSERT INTO SALES (PO_NUMBER, CUST_NO, SALES_REP,
>> ORDER_STATUS, " +
>> "ORDER_DATE, SHIP_DATE, DATE_NEEDED, PAID, QTY_ORDERED, TOTAL_VALUE, " +
>> "DISCOUNT, ITEM_TYPE) VALUES (@po_number, 1004, 11, 'new', " +
>> "'1991-03-04 00:00:00', '1991-03-05 00:00:00', NULL, 'y', 10, 5000, " +
>> "0.10001490116, 'hardware');";
>>
>> FbCommand command = new FbCommand(sql, connection);
>> command.Parameters.Add("@po_number", FbDbType.Char, 8);
>>
>> for (int i = 360; i < 365; i++)
>> {
>> command.Parameters[0].Value = "V91E0" + i.ToString();
>> command.ExecuteNonQuery();
>> }
>>
>> System.Threading.Thread.Sleep(2000);
>> connection.Close();
>> }
>>
>> static void EventCounts(object sender, FbRemoteEventEventArgs args)
>> {
>> Console.WriteLine("Event {0} has {1} counts.", args.Name, args.Counts);
>> }
>>
>> My need: A sample writer in Visual Basic .Net (VB.NET). Sameone can put
>> a answer for me? Tanks a lot.
>>
>> Paulo Cezar Altafin .·.
>> Cambé - Pr - Brasil
>>
>>
>> --
>> Dive into the World of Parallel Programming The Go Parallel Website,
>> sponsored
>> by Intel and developed in partnership with Slashdot Media, is your hub
>> for all
>> things parallel software development, from weekly thought leadership
>> blogs to
>> news, videos, case studies, tutorials and more. Take a look and join the
>> conversation now. http://goparallel.sourceforge.net/
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>>
>
>
> --
>  
> 
> Gerdus van Zyl
> www.infireal.com
>
> --
>
> --
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorial

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

[Gerdus van Zyl]

Just run the code through telerik code converter here:
http://converter.telerik.com/

On Wed, Mar 4, 2015 at 3:06 AM,  wrote:

>   Hi,
>
> The sample noted is writed in C# and work fine. I’m try in VS 2013 Desktop
> Express.
>
> To make it clear, I join it here...
> static void Main(string[] args)
> {
> FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
> cs.DataSource = "localhost";
> cs.Database = "employee.fdb";
> cs.UserID = "SYSDBA";
> cs.Password = "masterkey";
> cs.Charset = "NONE";
> cs.Pooling = false;
>
> FbConnection connection = new FbConnection(cs.ToString());
> connection.Open();
>
> FbRemoteEvent revent = new FbRemoteEvent(connection);
> revent.AddEvents(new string[] { "new_order" });
>
> // Add callback to the Firebird events
> revent.RemoteEventCounts += new FbRemoteEventEventHandler(EventCounts);
>
> // Queue events
> revent.QueueEvents();
>
> string sql = "INSERT INTO SALES (PO_NUMBER, CUST_NO, SALES_REP,
> ORDER_STATUS, " +
> "ORDER_DATE, SHIP_DATE, DATE_NEEDED, PAID, QTY_ORDERED, TOTAL_VALUE, " +
> "DISCOUNT, ITEM_TYPE) VALUES (@po_number, 1004, 11, 'new', " +
> "'1991-03-04 00:00:00', '1991-03-05 00:00:00', NULL, 'y', 10, 5000, " +
> "0.10001490116, 'hardware');";
>
> FbCommand command = new FbCommand(sql, connection);
> command.Parameters.Add("@po_number", FbDbType.Char, 8);
>
> for (int i = 360; i < 365; i++)
> {
> command.Parameters[0].Value = "V91E0" + i.ToString();
> command.ExecuteNonQuery();
> }
>
> System.Threading.Thread.Sleep(2000);
> connection.Close();
> }
>
> static void EventCounts(object sender, FbRemoteEventEventArgs args)
> {
> Console.WriteLine("Event {0} has {1} counts.", args.Name, args.Counts);
> }
>
> My need: A sample writer in Visual Basic .Net (VB.NET). Sameone can put a
> answer for me? Tanks a lot.
>
> Paulo Cezar Altafin .·.
> Cambé - Pr - Brasil
>
>
> --
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


-- 

Gerdus van Zyl
www.infireal.com
--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

The default for ConnectionLifeTime is 0 and thus connections are never
released/closed if pooling is enabled.
Try setting ConnectionLifeTime to 60 (is in seconds) and you might get
results more inline with what you expect.

On Tue, Jan 27, 2015 at 2:42 PM, Nicolas F. Timmers 
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:* For users and developers of the Firebird .NET providers
> *Assunto:* 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 
> wrote:
>
> I think probably the application pool is not running again for this case
> see
> I have.
>
> A customer connected early on the database but is not used more for the day
> and the next morning the error occurred and that the firebird was only
> stopped night, I believe that the application pool is being never
> finalized.
>
>
>
>
> --
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is
> your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


-- 

Gerdus van Zyl
www.infireal.com
--
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

What is the values on your connection string for
ConnectionLifeTime
and
MinPoolSize
?

On Tue, Jan 27, 2015 at 1:57 PM, Nicolas F. Timmers 
wrote:

> I think probably the application pool is not running again for this case
> see
> I have.
>
> A customer connected early on the database but is not used more for the day
> and the next morning the error occurred and that the firebird was only
> stopped night, I believe that the application pool is being never
> finalized.
>
--
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

The msdn docs do state: "The connection pooler removes a connection from
the pool after it has been idle for a long time, *or if the pooler detects
that the connection with the server has been severed*."
So other database providers probably check periodically for broken
connections.

however the docs also say "If a connection exists to a server that has
disappeared, this connection can be drawn from the pool *even if the
connection pooler has not detected the severed connection and marked it as
invalid. *This is the case because the overhead of checking that the
connection is still valid would eliminate the benefits of having a pooler
by causing another round trip to the server to occur. *When this occurs,
the first attempt to use the connection will detect that the connection has
been severed, and an exception is thrown.*"

See attached patch(+ test program) that adds a connection check on idle
connections in the connection pool cleanup code that is run every 2 seconds
to remove old connections.
Even with the patch if the server goes away between checks you can still
get a broken connection as is the case with other database providers.

This does cause a small network request for each idle connection in the
pool every 2 seconds so don't know if this patch would be suitable for
public use.

On Mon, Jan 26, 2015 at 3:32 PM, Luciano Mendes  wrote:

> Let me copy, once again, the source code of the SW that is not work. Note
> the
> I am always open the Polling connection according the documentation (
> https://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.100).aspx ) and it
> was broken since the version 4.6.0.0:
>
> ===
> using FirebirdSql.Data.FirebirdClient;
>
> public static bool ExecuteCommand(string DML)
> {
> using (FbConnection fbConnection = new
> FbConnection(connectionString()))
> using (FbCommand fbCommand = new FbCommand(DML, fbConnection))
> try
> {
> Cursor.Current = Cursors.WaitCursor;
> fbCommand.Connection.Open();
> fbCommand.ExecuteNonQuery();
> return true;
> }
> catch (FbException ex)
> {
> return false;
> }
> finally
> {
> Cursor.Current = Cursors.Default;
> }
> }
>
>
>
> --
> View this message in context:
> http://firebird.1100200.n4.nabble.com/Error-reading-data-from-the-connection-tp4638893p4638932.html
> Sent from the firebird-net-provider mailing list archive at Nabble.com.
>
>
> --
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is
> your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 

Gerdus van Zyl
www.infireal.com
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using FirebirdSql.Data.FirebirdClient;
using System.ServiceProcess;

namespace ConnectionPoolTest
{
class Program
{

static void StopFirebirdService()
{
var sc = new ServiceController("FirebirdServersifirebird");
Console.WriteLine("Stopping...");
sc.Stop();
sc.WaitForStatus(ServiceControllerStatus.Stopped);
Console.WriteLine("Stopped");
}

static void StartFirebirdService()
{
var sc = new ServiceController("FirebirdServersifirebird");
Console.WriteLine("Starting...");
sc.Start();
sc.WaitForStatus(ServiceControllerStatus.Running );
Console.WriteLine("Started");
}

static void Main(string[] args)
{
Console.WriteLine("[Connection pool test]");

var csb = new FbConnectionStringBuilder();
csb.DataSource = "localhost";
csb.Port = 55504;
csb.Database  = "pooltest.fdb";
csb.UserID = "SYSDBA";
csb.Password = "masterke";
csb.Pooling = true;
csb.MinPoolSize = 0;
   

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

[Gerdus van Zyl]

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.



--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

ClearAllPools should not close/dispose open connections.
A function to close all pooled connections might be useful however for when
you need to close all connections maybe with different name like
CloseAllPooledConnections


On Wed, Apr 17, 2013 at 10:29 AM, Jiri Cincura  wrote:

> Hi *,
>
> I just found behavior that surprised me. Suppose pooling is on and
> (all connections to same database):
> Open connection1.
> Open connection2.
> Close connection2.
> FbConnection.ClearAllPools();
> Try to use connection1.
>
> On this ^ line you'll get exception as the connection1 was also
> cleared aka closed/disposed. I always used ClearAllPools with all
> connections closed so I had no idea it behaves like that.
>
> But do you think is correct? Should the ClearAllPools clear even the
> opened connections?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> 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
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] fbbackup

[Gerdus van Zyl]

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)

  End Sub


On Fri, Mar 22, 2013 at 1:30 PM, Nicolas Timmers wrote:

> Hello everyone
>
> I have a question,  when using the fbbackup on .net have a way to know if
> the backup was completely sucesfull???
>
> And wirh fbreatore??
>
> Enviado pelo meu Windows Phone
>
>
> --
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Help with retrieving/binding image from database

[Gerdus van Zyl]

Blob sub_type 1 is Text. sub_type 0 is binary. That is why you are getting
a string from the database.
see http://www.firebirdfaq.org/faq165/

On Fri, Nov 2, 2012 at 2:32 PM, Mr. John  wrote:

> Hi !
>  I'm using VB.2008 with FB 2.5/,Net provider version 2.7.7.0
>
> I want  to save and retrieve/bind image from/to picture box control
>
> image database field :
>  F_IMAG  BLOB SUB_TYPE 1 SEGMENT SIZE 4096
>
> saving to database :
> 
>  Dim IMG As New Bitmap(PictureBox1.Image)
> Dim stream As New IO.MemoryStream
> IMG.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg)
> .Add("@pimg", FbDbType.Binary).Value = stream.ToArray()
> 
>  no error here
>
> but I got this error :
>   Unable to cast object of type 'System.String' to type 'System.Byte[]'.
> when I try to retrieving/binding image with this code :
>
>   Dim WithEvents bind As Binding
> .
> bind = New Binding("Image", bSource_, "F_IMAG")
> Me.PictureBox1.DataBindings.Add(bind)
>
> .
>
> Private Sub Binding_Format(ByVal sender As System.Object, ByVal e As
> ConvertEventArgs) Handles bind.Format
> Dim img As Byte()
> img = CType(e.Value, Byte())   'Unable to cast object of type
> 'System.String' to type 'System.Byte[]'.
>
> If (Not img Is Nothing) Then
> e.Value = Image.FromStream(New System.IO.MemoryStream(img))
> End If
> End Sub
>
>
> thanks for any help !
>
>
>
> --
> LogMeIn Central: Instant, anywhere, Remote PC access and management.
> Stay in control, update software, and manage PCs from one command center
> Diagnose problems and improve visibility into emerging IT issues
> Automate, monitor and manage. Do more in less time with Central
> http://p.sf.net/sfu/logmein12331_d2d
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
--
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Database triggers

[Gerdus van Zyl]

Well suppressTriggers is not something you would routinely use so I think
it should bypass connection pooling.

On Tue, Apr 17, 2012 at 8:00 AM, Jiri Cincura  wrote:

> And there's another one. What about connection pooling? :)
>
> The pool is currently based on connection string. So if you open
> connection with .Open(suppressTrigger: true) and later call
> .Open(suppressTriggers: false) you'll get wrong behavior. I can extend
> the pool to take into account this "special" settings, but even that,
> if you do .Open(suppressTriggers: false) and then again
> .Open(suppressTriggers: false), the trigger will be actually invoked
> only once. :\ Seems to me like hidden magic.
>
> Ideas?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Better than sec? Nothing is better than sec when it comes to
> monitoring Big Data applications. Try Boundary one-second
> resolution app monitoring today. Free.
> http://p.sf.net/sfu/Boundary-dev2dev
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Database triggers

[Gerdus van Zyl]

On Mon, Apr 16, 2012 at 3:11 PM, Jiri Cincura  wrote:
> On Wed, Apr 11, 2012 at 1:37 PM, Gerdus van Zyl  
> wrote:
>> I would prefer it on the FbConnection.Open method.
>> It would then be like transaction options and
>> Connection.BeginTransaction. The connection string thus remains
>> uncomplicated.
>
> OTOH the default (generic) isolation level can be specified in
> connection string as well. :\
>

I know. But to set a custom isolation level and wait timeout (what I
always do) you need to use the options on BeginTransaction.

~G

--
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Working with transactions

[Gerdus van Zyl]

The way I solve it in my code is to create a class that manages
database connection,transactions and commands: eg. DatabaseContext
pseudo code:
context.begin_transaction() // opens connection, starts transaction
context.runsql(sql)  // creates command using current connection and transaction
context.commit_transaction() // commits transaction, closes connection

You then pass around the database context class instead of the
database connection.
In Firebird everything has a transaction even if it's created by the
.net driver transparently in background, so it's better to always have
an explicit transaction in your code, makes for fewer surprises.

~Gerdus

On Wed, Apr 11, 2012 at 9:59 AM, Russell Rose  wrote:
> I was wondering if there was any way to determine if there is a pending
> transaction outstanding.  I have a single connection to a database and have
> something like the following code:
>
>
>
> FbConnection conn;
>
> FBCommand cmd = conn.CreateCommand();;
>
> cmd.Transaction = conn.BeginTransaction();
>
>
>
> I then call another generic routine which starts up a new command:
>
> Cmd2 = conn.CreateCommand();
>
>
>
> I get the following error:
>
> Execute requires the Command object to have a Transaction object when the
> Connection object assigned to the command is in a pending local transaction.
> The Transaction property of the Command has not been initialized.
>
>
>
> The 2nd routine is sometimes called when there is a pending transaction and
> sometimes not.
>
>
>
>
> --
> Better than sec? Nothing is better than sec when it comes to
> monitoring Big Data applications. Try Boundary one-second
> resolution app monitoring today. Free.
> http://p.sf.net/sfu/Boundary-dev2dev
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

--
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Database triggers

[Gerdus van Zyl]

I would prefer it on the FbConnection.Open method.
It would then be like transaction options and
Connection.BeginTransaction. The connection string thus remains
uncomplicated.

On Wed, Apr 11, 2012 at 10:42 AM, Jiri Cincura  wrote:
> Hi *,
>
> I started working on option to disable database triggers (DNET-312)
> when connecting to database. But I'm not sure how to expose it in API.
> I thought about
> A) in connection string
> B) in FbConnection.Open method
>
> The connection string seems to me to be more ADO.NET-ish way, though
> the Open method seems to be more current and convenient.
>
> What do you think?
>
> PS: No, both ways are IMO overkill. :)
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
> --
> Better than sec? Nothing is better than sec when it comes to
> monitoring Big Data applications. Try Boundary one-second
> resolution app monitoring today. Free.
> http://p.sf.net/sfu/Boundary-dev2dev
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl (JIRA)]

Connection pool cleanup timer is executed only once because timer is disposed 
in worker method
--

 Key: DNET-408
 URL: http://tracker.firebirdsql.org/browse/DNET-408
 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, FbConnectionTests.cs.patch

Expected: after connection pool timeout the connection is closed.
Reality: it is not. 

Connection pool cleanup timer is executed only once because timer is disposed 
in worker method

Patch to comment out the dispose:

Index: Data/FirebirdClient/FbConnectionPool.cs
===
--- Data/FirebirdClient/FbConnectionPool.cs (revision 53955)
+++ Data/FirebirdClient/FbConnectionPool.cs (working copy)
@@ -314,7 +314,7 @@
}
}

-   pool.cleanupTimer.Dispose();
+   //pool.cleanupTimer.Dispose();
}
}
 


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

I recommend using FbConnectionStringBuilder class and then inspecting
the resulting string.

Dim csb As New
FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder()
csb.Database = "C:/databases/server.fdb"
csb.UserID = "SYSDBA"
csb.Password = "badpassword"
csb.Pooling = False
csb.DataSource = "localhost"
Return csb.ToString()

On Thu, Dec 22, 2011 at 8:38 PM, Michael Powell  wrote:
> Hello,
>
> We're using the Firebird .NET provider and I want to build a connection
> string; of itself, connection string not so bad, however, I want to build
> one to a remote machine running the Firebird server. In which case I provide
> properties like: DataSource=? Port=?
> Database=?
>
> Thanks...
>
> Best regards,
>
> Michael
>
> --
> Write once. Port to many.
> Get the SDK and tools to simplify cross-platform app development. Create
> new or port existing apps to sell to consumers worldwide. Explore the
> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
> http://p.sf.net/sfu/intel-appdev
> ___
> 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 once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create 
new or port existing apps to sell to consumers worldwide. Explore the 
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

http://blog.cincura.net/227021-firebird-net-provider-and-calling-stored-procedures-with-parameters/

and

http://www.lmgtfy.com/?q=stored+procedure+ado.net+firebird

On Mon, Oct 31, 2011 at 7:54 AM, Alexander Muylaert
 wrote:
> 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 Firebird stored procedure from
> ASP.NET
>
> How to execute a Firebird stored procedure from ASP.NET application?
> I have VS2010. Sucessfully can over SQLDataSource connect and do queries.
>
> please provide a code sample.
> thanks.
>
>
>
> 
> --
> Get your Android app more play: Bring it to the BlackBerry PlayBook in
> minutes. BlackBerry App World™ now supports Android™ Apps for the
> BlackBerry® PlayBook™. Discover just how easy and simple it is!
> http://p.sf.net/sfu/android-dev2dev
>
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> --
> Get your Android app more play: Bring it to the BlackBerry PlayBook
> in minutes. BlackBerry App World™ now supports Android™ Apps
> for the BlackBerry® PlayBook™. Discover just how easy and simple
> it is! http://p.sf.net/sfu/android-dev2dev
> ___
> 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

--
Get your Android app more play: Bring it to the BlackBerry PlayBook 
in minutes. BlackBerry App World™ now supports Android™ Apps 
for the BlackBerry® PlayBook™. Discover just how easy and simple 
it is! http://p.sf.net/sfu/android-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

I have set Pooling = True and ConnectionLifeTime = 10 in my connection
string.
The expected result would be that 10 seconds after the connection is last
used the connection is closed.
Unfortunately looking at the connections using Database Workbench the
connection seems to stay open till program termination.

Having looked at the source code I see a timer and it's associated callback
that implements this functionality in FbConnectionPool.cs.
Setting a breakpoint in the callback CleanupWorker it's only called once and
then never again.
The line:
pool.cleanupTimer.Dispose();
seems 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
--
Storage Efficiency Calculator
This modeling tool is based on patent-pending intellectual property that
has been used successfully in hundreds of IBM storage optimization engage-
ments, worldwide.  Store less, Store more with what you own, Move data to 
the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

It is because you did not commit the transaction.
e.g fbCommand1.Transaction.Commit()

On Sun, May 29, 2011 at 1:40 PM, wiwian  wrote:
> Hi
> Why this don't write nothing to the base in C# express 2010 &
> NetProvider 2.6?
>
>         private void button2_Click(object sender, EventArgs e)
>         {
>             fbConnection1.Open();
>             fbCommand1.Transaction = fbConnection1.BeginTransaction();
>             fbCommand1.CommandText = "INSERT INTO TEST (NUMER, TEKST,
> DATA) VALUES ('NUMER','TEKST','DATA')";
>             fbCommand1.ExecuteNonQuery();
>             fbConnection1.Close();
>         }
>
> Best Regards
> Piotr
>
>
>
>
> 
> Najtansze samochody w Polsce!
> Odwiedz >> http://linkint.pl/f29ab
>
> --
> vRanger cuts backup time in half-while increasing security.
> With the market-leading solution for virtual backup and recovery,
> you get blazing-fast, flexible, and affordable data protection.
> Download your free trial now.
> http://p.sf.net/sfu/quest-d2dcopy1
> ___
> 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

--
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery, 
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now. 
http://p.sf.net/sfu/quest-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] help

[Gerdus van Zyl]

Have you installed FirebirdClient into the GAC:
gacutil /i FirebirdSql.Data.FirebirdClient.dll

and edited the reg files before merging with the path to the DataTools
dll files?
eg:
"CodeBase"="C:\\src\\external-dependencies\\FirebirdDDEXProvider\\FirebirdSql.VisualStudio.DataTools.dll"

2011/4/5 Eduardo Cimas :
> Spanish:
>
> Hola!
>
> Estoy intentando configurar VS2008 y VS2010 para trabajar con Firebird y
> siguiendo todos los pasos y al añadir una conexion con servidor me salta el
> siguiente error :
>
> No se puede cargar el archivo o ensamblado 'file:///C:\Archivos de
> programa\Microsoft Visual Studio
> 10.0\Common7\IDE\FirebirdSql.VisualStudio.DataTools.dll' ni una de sus
> dependencias. Se esperaba que el modulo tuviera un manifiesto de ensamblado.
>
> Probe instalando el Firebird Client 2.1 y ese error, con el NETPROVIDER 2.6
> el mismo error. Las dos lineas agregadas en el machine.config son estas:
>
>  System.Data, Version=2.0.0.0, Culture=neutral,
> PublicKeyToken=b77a5c561934e089" />
>
>  Provider" invariant="FirebirdSql.Data.FirebirdClient"description=".Net
> Framework Data Provider for
> Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
> FirebirdSql.Data.FirebirdClient, Version=2.1.0.0, Culture=neutral,
> PublicKeyToken=3750abcc3150b00c" />
>
> He copiado FirebirdSql.VisualStudio.DataTools.dll y
> FirebirdSql.VisualStudio.DataToolsUI.dll en la misma ruta y sigue sin
> funcionar.
>
> Confio en que esto se pueda solucionar. Muchas gracias por adelantado.
>
> Eduardo Cimas.
>
> 
>
> English:
>
> Hi!
>
> Im trying to configure VS2008 and VS2010 to work with Firebird following all
> the steps and when I try to add a new connection I have this error:
>
> No se puede cargar el archivo o ensamblado 'file:///C:\Archivos de
> programa\Microsoft Visual Studio
> 10.0\Common7\IDE\FirebirdSql.VisualStudio.DataTools.dll' ni una de sus
> dependencias. Se esperaba que el modulo tuviera un manifiesto de ensamblado.
>
> I tryed installing Firebird Client 2.1 and the error continues, with
> NETPROVIDER 2.6 and the error continues. The two lines I have added in
> machine.config are there:
>
>  System.Data, Version=2.0.0.0, Culture=neutral,
> PublicKeyToken=b77a5c561934e089" />
>
>  Provider" invariant="FirebirdSql.Data.FirebirdClient"description=".Net
> Framework Data Provider for
> Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
> FirebirdSql.Data.FirebirdClient, Version=2.1.0.0, Culture=neutral,
> PublicKeyToken=3750abcc3150b00c" />
>
> I have copied FirebirdSql.VisualStudio.DataTools.dll and
> FirebirdSql.VisualStudio.DataToolsUI.dll in the same path and the error
> continues.
>
> I hope it can be soluted. Thank you very much for all you can do.
>
> Eduardo Cimas.
>
> 
>
> PD: Im spanish / Soy español.
>
> --
> Xperia(TM) PLAY
> It's a major breakthrough. An authentic gaming
> smartphone on the nation's most reliable network.
> And it wants your games.
> http://p.sf.net/sfu/verizon-sfdev
> ___
> 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

--
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Is there a way to check if a database exists?

[Gerdus van Zyl]

I think catching the exception is the proper way. If the database is on the
same machine you can of course just check if the file exists directly.

you may want to differentiate based on the message in the exception like
this:

Catch ex As Exception
If ex.Message.Contains("Error while trying to open file") Then
msgboxExclaim(String.Format("Error while opening database
file - file probably does not exist" & vbCrLf & vbCrLf & "{0}", ex.Message))

ElseIf ex.Message.Contains("The operation has timed out") Then
msgboxExclaim("Operation Timed out - Please try to Log In
again.")

Else
msgboxExclaim(ex.Message)
End If

On Mon, Jan 24, 2011 at 10:28 AM, Marc Bettex  wrote:

> Hi,
>
> I would like to know if there is a proper way to check if a given database
> exists with the Firebird .Net provider.
>
> Currently, I try to open a connection to the database, and if this fails by
> throwing an exception, I assume that this is because the database does not
> exist. But that's not a solution I feel comfortable with, because there
> might be other reason for the exceptions to be thrown. So, is there a
> better
> way to do it?
>
> Thank you,
> Marc
>
>
>
> --
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better
> price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
> ___
> 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
--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

I don't think you can pass a column name as a parameter. If I execute
the same query using Database Workbench I also get "Dynamic SQL Error
SQL error code = -804 Data type unknown" error so it must be
limitation of firebird database.

It would in any case not be any faster since I don't think the
database can prepare and reuse the query where the columns change.

On Thu, Aug 26, 2010 at 12:04 PM, Matej Golob  wrote:
> I have problem when I use parameters and compare parameter value with null.
> I've create simple snipet code, which represents problem:
>
>
>
> FbCommand com = connection.CreateCommand;
> com.CommandText = "select * from rdb$database wher...@n0 is null";;
> FbParameter par = new FbParameter("n0", FbDbType.VarChar);
> par.Value = "a";
> com.Parameters.Add(par);
> var reader = com.ExecuteReader();
>
>
>
> No mather what value is, If I execute this I get error:  Invalid data type.
>
> If I do »same« with literals (»SELECT * from rdb$database where 'a'
> is null«) of course everything works fine, so I assume there should be
> problem in provider.
>
>
>
> Thanks for help.
>
>
>
> Matej
>
> --
> Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
> Be part of this innovative community and reach millions of netbook users
> worldwide. Take advantage of special opportunities to increase revenue and
> speed time-to-market. Join 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

--
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users 
worldwide. Take advantage of special opportunities to increase revenue and 
speed time-to-market. Join 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

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

[Gerdus van Zyl]

see 
http://www.firebirdsql.org/dotnetfirebird/firebird-and-dotnet-framework-data-types-mapping.html

On Wed, Aug 18, 2010 at 10:22 PM, Steve Boyd  wrote:
> Is there some place I can find the type of .Net Object returned by
> FbDataReader.GetValue for each native Firebird data type?  For example,
> Varchar returns a String but other data types (especially the numeric types)
> don't appear to be that obvious.  I've tried looking in the source but all
> that C# is too opaque for a Delphi programmer like me.
>
> Your help is appreciated.
>
> Thank You
>
>
> --
> This SF.net email is sponsored by
>
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev
> ___
> Firebird-net-provider mailing list
> Firebird-net-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 Challenge
http://p.sf.net/sfu/RIM-dev2dev 
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

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  wrote:
> Thanks Jiri, but I'm using XP not Vista.
>
> Peter Gore
> Intel Systems Manager
> (ddi) 01277 376433
> (swb) 01277 372916
> (mob) 07891 911989
>
> -Original Message-
> From: Jiri Cincura [mailto:disk...@cincura.net]
> Sent: 30 June 2010 09:12
> To: For users and developers of the Firebird .NET providers
> Subject: Re: [Firebird-net-provider] the NETProvider- Install Failed
>
> On Wed, Jun 30, 2010 at 09:58, Peter Gore 
> wrote:
>>
>> The error code is 2869
>
> http://blogs.x2line.com/al/archive/2007/07/20/3210.aspx
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
> 
> --
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
> __
> Martin McColl Ltd, Ashwells Road, Brentwood, Essex CM15 9ST
>
> This e-mail including any attachments is intended only for the addressee
> named above and it may contain confidential or privileged information
> If you are not the intended recipient please notify the sender and note
> that the contents must not be disclosed to anyone else, no copies can be
> taken and all existing copies must be destroyed
> Martin McColl Ltd will not be liable for any error in transmission
> You should carry out your own virus checks before opening any attachments.
> Opinions, conclusions and other information in this message
> and attachments that do not relate to the official business
> of Martin McColl Ltd are neither given nor endorsed by it
>
> --
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl]

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  wrote:
> On Sat, Jun 12, 2010 at 02:54, will ferguson
>  wrote:
>> I'm a local admin. But I notice the permissions on this file are locked 
>> down.  "Trusted Installer" account has full control rights though?? Any 
>> thoughts
>
> UAC?
>
> --
> Jiri {x2} Cincura (CTO x2develop.com)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
> --
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit.  See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

--
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Gerdus van Zyl (JIRA)]

Null reference exception on fbcommand dispose
-

 Key: DNET-316
 URL: http://tracker.firebirdsql.org/browse/DNET-316
 Project: .NET Data provider
  Issue Type: Bug
  Components: ADO.NET Provider
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 calling .Dispose() on all 
FbCommands created (I now put fbcommand object in a list and dispose of 
manually before connection close). Which is strange since I can't see where I 
keep die commands alive beyond the life of the connection. The part of my 
program which gives the problem is a database schema upgrade that runs in a 
background thread.

Object reference not set to an instance of an object.

stack trace: 
   at 
FirebirdSql.Data.FirebirdClient.FbConnectionInternal.RemovePreparedCommand(FbCommand
 command)
   at FirebirdSql.Data.FirebirdClient.FbCommand.Release()
   at FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Finalize()

target site:
{Void RemovePreparedCommand(FirebirdSql.Data.FirebirdClient.FbCommand)}

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--

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

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

[Gerdus van Zyl]

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 USER_VIEWS_MAP ON USER_VIEWS_MAP.USER_ID = USER_INFOS.ID
WHERE
  USER_VIEWS_MAP.VIEW_ID = @viewid

Joins are normally much faster than IN SELECT because of better index use.

~Gerdus

On Thu, Apr 29, 2010 at 4:36 PM, Jiri Cincura  wrote:
> On Thu, Apr 29, 2010 at 15:30, korkless  wrote:
>> it's a bug or i'm doing samething wrong?
>
> You can't use a parameter there, as server isn't able to infer the
> type. Easiest way is to do there a cast.
>
> --
> Jiri {x2} Cincura (CTO x2develop.com)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

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

[Firebird-net-provider] Connect locally using xnet?

[Gerdus van Zyl]

How can I connect to a local server using a local protocol like xnet?

thank you

~Gerdus

--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider