Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Jiri C. <di...@ci...> - 2014-06-03 10:59:23
|
On Tue, Jun 3, 2014 at 10:46 AM, Ivan Arabadzhiev
<int...@un...> wrote:
> Here's the restore function (in case it helps)
>
> using(io.FileStream BackupInputStream = new
> FileStream(BackUpPath,FileMode.Open)) {
> fbServer.FbStreamingRestore restore = new
> fbServer.FbStreamingRestore();
> restore.ConnectionString = getConnectionString(Host,
> User, Pass, Path, Port, 32767);
> SetRestoreOptions(Ovr, DeactivateIndexes, NoShadows,
> NoValidity, OneAtTime, UseAllSpace, PageSize, restore);
> restore.InputStream = BackupInputStream;
> restore.Execute();
> return true;
> }
>
> Using a PageSize of 4096 or 16384 (both don't work). Options are Replace and
> NoShadows (defaults, stuck since the end of time). I'm willing to help debug
It went fine for me: http://pastecode.org/index.php/view/f1bade8d
I used the same function as you did
http://pastecode.org/index.php/view/9d31bb53 , I only added writing
output. When it fails (you should be able to see it from output).
> if I can get my hands on sources :)
Sources are here
https://github.com/cincuranet/NETProvider/tree/streaming-backup .
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Ivan A. <int...@un...> - 2014-06-03 08:46:57
|
https://drive.google.com/file/d/0BxNlh1_CctC4NDhIRnh2VHBDbnM/edit?usp=sharing - it`s an empty database so "leaking" is not really an issue :) Here's the restore function (in case it helps) using(io.FileStream BackupInputStream = new FileStream(BackUpPath,FileMode.Open)) { fbServer.FbStreamingRestore restore = new fbServer.FbStreamingRestore(); restore.ConnectionString = getConnectionString(Host, User, Pass, Path, Port, 32767); SetRestoreOptions(Ovr, DeactivateIndexes, NoShadows, NoValidity, OneAtTime, UseAllSpace, PageSize, restore); restore.InputStream = BackupInputStream; restore.Execute(); return true; } Using a PageSize of 4096 or 16384 (both don't work). Options are Replace and NoShadows (defaults, stuck since the end of time). I'm willing to help debug if I can get my hands on sources :) 2014-06-03 8:50 GMT+03:00 Jiri Cincura <di...@ci...>: > On Mon, Jun 2, 2014 at 10:21 PM, Ivan Arabadzhiev > <int...@un...> wrote: > > Should anything be done to the stream apart from construction? Any > special > > modes or anything? > > Nope. It should just work. > > The restore is tricky 8-). It kept me 3x more time to do it than > backup. I'm wondering whether it's possible to put the backup > somewhere so I can try it? > > -- > Jiri {x2} Cincura > http://blog.cincura.net/ | http://www.ID3renamer.com > > > ------------------------------------------------------------------------------ > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Nieurig <ni...@ya...> - 2014-06-03 08:36:18
|
Hi folks, thank you, one more to develop the provider to FB. I use this in some projects without any trouble. But now: I got a virus-alarm by downloding the file a the given URL. GData means: NSIS.Application.InstallMonetizer.E (Engine B) What happend here? Best wishes Niels Am 02.06.2014 15:38, schrieb Jiri Cincura: > Hi, > > here's http://speedy.sh/wf5S6/provider.7z (very) rough cut on the > streaming backup/restore implementation. Look at FbStreamingBackup and > FbStreamingRestore classes. It's same as FbBackup/FbRestore with only > different being you need to provide backup/restore via > OutputStream/InputStream property. > > I did some small testing, but more is always welcome. > |
|
From: Jiri C. <di...@ci...> - 2014-06-03 05:50:19
|
On Mon, Jun 2, 2014 at 10:21 PM, Ivan Arabadzhiev
<int...@un...> wrote:
> Should anything be done to the stream apart from construction? Any special
> modes or anything?
Nope. It should just work.
The restore is tricky 8-). It kept me 3x more time to do it than
backup. I'm wondering whether it's possible to put the backup
somewhere so I can try it?
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Ivan A. <int...@un...> - 2014-06-02 20:21:08
|
Backup part works great :) Managed to backup a 18GB database (took about 2:30 hours by the VPN, so I consider it as stable as it gets). Restore, however keeps throwing FirebirdSql.Data.FirebirdClient.FbException (0x80004005): expected backup description record ---> expected backup description record at FirebirdSql.Data.Services.FbStreamingRestore.Execute() Tested with the StreamingBackup generated file and with one made by gbak - same thing. Currently restoring the StreamingBackup file (with gbak) - appears to be intact. Should anything be done to the stream apart from construction? Any special modes or anything? 2014-06-02 16:38 GMT+03:00 Jiri Cincura <di...@ci...>: > Hi, > > here's http://speedy.sh/wf5S6/provider.7z (very) rough cut on the > streaming backup/restore implementation. Look at FbStreamingBackup and > FbStreamingRestore classes. It's same as FbBackup/FbRestore with only > different being you need to provide backup/restore via > OutputStream/InputStream property. > > I did some small testing, but more is always welcome. > > -- > Jiri {x2} Cincura > http://blog.cincura.net/ | http://www.ID3renamer.com > > > ------------------------------------------------------------------------------ > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiri C. <di...@ci...> - 2014-06-02 14:07:37
|
Hi, here's http://speedy.sh/wf5S6/provider.7z (very) rough cut on the streaming backup/restore implementation. Look at FbStreamingBackup and FbStreamingRestore classes. It's same as FbBackup/FbRestore with only different being you need to provide backup/restore via OutputStream/InputStream property. I did some small testing, but more is always welcome. -- Jiri {x2} Cincura http://blog.cincura.net/ | http://www.ID3renamer.com |
|
From: Hennadii (JIRA) <tr...@fi...> - 2014-05-28 08:05:19
|
FirebirdSql.Data.UnitTests tests fail on fbembed x64 configuration
------------------------------------------------------------------
Key: DNET-556
URL: http://tracker.firebirdsql.org/browse/DNET-556
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Environment: Win8x64
Reporter: Hennadii
Assignee: Jiri Cincura
I had a couple of problems with unit-tests, when I changed configuration to used in our project: embedded x64 server.
I've fixed them in my environment, thought it will be interesting for you.
There are two main problem:
1. using ToInt32 on IntPtr in x64 causes Arithmetic overflow operation.
2. mixed datatypes in FbDataReader.
Url to commit on github:
https://github.com/zabulus/NETProvider/commit/da86038cc7b181e937a8fc5681a67bee30b2bb7a
--
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
|
|
From: Parzival <par...@gm...> - 2014-05-26 13:44:50
|
Hello,
I guess your question is directed to me - yes, I would like to test and can
offer a slot this week Thursday or in the next weekend.
Niko
-----Ursprüngliche Nachricht-----
Von: Jiri Cincura [mailto:di...@ci...]
Gesendet: Montag, 26. Mai 2014 15:22
An: For users and developers of the Firebird .NET providers
Betreff: Re: [Firebird-net-provider] fbBackup on remote Clients
Hi,
On Thu, May 1, 2014 at 7:38 PM, Parzival <par...@gm...> wrote:
> This leads to the question, if this function is on the roadmap for the
> .net provider. Jiri, can please comment on that?
I started work on this today. Would you be willing to do some testing before
release?
--
Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ |
http://www.ID3renamer.com
----------------------------------------------------------------------------
--
The best possible search technologies are now affordable for all companies.
Download your FREE open source Enterprise Search Engine today!
Our experts will assist you in its installation for $59/mo, no commitment.
Test it for FREE on our Cloud platform anytime!
http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiri C. <di...@ci...> - 2014-05-26 13:22:29
|
Hi,
On Thu, May 1, 2014 at 7:38 PM, Parzival <par...@gm...> wrote:
> This leads to the question, if this function is on the roadmap for the .net
> provider. Jiri, can please comment on that?
I started work on this today. Would you be willing to do some testing
before release?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2014-05-26 05:20:09
|
[ http://tracker.firebirdsql.org/browse/DNET-287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiri Cincura reopened DNET-287:
-------------------------------
As Firebird 2.5.2 there's a API for that - CORE-2666.
> FbBackup from remote machine
> ----------------------------
>
> Key: DNET-287
> URL: http://tracker.firebirdsql.org/browse/DNET-287
> Project: .NET Data provider
> Issue Type: New Feature
> Components: ADO.NET Provider
> Environment: Win, Linux, Remote computer
> Reporter: Balázs Csaba
> Assignee: Jiri Cincura
> Priority: Minor
>
> All user could use the backup method programatically what GBAK uses. GBAK can create backup from remote computer, but FbBackup cannot. It uses "only" services features.
--
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
|
|
From: Kevin S. <KSc...@du...> - 2014-05-13 09:58:49
|
Hello, i've still the following error. I've installed Win7 x64, VS2013 Pro and a Project with .NET 4.5.1. First i have add via nuget manualy the EntityFramework 5.0.0 and then Firebird ADO.NET Data Provider(no EF6). Change the App.config to: <?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> </configSections> <entityFramework> <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework"> <parameters> <parameter value="v12.0" /> </parameters> </defaultConnectionFactory> <providers> <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" /> </providers> </entityFramework> </configuration> Then i've try to add a ADO.NET Entity Data Model but if i try to generate it from a existing DB i can't find the provider. Ok, lets try a newer Version. Another Problem comes... First unsinstall EF5 and Provider and install EF 6.0.0.0(and a step later the 6.1.0.0) und Firebird for EF6. Ok now i can the the provider if i try to create a Model but if i click next the i get the error: http://stackoverflow.com/questions/21525490/firebird-ddex-3-0-1-with-vs2013-system-data-entity-core-mappingexception ist all up to date. Is it possible, that the bug still exists?! What should i do?? Mit freundlichen Grüßen / best regards / un cordial saludo / s pozdravem Kevin Schmitz Softwareentwickler / Software Developer XING _________________________________________________________________________________________________ Duvenbeck Unternehmensgruppe I Duvenbeck Consulting GmbH & Co. KG Ruhrallee 7I 46395 Bocholt P +49 2871 2192 470 I M +49 151 68940 470 | F +49 2871 2182 507 I ksc...@du... I www.duvenbeck.de Geschäftsführer: Thomas Wagschal I Amtsgericht Coesfeld HRB 9940 Wir arbeiten ausschließlich auf der Grundlage der Allgemeinen Deutschen Spediteur-Bedingungen (ADSp), jeweils neuste Fassung. DIESE BESCHRÄNKEN IN ZIFF. 23 ADSp DIE GESETZLICHE HAFTUNG FÜR GÜTERSCHÄDEN NACH § 431 HGB FÜR SCHÄDEN IM SPEDITIONELLEN GEWAHRSAM AUF EUR 5,00 JE KG. BEI MULITIMODALEN TRANSPORTEN UNTER EINSCHLUSS EINER SEEBEFÖRDERUNG AUF 2 SONDERZIEHUNGSRECHTE JE KG SOWIE DARÜBER HINAUS JE SCHADENFALL BZW. -EREIGNIS AUF EUR 1,0 BZW. 2,0 MIO. ODER 2 SONDERZIEHUNGSRECHTE JE KG, JE NACHDEM, WELCHER BETRAG HÖHER IST. Die Haftung des Luftfrachtspediteurs regelt sich nach dem Montrealer Übereinkommen (MÜ). DIESE HAFTUNG BESCHRÄNKT SICH BEI GÜTER- UND VERSPÄTUNGSSCHÄDEN NACH ARTIKEL 22 MÜ AUF 19 SONDERZIEHUNGSRECHTE JE KG BRUTTOMASSE, UNGEACHTET DER KLAUSEL GEM. ZIFFER 27 ADSp. Mit Auftragserteilung finden diese Bedingungen Anwendung. Für den internationalen Straßengüterverkehr gelten die Bedingungen der CMR. Die vollständigen ADSp finden Sie unter www.duvenbeck.de -----Ursprüngliche Nachricht----- Von: Jiri Cincura [mailto:di...@ci...] Gesendet: Donnerstag, 1. Mai 2014 21:23 An: For users and developers of the Firebird .NET providers Betreff: Re: [Firebird-net-provider] fbBackup on remote Clients On Thu, May 1, 2014 at 8:23 PM, Mark Rotteveel <ma...@la...> wrote: > You could always use the services API to create a backup on the > server, but since CORE-2666 it is also possible to stream the backup > to the client (or from the client to the server for restore). Good. As I thought. I was confused by the subject of this thread "remote clients" to be specific. :) Looks like it's time to implement it. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Bla B. (JIRA) <tr...@fi...> - 2014-05-13 09:57:35
|
FunctionReturnTableColumns
--------------------------
Key: DNET-555
URL: http://tracker.firebirdsql.org/browse/DNET-555
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.1.5.0
Environment: Windows 7 x64, VS2013 Pro, Project with .NET 4.5.1
Reporter: Bla Bla
Assignee: Jiri Cincura
Priority: Blocker
i've still the following error. I've installed Win7 x64, VS2013 Pro and a Project with .NET 4.5.1.
First i have add via nuget manualy the EntityFramework 5.0.0 and then Firebird ADO.NET Data Provider(no EF6).
Change the App.config to:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
<parameters>
<parameter value="v12.0" />
</parameters>
</defaultConnectionFactory>
<providers>
<provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />
</providers>
</entityFramework>
</configuration>
Then i've try to add a ADO.NET Entity Data Model but if i try to generate it from a existing DB i can't find the provider.
Ok, lets try a newer Version. Another Problem comes...
First unsinstall EF5 and Provider and install EF 6.0.0.0(and a step later the 6.1.0.0) und Firebird for EF6. Ok now i can the the provider if i try to create a Model but if i click next the i get the error:
http://stackoverflow.com/questions/21525490/firebird-ddex-3-0-1-with-vs2013-system-data-entity-core-mappingexception
ist all up to date. Is it possible, that the bug still exists?! What should i do??
--
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
|
|
From: Jeff W. (JIRA) <tr...@fi...> - 2014-05-08 21:42:34
|
Version from the download page doesn't work at runtime, version from nuget doesn't work with DDEX
-------------------------------------------------------------------------------------------------
Key: DNET-554
URL: http://tracker.firebirdsql.org/browse/DNET-554
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider, DDEX Provider
Affects Versions: 4.1.5.0
Environment: Visual Studio 2012 / Visual Studio 2013, 32 Bit
Reporter: Jeff Walters
Assignee: Jiri Cincura
The provider version on the download page works with DDEX at design time, but fails with the following error at runtime:
The Entity Framework provider type 'FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient' registered in the application config file for the ADO.NET provider with invariant name 'FirebirdSql.Data.FirebirdClient' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.
The nuget version FirebirdSql.Data.FirebirdClient-EF6 work at runtime, but DDEX support does not work. Depending on the order in which I install and uninstall the 2 versions of the provider - either Firebird Data Source is missing from Server Explorer / Add Connection / Change Data Source OR Firebird Data Source is there but the Add Connection dialog closes when you type in any field.
--
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
|
|
From: Jiri C. <di...@ci...> - 2014-05-01 19:23:12
|
On Thu, May 1, 2014 at 8:23 PM, Mark Rotteveel <ma...@la...> wrote:
> You could always use the services API to create a backup on the server,
> but since CORE-2666 it is also possible to stream the backup to the
> client (or from the client to the server for restore).
Good. As I thought. I was confused by the subject of this thread
"remote clients" to be specific. :)
Looks like it's time to implement it.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Mark R. <ma...@la...> - 2014-05-01 18:23:57
|
On 1-5-2014 19:40, Jiri Cincura wrote: > On Thu, May 1, 2014 at 12:21 PM, Mark Rotteveel <ma...@la...> wrote: >> That is no longer true, remote backup has been included in the service API >> in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666 > > I'm lost. Wasn't this always the case? Via services API you created > backup on server. But it was/is not possible to create a backup of > remote database to local file. Or it was vice versa? You could always use the services API to create a backup on the server, but since CORE-2666 it is also possible to stream the backup to the client (or from the client to the server for restore). From the README.services_extension.txt: " 4) Services API extension - running gbak at server side with .fbk at the client. (Alex Peshkov, pes...@ma..., 2011-2012) This way of doing backups is specially efficient when one needs to perform backup/restore operation for database, located on ther server accessed using internet, due to the great performance advantage. The simplest way to use this feature is fbsvcmgr. To backup database run approximately the following: fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \ action_backup -dbname some.fdb -bkp_file stdout >some.fbk and to restore it: fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \ action_restore -dbname some.fdb -bkp_file stdin <some.fbk Please notice - you can't use "verbose" switch when performing backup because data channel from server to client is used to deliver blocks of fbk files. You will get appropriate error message if you try to do it. When restoring database verbose mode may be used without limitations. If you want to perform backup/restore from your own program, you should use services API for it. Backup is very simple - just pass "stdout" as backup file name to server and use isc_info_svc_to_eof in isc_service_query() call. Data, returned by repeating calls to isc_service_query() (certainly with isc_info_svc_to_eof tag) is a stream, representing image of backup file. Restore is a bit more tricky. Client sends new spb parameter isc_info_svc_stdin to server in isc_service_query(). If service needs some data in stdin, it returns isc_info_svc_stdin in query results, followed by 4-bytes value - number of bytes server is ready to accept from client. (0 value means no more data is needed right now.) The main trick is that client should NOT send more data than requested by server - this causes an error "Size of data is more than requested". The data is sent in next isc_service_query() call in the send_items block, using isc_info_svc_line tag in traditional form: isc_info_svc_line, 2 bytes length, data. When server needs next portion, it once more returns non-zero isc_info_svc_stdin value from isc_service_query(). A sample of how services API should be used for remote backup and restore can be found in source code of fbsvcmgr. " Mark -- Mark Rotteveel |
|
From: Jiri C. <di...@ci...> - 2014-05-01 17:40:58
|
On Thu, May 1, 2014 at 12:21 PM, Mark Rotteveel <ma...@la...> wrote: > That is no longer true, remote backup has been included in the service API > in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666 I'm lost. Wasn't this always the case? Via services API you created backup on server. But it was/is not possible to create a backup of remote database to local file. Or it was vice versa? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com |
|
From: Parzival <par...@gm...> - 2014-05-01 17:38:30
|
Hello, thanks for the responses. I understand that the limitation of the .net provider fbBackup was caused by a limitation on the server api. The functionality is in place starting with version 2.5.2. This leads to the question, if this function is on the roadmap for the .net provider. Jiri, can please comment on that? Btw: What is the best way to support the Firebird developers - is it a membership in the Firebird Foundation? The effort and very impressive results that are delivered by the develoment team require support. Niko -----Ursprüngliche Nachricht----- Von: Mark Rotteveel [mailto:ma...@la...] Gesendet: Donnerstag, 01. Mai 2014 12:21 An: For users and developers of the Firebird .NET providers Betreff: Re: [Firebird-net-provider] fbBackup on remote Clients On Thu, 1 May 2014 11:49:02 +0200, Jiri Cincura <di...@ci...> wrote: > On Thu, May 1, 2014 at 8:49 AM, Parzival <par...@gm...> wrote: >> Is there a way to get fbBackup working on remote Clients? > > http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797&page=c om.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_207 97 That is no longer true, remote backup has been included in the service API in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666 Mark ---------------------------------------------------------------------------- -- "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Mark R. <ma...@la...> - 2014-05-01 10:21:16
|
On Thu, 1 May 2014 11:49:02 +0200, Jiri Cincura <di...@ci...> wrote: > On Thu, May 1, 2014 at 8:49 AM, Parzival <par...@gm...> wrote: >> Is there a way to get fbBackup working on remote Clients? > > http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_20797 That is no longer true, remote backup has been included in the service API in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666 Mark |
|
From: Scott P. <sco...@vi...> - 2014-05-01 09:54:32
|
Hi Parzival, I would suggest you consider something like a secured webservice, which can be invoked by the remote client to perform the backup on the server side. However, depending on the size of your resultant backup, you may not want to transfer it back to the client. I hope that helps you practically overcome the problem. :) Kind regards, Scott :) On 01/05/2014 10:49, Jiri Cincura wrote: > On Thu, May 1, 2014 at 8:49 AM, Parzival <par...@gm...> wrote: >> Is there a way to get fbBackup working on remote Clients? > http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_20797 > |
|
From: Jiri C. <di...@ci...> - 2014-05-01 09:49:10
|
On Thu, May 1, 2014 at 8:49 AM, Parzival <par...@gm...> wrote: > Is there a way to get fbBackup working on remote Clients? http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_20797 -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com |
|
From: Parzival <par...@gm...> - 2014-05-01 06:49:55
|
Hello, I have seen that there is an issue on running fbBackup on remote Client PCs, but it works fine on the firebird server itself. In the ticket there is a reference to the servicemanager using fbBackup. (http://tracker.firebirdsql.org/browse/DNET-287). Is there a way to get fbBackup working on remote Clients? Thanks Niko |
|
From: Alexx (JIRA) <tr...@fi...> - 2014-04-28 21:14:29
|
Diacritic replaced when EF update records
-----------------------------------------
Key: DNET-553
URL: http://tracker.firebirdsql.org/browse/DNET-553
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 4.1.5.0
Environment: Win7 x64 (and x86 too), Fbclient 2.5.2, EF5, database with iso8859-1 charset
Reporter: Alexx
Assignee: Jiri Cincura
I'm using EF code first and mapped varchar field that contains some diacritics.
Retrieve one record with diacritic, concatenate space (only to enforce updating) and submit changes.
All diacritics updated or inserted with EF are replaced by a dot.
Inserting an equivalent record (with diacritics) by FbCommand and exactly the same connectionstring do not cause this problem.
--
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
|
|
From: Erik J. M. (JIRA) <tr...@fi...> - 2014-04-17 15:11:20
|
ConnectionLifetime with value 0 (zero) is no longer treated as infinite but really as zero.
-------------------------------------------------------------------------------------------
Key: DNET-552
URL: http://tracker.firebirdsql.org/browse/DNET-552
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.1.5.0
Reporter: Erik Jan Meijer
Assignee: Jiri Cincura
In NETProvider\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbConnectionPoolManager.cs , Pool.CleanupPool() does the following:
var keep = available.Where(x => x.Created.AddSeconds(_connectionString.ConnectionLifeTime) > now).ToArray();
This does not take into account the default(!) value of zero for _connectionString.ConnectionLifeTime.
The effect is that connections are closed and recreated for every request.
You can see TCP-connections closing and new ones reopening by using TcpView by SysInternals.
--
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
|
|
From: Marco C. - M. <mc...@mc...> - 2014-04-16 01:42:28
|
<br><br>
<title>EMail McSoft</title>
<div style="width:auto;height:105px;background-image:url('http://www.mcsoft.com.br/imagens/HeaderTop.png');background-position:top;margin:-15px auto 0px 0px">
<div style="margin:0px auto;width:700px;">
<div style="margin:0px auto;width:700px;height:120px;float:left;">
<div style="margin:0px auto;width:700px;height:120px;">
<div style="height:101px;width:700px;">
<div style="float:left;margin-left:10px;height:50px;width:216px;background-image:url('http://www.mcsoft.com.br/imagens/logo.png');background-position:center top;background-repeat: no-repeat;margin-top:32px;">
<h1>
</h1>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="width:auto;height:auto;">
<div style="margin:0px auto;width:700px;height:auto;">
<div style="margin:0px auto;width:700px;background-color:#FFF;">
<div style="padding:7px;font-family:Arial, Helvetica, sans-serif;font-size:9pt;line-height:15pt;color:#404041;">
<br>
Hi, try with DDEX 3.0.0.<br>
<br>Best regards,<br></div>
<div style="padding:7px;font-family:Arial, Helvetica, sans-serif;font-size:9pt;line-height:15pt;color:#404041;">
<span style="font-weight:bold">Marco Aurelio Castro</span>
<br>
Director<br>
McSoft
</div>
</div>
</div>
</div>
<div style="margin-top:25px;margin-right:auto;margin-left:auto;width:700px;height:45px;background-image:url('http://www.mcsoft.com.br/imagens/footerbg.png');background-position:center top;background-repeat:repeat-x;clear:both;">
<a href="http://www.mcsoft.com.br" style="margin-left:12px;margin-top:16px;font-family:Arial, Helvetica, sans-serif;color:#fff;font-size:9pt;float:left;text-decoration:none;color:#fff;" target='_blank'>McSoft</a>
<span style="margin:16px 4px auto 4px;font-family:Arial, Helvetica, sans-serif;color:#fff;font-size:9pt;float:left">|</span>
<a href="http://www.mcsoft.com.br/TextoGenerico.aspx?FileName=fnEmpresa.htm" style="margin-top:16px;font-family:Arial, Helvetica, sans-serif;color:#fff;font-size:9pt;float:left;text-decoration:none;color:#fff;" target='_blank'>A Empresa</a>
<span style="margin:16px 4px auto 4px;font-family:Arial, Helvetica, sans-serif;color:#fff;font-size:9pt;float:left">|</span>
<a href="http://www.mcsoft.com.br/TextoGenerico.aspx?FileName=fnSolucoes.htm" style="margin-top:16px;font-family:Arial, Helvetica, sans-serif;color:#fff;font-size:9pt;float:left;text-decoration:none;color:#fff;" target='_blank'>Nosso sistema</a>
<div style="float:right;margin-top:auto;margin-bottom:auto;height:46px;width:90px">
<a href="http://www.facebook.com/McSoftBH" style="margin-right:8px" target='_blank'>
<img style="margin-top:9px;border:0px" src="http://www.mcsoft.com.br/Imagens/flogo.png" temp_src="http://www.mcsoft.com.br/Imagens/flogo.png" alt="Facebook">
</a>
<a href="http://twitter.com/mcsoft" style="margin-right:8px" target='_blank'>
<img style="margin-top:9px;border:0px" src="http://www.mcsoft.com.br/Imagens/btwitter.png" temp_src="http://www.mcsoft.com.br/Imagens/btwitter.png" alt="Twitter">
</a>
</div>
</div>
<br><br><b>----- Original Message -----</b><br>
<b>From:</b> Joseph Martinez [mailto:jo...@jm...]<br>
<b>To:</b> fir...@li...<br>
<b>Sent:</b> Tue, 15 Apr 2014 11:05:06 -0700<br>
<b>Subject:</b> [Firebird-net-provider] Entity Framework woes (cannot update modelfrom database)<br><br>
<div><div>When I try to do "Update model from database", I get the following error:</div><div><br></div>An exception of type 'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException' occurred while attempting to update from the database. The exception message is: ''.<br>
<div><br></div><div>I searched this error, and I find a reply from Jiri from about a year ago that says, "<span style="line-height:24px;text-align:justify">DDEX not installed correctly."</span></div><div><span style="line-height:24px;text-align:justify"><br>
</span></div><div><span style="line-height:24px;text-align:justify">I then performed the following steps:</span></div><div><span style="line-height:24px;text-align:justify">1) Uninstalled the Firebird DDEX provider and the Firebird ADO.Net provider</span><br>
</div><div style="text-align:justify"><span style="line-height:24px">2) Replaced machine.config in the following folders with the machine.config.default file:</span></div><div style="text-align:justify"><span style="line-height:24px">C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config</span></div>
<div style="text-align:justify"><span style="line-height:24px">C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config</span><br></div><div style="text-align:justify">3) Reinstalled <a href="http://ADO.NET" target='_blank'>ADO.NET</a> provider from NETProvider-4.1.0.0.msi</div>
<div style="text-align:justify">4) Reinstalled DDEX provider from DDEXProvider-3.0.1.0.msi</div><div style="text-align:justify"><br></div><div style="text-align:justify">However, I still get the same error. I can open the .EDMX file and view the entities, but I cannot update the model from the database.</div>
<div style="text-align:justify"><br></div><div style="text-align:justify">Here is my connection string:</div><div style="text-align:justify">metadata=res://*/TRS11Model.csdl|res://*/TRS11Model.ssdl|res://*/TRS11Model.msl;provider=FirebirdSql.Data.FirebirdClient;provider connection string='initial catalog="C:\Program Files (x86)\TRS11\Data\DATA1100.FDB";user id=sysdba;password=masterkey;data source=localhost'<br>
</div><div style="text-align:justify"><br></div><div style="text-align:justify">The database path, userid, and password are all correct.</div><div style="text-align:justify"><br></div><div style="text-align:justify">Does this still sound like an issue with DDEX not being installed correctly?</div>
<div style="text-align:justify">If so, what else should I do to install it correctly, if my above steps are not sufficient.</div><div style="text-align:justify"><br></div><div style="text-align:justify">-Joe</div></div>
|
|
From: Joseph M. <jo...@jm...> - 2014-04-15 18:27:36
|
When I try to do "Update model from database", I get the following error: An exception of type 'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException' occurred while attempting to update from the database. The exception message is: ''. I searched this error, and I find a reply from Jiri from about a year ago that says, "DDEX not installed correctly." I then performed the following steps: 1) Uninstalled the Firebird DDEX provider and the Firebird ADO.Net provider 2) Replaced machine.config in the following folders with the machine.config.default file: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config 3) Reinstalled ADO.NET provider from NETProvider-4.1.0.0.msi 4) Reinstalled DDEX provider from DDEXProvider-3.0.1.0.msi However, I still get the same error. I can open the .EDMX file and view the entities, but I cannot update the model from the database. Here is my connection string: metadata=res://*/TRS11Model.csdl|res://*/TRS11Model.ssdl|res://*/TRS11Model.msl;provider=FirebirdSql.Data.FirebirdClient;provider connection string='initial catalog="C:\Program Files (x86)\TRS11\Data\DATA1100.FDB";user id=sysdba;password=masterkey;data source=localhost' The database path, userid, and password are all correct. Does this still sound like an issue with DDEX not being installed correctly? If so, what else should I do to install it correctly, if my above steps are not sufficient. -Joe |
211 messages has been excluded from this view by a project administrator.
;background-position:top;margin:-15px){kind=link}
;background-position:center){kind=link}
;background-position:center){kind=link}
![http://www.mcsoft.com.br/Imagens/flogo.png"](http://www.mcsoft.com.br/Imagens/flogo.png"){kind=link}
![http://www.mcsoft.com.br/Imagens/btwitter.png"](http://www.mcsoft.com.br/Imagens/btwitter.png"){kind=link}