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: Mark R. <ma...@la...> - 2016-04-30 11:57:20
|
On 28-4-2016 20:19, Kyle Green wrote: > sorry for the double post - it appears I am subscribed twice > > how can I remove one of the subscriptions? To unsubscribe, send an e-mail to fir...@li... with subject: unsubscribe. Or go to the web interface: https://lists.sourceforge.net/lists/listinfo/firebird-net-provider (see at the end); sending an e-mail is probably simpler though. Mark -- Mark Rotteveel |
|
From: Kyle <ky...@ky...> - 2016-04-29 16:31:17
|
Thank you. Apparently I have not upgraded for several years - everything was working so well :) On 2016-04-29 07:34, Jiří Činčura wrote: > Yep. The 3.5 support has been dropped a long time ago. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > On Thu, Apr 28, 2016, at 20:03, Kyle Green wrote: >> I've installed the provider from the msi installer on a Windows 10 >> laptop running Visual Studio 2008. I replaced Firebird 2.5 with the new >> Firebird 3.0 release. >> I have project configured for .net 3.5. I removed the previous provider >> which was working against Firebird 2.5. >> >> When I try to add a reference for the new provider, it just doesn't take >> it. It shows up the reference list with a yellow triangle, and no >> information, >> Does this provider not work with Visual Studio 2008, or with .net 3.5? >> >> Thanks, >> >> >> -- >> Kyle Green >> >> ------------------------------------------------------------------------------ >> Find and fix application performance issues faster with Applications >> Manager >> Applications Manager provides deep performance insights into multiple >> tiers of >> your business applications. It resolves application problems quickly and >> reduces your MTTR. Get your free trial! >> https://ad.doubleclick.net/ddm/clk/302982198;130105516;z >> _______________________________________________ >> Firebird-net-provider mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > ------------------------------------------------------------------------------ > Find and fix application performance issues faster with Applications Manager > Applications Manager provides deep performance insights into multiple tiers of > your business applications. It resolves application problems quickly and > reduces your MTTR. Get your free trial! > https://ad.doubleclick.net/ddm/clk/302982198;130105516;z [1] > > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider [2] Links: ------ [1] https://ad.doubleclick.net/ddm/clk/302982198;130105516;z [2] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiří Č. <ji...@ci...> - 2016-04-29 14:34:15
|
Yep. The 3.5 support has been dropped a long time ago. -- Mgr. Jiří Činčura Independent IT Specialist On Thu, Apr 28, 2016, at 20:03, Kyle Green wrote: > I’ve installed the provider from the msi installer on a Windows 10 > laptop running Visual Studio 2008. I replaced Firebird 2.5 with the > new > Firebird 3.0 release. > I have project configured for .net 3.5. I removed the previous > provider > which was working against Firebird 2.5. > > When I try to add a reference for the new provider, it just > doesn’t take > it. It shows up the reference list with a yellow triangle, and no > information, > Does this provider not work with Visual Studio 2008, or with .net 3.5? > > Thanks, > > > -- > Kyle Green > > ---------------------------------------------------------------------- > -------- > Find and fix application performance issues faster with Applications > Manager > Applications Manager provides deep performance insights into multiple > tiers of > your business applications. It resolves application problems > quickly and > reduces your MTTR. Get your free trial! > https://ad.doubleclick.net/ddm/clk/302982198;130105516;z > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: LtColRDSChauhan <rds...@gm...> - 2016-04-29 06:26:51
|
On Fri, Apr 29, 2016 at 11:04 AM, LtColRDSChauhan <rds...@gm...>
wrote:
> >>On 24-4-2016 09:16, LtColRDSChauhan wrote:>>1. I have a Firebird-2.5.5.26952_0_Win32 database which I backed up>>(using Flamerobin) after renaming RDB$FIELD_NAME field values in the>>system table RDB$FIELDS of the source database as under:>>>'SEC$USER_NAME' to 'SEC$USER_NAME_RAJIV'>>'SEC$NAME_PART' to 'SEC$NAME_PART_RAJIV'
>
> >Why did you do this?
> 1. On restoring the 2.5 back up to 3.0 the following error was reported :-
> Connecting to server localhost...Database restore started 10:06:51gbak:opened file C:\HMS_29Apr2016_09_20_25.GBK gbak:transportable backup -- data in XDR format gbak: backup file is compressed gbak:backup version is 9 gbak:created database D:\HMS_2015_09_25\AppHMS\HMSFireBird\HMS.FDB, page_size 16384 bytes gbak:started transaction gbak:restoring domain SEC$GID gbak:restoring domain SEC$NAME_PART Database restore canceled 10:06:53 due to IBPP exception:
> *** IBPP::SQLException ***Context: ServiceImpl::WaitMessage: isc_service_query failed
> SQL Message : -803Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values
> Engine Code : 335544665Engine Message :violation of PRIMARY or UNIQUE KEY constraint "RDB$INDEX_2" on table "RDB$FIELDS"Problematic key value is ("RDB$FIELD_NAME" = 'SEC$NAME_PART')Exiting before completion due to errors
> 2. Some months back, to my post in Firebird Support Vlad had advised the following:-
> “there is already a field name SEC$NAME_PART in ODS12 system tables.You should rename your field\domain in source database in order to restore it in FB3.”
> 3. Fresh restore attempt reported the error as a Para 1 above, now for SEC$USER_NAME.
> >>2. I installed Firebird-3.0.0.32483_2_Win32 on Windows 10 with Legacy>>Authentication. Using Flamerobin I restored the Firebird 2.5.5 FBK file.>>>3. The Flamerobin connects to the Firebird 3.0 restored file but my .NET>>application (Provider .NET 4.10) fails to connect.
>
> >What error do you get?Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
> >Did you explicitly create a Legacy_Auth user?No. Now created as under (this was advised by you to my post during Firebird 3 Alpha 1 days !!):
> E:\Program Files\Firebird\Firebird_3_0>gsec -user SYSDBA -password masterkey*** gsec is deprecated, will be removed soon ***
> GSEC> modify sysdba -pw newPassword
> >What config does your firebird.conf have for the settings AuthServer, WireCrypt, and UserManagerAuthServer = Legacy_Auth, Srp, Win_SspiWireCrypt = enabledUserManager = Legacy_UserManager, Srp
> After creating a Legacy_Auth user explicitly as hinted by you .NET Provider log in worked. Here I have given all details you have
>
> asked for with a request of adding notes where ever possible to help understand the Firebird 3.0 security including support to legacy authentication.
> Many thanks, Mark!!Regards,Rajiv
>
> Mark,
Could trace your:
https://github.com/FirebirdSQL/jaybird/wiki/Jaybird-and-Firebird-3
It covers everything except for SEC$USER_NAME, SEC$NAME_PART.
Regards,
Rajiv
|
|
From: LtColRDSChauhan <rds...@gm...> - 2016-04-29 05:34:08
|
>>On 24-4-2016 09:16, LtColRDSChauhan wrote:>>1. I have a Firebird-2.5.5.26952_0_Win32 database which I backed up>>(using Flamerobin) after renaming RDB$FIELD_NAME field values in the>>system table RDB$FIELDS of the source database as under:>>>'SEC$USER_NAME' to 'SEC$USER_NAME_RAJIV'>>'SEC$NAME_PART' to 'SEC$NAME_PART_RAJIV'
>Why did you do this?
1. On restoring the 2.5 back up to 3.0 the following error was reported :-
Connecting to server localhost...Database restore started
10:06:51gbak:opened file C:\HMS_29Apr2016_09_20_25.GBK
gbak:transportable backup -- data in XDR format gbak: backup file is
compressed gbak:backup version is 9 gbak:created database
D:\HMS_2015_09_25\AppHMS\HMSFireBird\HMS.FDB, page_size 16384 bytes
gbak:started transaction gbak:restoring domain SEC$GID gbak:restoring
domain SEC$NAME_PART Database restore canceled 10:06:53 due to IBPP
exception:
*** IBPP::SQLException ***Context: ServiceImpl::WaitMessage:
isc_service_query failed
SQL Message : -803Invalid insert or update value(s): object columns
are constrained - no 2 table rows can have duplicate column values
Engine Code : 335544665Engine Message :violation of PRIMARY or
UNIQUE KEY constraint "RDB$INDEX_2" on table "RDB$FIELDS"Problematic
key value is ("RDB$FIELD_NAME" = 'SEC$NAME_PART')Exiting before
completion due to errors
2. Some months back, to my post in Firebird Support Vlad had advised
the following:-
“there is already a field name SEC$NAME_PART in ODS12 system
tables.You should rename your field\domain in source database in order
to restore it in FB3.”
3. Fresh restore attempt reported the error as a Para 1 above, now
for SEC$USER_NAME.
>>2. I installed Firebird-3.0.0.32483_2_Win32 on Windows 10 with Legacy>>Authentication. Using Flamerobin I restored the Firebird 2.5.5 FBK file.>>>3. The Flamerobin connects to the Firebird 3.0 restored file but my .NET>>application (Provider .NET 4.10) fails to connect.
>What error do you get?Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
>Did you explicitly create a Legacy_Auth user?No. Now created as under (this was advised by you to my post during Firebird 3 Alpha 1 days !!):
E:\Program Files\Firebird\Firebird_3_0>gsec -user SYSDBA -password
masterkey*** gsec is deprecated, will be removed soon ***
GSEC> modify sysdba -pw newPassword
>What config does your firebird.conf have for the settings AuthServer, WireCrypt, and UserManagerAuthServer = Legacy_Auth, Srp, Win_SspiWireCrypt = enabledUserManager = Legacy_UserManager, Srp
After creating a Legacy_Auth user explicitly as hinted by you .NET
Provider log in worked. Here I have given all details you have
asked for with a request of adding notes where ever possible to help
understand the Firebird 3.0 security including support to legacy
authentication.
Many thanks, Mark!!Regards,Rajiv
|
|
From: Kyle G. <ky...@in...> - 2016-04-28 18:20:01
|
sorry for the double post - it appears I am subscribed twice how can I remove one of the subscriptions? --- Kyle Green On 2016-04-28 10:47, Kyle Green wrote: > I’ve installed the newest provider from the msi installer on a Windows > 10 laptop running Visual Studio 2008. I replaced Firebird 2.5 with the > new Firebird 3.0 release. > I have project configured for .net 3.5. I removed the previous provider > which was working against Firebird 2.5. > > When I try to add a reference for the new provider, it just doesn’t > take > it. It shows up in the reference list with a yellow triangle. > > Does this provider not work with Visual Studio 2008, or with .net 3.5? > > Thanks, > > Kyle > > -- > Kyle Green > > > > > ------------------------------------------------------------------------------ > Find and fix application performance issues faster with Applications > Manager > Applications Manager provides deep performance insights into multiple > tiers of > your business applications. It resolves application problems quickly > and > reduces your MTTR. Get your free trial! > https://ad.doubleclick.net/ddm/clk/302982198;130105516;z > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Kyle G. <ky...@in...> - 2016-04-28 18:12:57
|
I’ve installed the newest provider from the msi installer on a Windows 10 laptop running Visual Studio 2008. I replaced Firebird 2.5 with the new Firebird 3.0 release. I have project configured for .net 3.5. I removed the previous provider which was working against Firebird 2.5. When I try to add a reference for the new provider, it just doesn’t take it. It shows up in the reference list with a yellow triangle. Does this provider not work with Visual Studio 2008, or with .net 3.5? Thanks, Kyle -- Kyle Green |
|
From: Kyle G. <ky...@in...> - 2016-04-28 18:03:35
|
I’ve installed the provider from the msi installer on a Windows 10 laptop running Visual Studio 2008. I replaced Firebird 2.5 with the new Firebird 3.0 release. I have project configured for .net 3.5. I removed the previous provider which was working against Firebird 2.5. When I try to add a reference for the new provider, it just doesn’t take it. It shows up the reference list with a yellow triangle, and no information, Does this provider not work with Visual Studio 2008, or with .net 3.5? Thanks, -- Kyle Green |
|
From: Pedro F. de M. L. (JIRA) <tr...@fi...> - 2016-04-26 15:30:00
|
Except after updating to 4.10.0
-------------------------------
Key: DNET-679
URL: http://tracker.firebirdsql.org/browse/DNET-679
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.10.0.0
Environment: Windows Server R2 2008 R2 Enterprise 64-bits; IIS 7.5; .NET Framework 4.0.30319; Visual Studio 2013;
Reporter: Pedro Filipe de Morais Lima
Assignee: Jiri Cincura
Priority: Critical
Updated the " Firebird ADO.NET Data provider " for version 4.10.0 and I am getting , sometimes , the following exception in my application:
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
at FirebirdSql.Data.Common.Extensions.TryGetTarget[T](WeakReference weakReference, T& target)
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.RemovePreparedCommand (FbCommand command)
at FirebirdSql.Data.FirebirdClient.FbCommand.Release()
at FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing)
--
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: Mark R. <ma...@la...> - 2016-04-24 07:43:20
|
On 24-4-2016 09:16, LtColRDSChauhan wrote: > 1. I have a Firebird-2.5.5.26952_0_Win32 database which I backed up > (using Flamerobin) after renaming RDB$FIELD_NAME field values in the > system table RDB$FIELDS of the source database as under: > > 'SEC$USER_NAME' to 'SEC$USER_NAME_RAJIV' > 'SEC$NAME_PART' to 'SEC$NAME_PART_RAJIV' Why did you do this? > 2. I installed Firebird-3.0.0.32483_2_Win32 on Windows 10 with Legacy > Authentication. Using Flamerobin I restored the Firebird 2.5.5 FBK file. > > 3. The Flamerobin connects to the Firebird 3.0 restored file but my .NET > application (Provider .NET 4.10) fails to connect. What error do you get? Did you explicitly create a Legacy_Auth user? What config does your firebird.conf have for the settings AuthServer, WireCrypt, and UserManager Mark -- Mark Rotteveel |
|
From: Norbert S. G. <ns...@te...> - 2016-04-24 07:24:08
|
LtColRDSChauhan a écrit : > Hi, > > 1. I have a Firebird-2.5.5.26952_0_Win32 database which I backed up (using > Flamerobin) after renaming RDB$FIELD_NAME field values in the system table > RDB$FIELDS of the source database as under: > > 'SEC$USER_NAME' to 'SEC$USER_NAME_RAJIV' > 'SEC$NAME_PART' to 'SEC$NAME_PART_RAJIV' > 2. I installed Firebird-3.0.0.32483_2_Win32 on Windows 10 with Legacy > Authentication. Using Flamerobin I restored the Firebird 2.5.5 FBK file. > > 3. The Flamerobin connects to the Firebird 3.0 restored file but my .NET > application (Provider .NET 4.10) fails to connect. > > Please advise. > Regards, > Rajiv your .NET application is 64-bit, have you installed the 64 of fbclient.dll? -- Norbert Saint Georges http://tetrasys.fi |
|
From: LtColRDSChauhan <rds...@gm...> - 2016-04-24 07:16:45
|
Hi, 1. I have a Firebird-2.5.5.26952_0_Win32 database which I backed up (using Flamerobin) after renaming RDB$FIELD_NAME field values in the system table RDB$FIELDS of the source database as under: 'SEC$USER_NAME' to 'SEC$USER_NAME_RAJIV' 'SEC$NAME_PART' to 'SEC$NAME_PART_RAJIV' 2. I installed Firebird-3.0.0.32483_2_Win32 on Windows 10 with Legacy Authentication. Using Flamerobin I restored the Firebird 2.5.5 FBK file. 3. The Flamerobin connects to the Firebird 3.0 restored file but my .NET application (Provider .NET 4.10) fails to connect. Please advise. Regards, Rajiv |
|
From: Jiří Č. <ji...@ci...> - 2016-04-22 19:50:07
|
Beta probably next week. -- Mgr. Jiří Činčura Independent IT Specialist On Fri, Apr 22, 2016, at 16:16, Rick Roen wrote: > Now that FB3 has been officially released, is there and ETA for the Net > Provider? I'm especially interested to have the new Boolean datatype > working. > > Regards, > Rick > ------------------------------------------------------------------------------ > Find and fix application performance issues faster with Applications > Manager > Applications Manager provides deep performance insights into multiple > tiers of > your business applications. It resolves application problems quickly and > reduces your MTTR. Get your free trial! > https://ad.doubleclick.net/ddm/clk/302982198;130105516;z > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Rick R. <ric...@gm...> - 2016-04-22 14:17:10
|
Now that FB3 has been officially released, is there and ETA for the Net Provider? I'm especially interested to have the new Boolean datatype working. Regards, Rick |
|
From: Jiří Č. <ji...@ci...> - 2016-04-22 12:10:35
|
> Just the options for a transaction that performs a simple Update > operation. So you need write transaction. > Grand! so any code with that is wrong. Understood! if TIL (Transaction > Isolation Level, right?) is not specified, what would be firebird's > behavior > then? I don't know. You're probably need to check engine's code. Nobody same would rely on that, I suppose. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Joslat <jos...@ro...> - 2016-04-22 11:52:19
|
That's kind of invalid. You're not specifying TIL. Thanks for the amazingly quick response, appreciated!! >> So, for example, if I want a Save-Update operation I should put all the >I don't know what that means. Just the options for a transaction that performs a simple Update operation. >> My guess was that the "default" firebird options were respected. Is that >> not allright? >Really the default in provider is Write | NoWait | ReadCommitted | >RecVersion. Once you start specifying your own, you're on your own. Great, so specifying any option, means that we have to specify everyhting. Clearly understood! >> I tried to reach out to several references but so far none explains what >> behavior is to be expected under this condition >> (FbTransactionBehavior.Wait). >That's kind of invalid. You're not specifying TIL. Grand! so any code with that is wrong. Understood! if TIL (Transaction Isolation Level, right?) is not specified, what would be firebird's behavior then? Best, Jose -- View this message in context: http://firebird.1100200.n4.nabble.com/Unspecified-Transaction-after-creation-tp4643287p4643299.html Sent from the firebird-net-provider mailing list archive at Nabble.com. |
|
From: Jiří Č. <ji...@ci...> - 2016-04-22 11:41:27
|
> So, for example, if I want a Save-Update operation I should put all the I don't know what that means. > My guess was that the "default" firebird options were respected. Is that > not > allright? Really the default in provider is Write | NoWait | ReadCommitted | RecVersion. Once you start specifying your own, you're on your own. > I tried to reach out to several references but so far none explains what > behavior is to be expected under this condition > (FbTransactionBehavior.Wait). That's kind of invalid. You're not specifying TIL. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Joslat <jos...@ro...> - 2016-04-22 11:18:30
|
So, for example, if I want a Save-Update operation I should put all the
transaction options specifically, like:
to = new FbTransactionOptions()
{
TransactionBehavior =
FbTransactionBehavior.Protected |
FbTransactionBehavior.Write |
FbTransactionBehavior.ReadCommitted |
FbTransactionBehavior.RecVersion |
FbTransactionBehavior.Wait
};
And, obviously, Begin the transaction..
My guess was that the "default" firebird options were respected. Is that not
allright?
If I put, for example, only the FbTransactionBehavior.Wait, what would be
the behavior then?
I tried to reach out to several references but so far none explains what
behavior is to be expected under this condition
(FbTransactionBehavior.Wait).
--
View this message in context: http://firebird.1100200.n4.nabble.com/Unspecified-Transaction-after-creation-tp4643287p4643297.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
|
|
From: Jiří Č. <ji...@ci...> - 2016-04-22 09:56:15
|
If you want something else then Unspecified (which, looking at the code might actually rather be some reasonable default), you have to specify the isolation level. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Joslat <jos...@ro...> - 2016-04-21 13:46:33
|
Hi,
There is any way to validate the Transaction configuration after Starting
it?
If I create a transaction options with FbTransactionBehavior.Wait, for
example, And start the transaction with BeginTransaction, like:
this.conn.BeginTransaction(new FbTransactionOptions() { TransactionBehavior
= FbTransactionBehavior.Wait});
After this the transaction object on the connection appears as
"unspecified".
How can I check the current active transaction options of the current
transaction?
Thanks,
Jose
--
View this message in context: http://firebird.1100200.n4.nabble.com/Unspecified-Transaction-after-creation-tp4643287.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
|
|
From: Jiří Č. <ji...@ci...> - 2016-04-18 10:37:19
|
> Is it possible to have two different database contexts that points to > same databases file? Absolutely. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Геннадий З. <zab...@gm...> - 2016-04-18 10:04:25
|
Is it possible to have two different database contexts that points to same databases file? |
|
From: Widmer, R. (M&F E. AG) <Ric...@oe...> - 2016-04-18 08:43:14
|
Hi Mark Thank you for your fast response here and on StackOverflow. I had installed the version 3.0.1 of de DDEX instead of 3.0.2. Now it works. Sorry about this. Regards, Rico Von: Mark Rotteveel [mailto:ma...@la...] Gesendet: Sonntag, 17. April 2016 21:13 An: For users and developers of the Firebird .NET providers <fir...@li...> Betreff: Re: [Firebird-net-provider] Not able to choose Firebird ADO.Net Data provider as data source in VS2015 As I also posted on stackoverflow, you need to install the DDEX provider as well. I tested that yesterday and it worked for me. Mark ----- Bericht beantwoorden ----- Van: "Widmer, Rico (M&F Engineering AG)" <Ric...@oe...<mailto:Ric...@oe...>> Aan: "fir...@li...<mailto:fir...@li...>" <fir...@li...<mailto:fir...@li...>> Onderwerp: [Firebird-net-provider] Not able to choose Firebird ADO.Net Data provider as data source in VS2015 Datum: vr, apr. 15, 2016 12:11 Hallo everybody I am struggling creating a Firebird connection in Visual Studio 2015. I have a C# class library with which I would like to connect to a Firebird database. I installed these plugins from NuGet: [enter image description here]<http://i.stack.imgur.com/dR8Th.png> But when I try to add a new Item "ADO.NET Entity Data Model" with "EF Designer from database", the Firebird connection is not listed: [enter image description here]<http://i.stack.imgur.com/0o6np.png> I installed as well the "FirebirdSql.Data.FirebirdClient-4.10.0.0.msi" package from http://www.firebirdsql.org/en/additional-downloads/ just in case an entry in the machine.config file is needed. The "FirebirdSql.Data.FirebirdClient" reference exists in the Visual Studio project. The entry in the App.config file is: <DbProviderFactories> <remove invariant="FirebirdSql.Data.FirebirdClient" /> <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" /> </DbProviderFactories> Can anybody help me with this issue? How can I create a database connection to my Firebird database? Thank you very much in advance. Best Regards, Rico |
|
From: M. R. <ma...@la...> - 2016-04-17 19:13:25
|
As I also posted on stackoverflow, you need to install the DDEX provider as well. I tested that yesterday and it worked for me. Mark ----- Bericht beantwoorden ----- Van: "Widmer, Rico (M&F Engineering AG)" <Ric...@oe...> Aan: "fir...@li..." <fir...@li...> Onderwerp: [Firebird-net-provider] Not able to choose Firebird ADO.Net Data provider as data source in VS2015 Datum: vr, apr. 15, 2016 12:11 Hallo everybody I am struggling creating a Firebird connection in Visual Studio 2015. I have a C# class library with which I would like to connect to a Firebird database. I installed these plugins from NuGet: But when I try to add a new Item "ADO.NET Entity Data Model" with "EF Designer from database", the Firebird connection is not listed: I installed as well the “FirebirdSql.Data.FirebirdClient-4.10.0.0.msi” package from http://www.firebirdsql.org/en/additional-downloads/ just in case an entry in the machine.config file is needed. The "FirebirdSql.Data.FirebirdClient" reference exists in the Visual Studio project. The entry in the App.config file is: <DbProviderFactories> <remove invariant="FirebirdSql.Data.FirebirdClient" /> <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" /> </DbProviderFactories> Can anybody help me with this issue? How can I create a database connection to my Firebird database? Thank you very much in advance. Best Regards, Rico |
|
From: Widmer, R. (M&F E. AG) <Ric...@oe...> - 2016-04-15 10:11:21
|
Hallo everybody I am struggling creating a Firebird connection in Visual Studio 2015. I have a C# class library with which I would like to connect to a Firebird database. I installed these plugins from NuGet: [enter image description here]<http://i.stack.imgur.com/dR8Th.png> But when I try to add a new Item "ADO.NET Entity Data Model" with "EF Designer from database", the Firebird connection is not listed: [enter image description here]<http://i.stack.imgur.com/0o6np.png> I installed as well the "FirebirdSql.Data.FirebirdClient-4.10.0.0.msi" package from http://www.firebirdsql.org/en/additional-downloads/ just in case an entry in the machine.config file is needed. The "FirebirdSql.Data.FirebirdClient" reference exists in the Visual Studio project. The entry in the App.config file is: <DbProviderFactories> <remove invariant="FirebirdSql.Data.FirebirdClient" /> <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" /> </DbProviderFactories> Can anybody help me with this issue? How can I create a database connection to my Firebird database? Thank you very much in advance. Best Regards, Rico |
211 messages has been excluded from this view by a project administrator.
