[Firebird-net-provider] DbTransaction
Hello Currently I use in my system functionality FirebirdClientFactoryI do not call directly for example the component FBTransaction but the DBTransation and then the dll Firebird converts I would like my transaction utilizase the same options as the IBExpert uses that areisc_tpb_read_committedisc_tpb_rec_versionisc_tpb_nowait how could I pass these parameters in my system making use of DbTransaction? -- Keep yourself connected to Go Parallel: INSIGHTS What's next for parallel hardware, programming and related areas? Interviews and blogs by thought leaders keep you ahead of the curve. 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] DbTransaction
Hello Jiri OK, the only that doesn't match is the isc_tpb_nowait that in the Firebird Client will always be Wait right ? That exist even a possibilite to make a parameter in the web.config that change this setting ? > Date: Wed, 28 Nov 2012 12:54:58 +0100 > From: disk...@cincura.net > To: firebird-net-provider@lists.sourceforge.net > Subject: Re: [Firebird-net-provider] DbTransaction > > > how could I pass these parameters in my system making use of DbTransaction? > > You can't pass it explicitly. That's the price for abstraction. > > But. This matches IsolationLevel.ReadCommitted. Hence you can use this > or specify it in connection string. > > -- > Jiri {x2} Cincura (x2develop.com founder) > http://blog.cincura.net/ | http://www.ID3renamer.com > > -- > Keep yourself connected to Go Parallel: > INSIGHTS What's next for parallel hardware, programming and related areas? > Interviews and blogs by thought leaders keep you ahead of the curve. > http://goparallel.sourceforge.net > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Keep yourself connected to Go Parallel: INSIGHTS What's next for parallel hardware, programming and related areas? Interviews and blogs by thought leaders keep you ahead of the curve. 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] DbTransaction
Hello Jiri strange this was changes in last versions ? in the 2.7.7 is Wait Default Tanks > Date: Wed, 28 Nov 2012 14:45:09 +0100 > From: disk...@cincura.net > To: firebird-net-provider@lists.sourceforge.net > Subject: Re: [Firebird-net-provider] DbTransaction > > > OK, the only that doesn't match is the isc_tpb_nowait that in the Firebird > > Client will always be Wait right ? > > By default FbTransactionBehavior.NoWait. > > -- > Jiri {x2} Cincura (x2develop.com founder) > http://blog.cincura.net/ | http://www.ID3renamer.com > > -- > Keep yourself connected to Go Parallel: > INSIGHTS What's next for parallel hardware, programming and related areas? > Interviews and blogs by thought leaders keep you ahead of the curve. > http://goparallel.sourceforge.net > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Keep yourself connected to Go Parallel: INSIGHTS What's next for parallel hardware, programming and related areas? Interviews and blogs by thought leaders keep you ahead of the curve. 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] error from FB .Net Provider 3.0.2.0
Download the firebird client for .net 3.5 will solve Enviado pelo meu Windows Phone De: Debasmita choudhury Enviada em: 06/12/2012 08:26 Para: firebird-net-provider@lists.sourceforge.net Assunto: [Firebird-net-provider] error from FB .Net Provider 3.0.2.0 Hi Firiend, I am Debasmita. I am using .net 4.0 and now have updated with Fb .NetProvider 3.0.2.0. Now I am getting the error "Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute' from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'" And another issue is I am unable to access the Ajax controls in application. Can somebody guide me in this regard and help me with some solution. With Regards Debasmita Choudhury Associate Team Lead Dimari IT Services India Pvt. Ltd. -- LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] fbbackup
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
Re: [Firebird-net-provider] fbbackup
You are right tank youu Someone know hpw to performe a database shutdown and online ??? Enviado pelo meu Windows Phone De: Gerdus van Zyl Enviada em: 22/03/2013 09:19 Para: For users and developers of the Firebird .NET providers Assunto: 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) 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 > > <http://about.me/gerdus> -- 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] fbbackup
Tank you So doing the shutdown not necessary i need to call the clear pool right ? Because tje shitdown forced will close all connection be her from .net or othee? Enviado pelo meu Windows Phone De: Mark Rotteveel Enviada em: 22/03/2013 11:08 Para: For users and developers of the Firebird .NET providers Assunto: Re: [Firebird-net-provider] fbbackup On Fri, 22 Mar 2013 13:48:21 +, Scott Price wrote: > You shouldn't need to perform a server shut-down to perform a restore, > and do not need to ever to perform a backup, though it's up to you if > you choose to. What you would need to do is make sure all connections > to the database are closed. If you are using the .NET ADO.NET provider > only, you will by default probably be using connection pooling. As > such, you will likely need to have a call to > > FbConnection.ClearAllPools(); > > That should drop all connections from the local perspective. It will > not help with any other machines connected to the database however. > > After a short pause to let any kind of clean up that's required to > occur, you should be able to restore a database backup to that instance. Shutting down a database means that the Firebird server will not accept any connections for a specific database (or only accepts a single admin connection). Depending on the exact config you can even force the server to close existing connections. This is a much cleaner way than assuming that the manual work to close connections is sufficient, or that your applications is the only one to connect. You can use FbConfiguration (in FirebirdSql.Data.Services) to shutdown a database. Mark -- 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
[Firebird-net-provider] Fbshutdown
The dbshutdown command apears not to work with firebird 2.5.2 super classic aleays return the error service already open can someone help? 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
[Firebird-net-provider] Sweep
There is a method on firebord data provider to perform database sweep?? Enviado pelo meu Windows Phone-- Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Sweep
Perfect, tank you Enviado pelo meu Windows Phone De: Jiri Cincura Enviada em: 03/04/2013 07:08 Para: For users and developers of the Firebird .NET providers Assunto: Re: [Firebird-net-provider] Sweep On Wed, Apr 3, 2013 at 2:20 AM, Nicolas Timmers wrote: > There is a method on firebord data provider to perform database sweep?? Yes. Services namespace. FbValidationFlags.SweepDatabase flag. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Version 4.10 Download
Hello, the new version of .net data provider is not available to donwlonad on http://www.firebirdsql.org/en/additional-downloads/ -- 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
[Firebird-net-provider] CORE4563
Hello everyone With the release of version 2.5.7, we have the item Http://tracker.firebirdsql.org/browse/CORE-4563 Has been implemented, I would like to know if you will need modifications to .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
[Firebird-net-provider] RES: CORE4563
tanks -Mensagem original- De: Jiří Činčura [mailto:j...@cincura.net] Enviada em: segunda-feira, 20 de fevereiro de 2017 18:01 Para: firebird-net-provider@lists.sourceforge.net Assunto: Re: [Firebird-net-provider] CORE4563 It's linked to that ticket: http://tracker.firebirdsql.org/browse/DNET-726 . -- Mgr. Jiří Činčura Independent IT Specialist On Mon, Feb 20, 2017, at 19:40, Nicolas Timmers wrote: > Hello everyone > > With the release of version 2.5.7, we have the item > > Http://tracker.firebirdsql.org/browse/CORE-4563 > > Has been implemented, I would like to know if you will need > modifications to .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 -- 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
[Firebird-net-provider] RES: CORE4563
Hello, In the version of provider 4.10 we made a change to prevent the error of "Arithmetic overflow string truncation" What I did was the following I accessed the file "XdrStream.cs", I was looking for this part of the code Throw new IscException (new [] {IscCodes.isc_arith_except, IscCodes.isc_string_truncation}); And I applied a "substring" Svalue = svalue.Substring (0, param.CharCount); But I'm thinking of upgrading to version 5.7 but I no longer find the part of the code, Is very important this change because I have no feasibility to change the whole system where the parameters are passed to put the size of the field, is there a solution to this? -Mensagem original- De: Jiří Činčura [mailto:j...@cincura.net] Enviada em: segunda-feira, 20 de fevereiro de 2017 18:01 Para: firebird-net-provider@lists.sourceforge.net Assunto: Re: [Firebird-net-provider] CORE4563 It's linked to that ticket: http://tracker.firebirdsql.org/browse/DNET-726 . -- Mgr. Jiří Činčura Independent IT Specialist On Mon, Feb 20, 2017, at 19:40, Nicolas Timmers wrote: > Hello everyone > > With the release of version 2.5.7, we have the item > > Http://tracker.firebirdsql.org/browse/CORE-4563 > > Has been implemented, I would like to know if you will need > modifications to .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 -- 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
[Firebird-net-provider] RES: RES: CORE4563
Excuse me, Yes I tried to search I do not know why I did not find this part of the code, but thank you very much for having spent your time and for having responded with this part this is very useful for me and my company, With regard to the part of tidying up my code I do not understand the reason and maybe you could clarify to me, because I have applications in SQL Server and MySQL of which they do not need too, and in these the provider seems to do this operation, what would be the reason of not changing Does the provider already do this? What would be the impact? -Mensagem original- De: Jiří Činčura [mailto:j...@cincura.net] Enviada em: terça-feira, 21 de fevereiro de 2017 09:31 Para: For users and developers of the Firebird .NET providers Assunto: Re: [Firebird-net-provider] RES: CORE4563 > But I'm thinking of upgrading to version 5.7 but I no longer find the > part of the code, Did you at least try to grep the sources? It's like one second operation and easy result. It's in https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/Client/Managed/Version10/GdsStatement.cs#L778 . > Is very important this change because I have no feasibility to change > the whole system where the parameters are passed to put the size of > the field, is there a solution to this? I would strongly advice you to fix your code, instead of band-aiding sources. Your hack is very dangerous and you will eventually loose data. -- Mgr. Jiří Činčura Independent IT Specialist -- 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
[Firebird-net-provider] RES: ADO.NET provider 5.8.1.0
Hello Jiri When i try to open the solution from version 5.8.1.0 I get the fallowing message C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj : error : The default XML namespace of the project must be the MSBuild XML namespace. If the project is authored in the MSBuild 2003 format, please add xmlns="http://schemas.microsoft.com/developer/msbuild/2003"; to the element. If the project has been authored in the old 1.0 or 1.2 format, please convert it to MSBuild 2003 format. C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj And the solution cannot be open, how can I proceed ? -Mensagem original- De: Jiří Činčura [mailto:j...@cincura.net] Enviada em: quarta-feira, 5 de abril de 2017 03:13 Para: For users & developers of the Firebird .NET providers Cc: firebird-to...@yahoogroups.com; For discussion among Firebird Developers Assunto: [Firebird-net-provider] ADO.NET provider 5.8.1.0 More info: https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- 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
[Firebird-net-provider] RES: RES: ADO.NET provider 5.8.1.0
Got it, tanks -Mensagem original- De: Jiří Činčura [mailto:j...@cincura.net] Enviada em: quinta-feira, 6 de abril de 2017 08:40 Para: firebird-net-provider@lists.sourceforge.net Assunto: Re: [Firebird-net-provider] RES: ADO.NET provider 5.8.1.0 You need new csproj support, aka VS2017. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Thu, Apr 6, 2017, at 13:37, Nicolas Timmers wrote: > Hello Jiri > > When i try to open the solution from version 5.8.1.0 I get the > fallowing message > > C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\Fir > ebirdSql.Data.FirebirdClient_NET45.csproj > : error : The default XML namespace of the project must be the > MSBuild XML namespace. If the project is authored in the MSBuild 2003 > format, please add > xmlns="http://schemas.microsoft.com/developer/msbuild/2003"; to the > element. If the project has been authored in the old 1.0 or > 1.2 format, please convert it to MSBuild 2003 format. > C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\Fir > ebirdSql.Data.FirebirdClient_NET45.csproj > > > And the solution cannot be open, how can I proceed ? > > > -Mensagem original- > De: Jiří Činčura [mailto:j...@cincura.net] Enviada em: quarta-feira, 5 > de abril de 2017 03:13 > Para: For users & developers of the Firebird .NET providers > > Cc: firebird-to...@yahoogroups.com; For discussion among Firebird > Developers > Assunto: [Firebird-net-provider] ADO.NET provider 5.8.1.0 > > More info: > https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-fir > ebird-is-ready/ > . > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > -- > 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 -- 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