Re: [Firebird-net-provider] FbDataAdapter problem
I have waited for you to review the test cases that I have sent to you (one using Sql Provider, the other one using Fb Provider) but no news. Please read http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=933212&SiteID=1 where Zlatko Michailov - MSFT confirmed that AcceptChanges() is called after step 3 Zlatko Michailov - MSFT has marked the following post as an answer to your question on the forums. Re: SqlDataAdapter The fact that AcceptChanges() is called after step 3 is expressed here: First, the AcceptChanges method of the DataRow is called to preserve the current values as original values, and then the new values are assigned. Following these actions, DataRows that had their RowState property set to Added will have their RowState property set to Modified, which may be unexpected. If this is not the answer to your question you can unmark the answer by clicking "unmark as answer" on the following page: http://forums.microsoft.com/forums/ShowPost.aspx?PostID=975522&SiteID=1 Post Marked as Answered - Original Message - From: "Carlos Guzmán Álvarez" <[EMAIL PROTECTED]> To: "For users and developers of the Firebird .NET providers" Sent: Saturday, November 18, 2006 5:21 PM Subject: Re: [Firebird-net-provider] FbDataAdapter problem Hello: What I do not understand is why you don't provide the same functionality if you can, why don't you use Microsoft default implementation (I ask this but I get an answer that did not convince me at all). I have given you the answer yet, but i will retry, the ms implementation does calls using ExecuteReader in some cases, and that is not valid in the provider when using stored procedures the actual Update implementation makes all the calls using ExecuteNonQuery to allow the stored procedure calls work always with independence of the sp syntax you are using. And in fact that is not my problem. This problem is everywhere. It's where you have identity columns, where you have generators. It's described and supported by Microsoft. FbProvider is a piece of code that is to be integrated in their ADO.NET environment, isn't it ? Have you tried using Firebird 2.0 and the new INSERT INTO ... RETURNING syntax or using stored procedres that returns the new row ID in an output parameter ( i haven't checked yet the test case with the comparison against sql server, hope i will be able to review it next week ). ??? and where Microsoft says: "First, the AcceptChanges method of the DataRow is called to preserve the current values as original values, and then the new values are assigned." I will try to review it, right now the provider does this as explained in the DbDataAdapter.Update msdn documentation: "When using *Update*, the order of execution is as follows: 1. The values in the *DataRow* are moved to the parameter values. 2. The OnRowUpdating event is raised. 3. The command executes. 4. If the command is set to *FirstReturnedRecord*, then the first returned result is placed in the *DataRow*. 5. If there are output parameters, they are placed in the *DataRow*. 6. The *OnRowUpdated* event is raised. 7. AcceptChanges is called." What i have modified in the CVS sources for the step 7 is to check the value of AcceptChangesDuringUpdate before calling AcceptChanges . The step 4 does not apply to the Firebird provider because there are no support for batch commands and because the execution is done using ExecuteNonQuery calls. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider <> - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird 2.0 Embedded on Linux
At 09:31 AM 18/12/2006, you wrote: >well, I actually never got it to run, it crashed due to threading >problems... and I don't even know about 2.0 > >Hello: > > Well, I regularly ask the same question but... is there any progress on > > Firebird/Mono Embedded on Linux? >And what the problems of the embedded suppoer on linux ?? There seems to be a high level of confusion about "embedded on Linux", so I'm sticking my oar in here. There is only one way to build an embedded app on Linux and that's by using Classic and the libfbembed.so client, i.e. Classic's original direct-connect mechanism. It *does* require the presence of the security database and authentication at login and it does not use a network method for the connection. libfbembed.so is NOT thread-safe. It presents the same API but, as to whether there is a Mono data access layer for Firebird that's equivalent to the Windows .net providers, Carlos could best comment. Embedded on Windows is a different thing altogether. For one thing, it uses the "Windows local" network emulator (IPServer) for the connection. For another, it is a single instance of *Superserver*. Of course, as you know, it bypasses the security database altogether and doesn't authenticate the user connection. And it uses Windows API function calls. Helen - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird 2.0 Embedded on Linux
well, I actually never got it to run, it crashed due to threading problems... and I don't even know about 2.0 - Original Message - From: "Carlos Guzmán Álvarez" <[EMAIL PROTECTED]> To: "For users and developers of the Firebird .NET providers" Sent: Sunday, December 17, 2006 10:33 AM Subject: Re: [Firebird-net-provider] Firebird 2.0 Embedded on Linux Hello: > Well, I regularly ask the same question but... is there any progress on > Firebird/Mono Embedded on Linux? And what the problems of the embedded suppoer on linux ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Unable to get Firebird 2.0 to work on WinXP x64 (w/ AMD64)
My understanding is that Firebird 2.0 implements the full Unicode Collating Algorithm when your character set is utf8 so my guess is its for that. Itll be even nicer if it supported customizations per locale of the UCA, but I guess theres always Firebird 3.0 :) Dean. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Price Sent: Sunday, 17 December 2006 9:21 pm To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Unable to get Firebird 2.0 to work on WinXP x64 (w/ AMD64) Carlos Guzmán Álvarez wrote: Hello: What are those for anyway? Built-in SQL functions? For the unicode support if i'm notworn ( not sure if they are used for other encodings, hope, yes, and if i'm not sure if it's used for the collations support as well ) Sorry Carlos, what type of Unicode support? Reading/storing/other? Kind regards, Scott :) - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Unable to get Firebird 2.0 to work on WinXP x64 (w/ AMD64)
Carlos Guzmán Álvarez wrote: Hello: What are those for anyway? Built-in SQL functions? For the unicode support if i'm notworn ( not sure if they are used for other encodings, hope, yes, and if i'm not sure if it's used for the collations support as well ) Sorry Carlos, what type of Unicode support? Reading/storing/other? Kind regards, Scott :) - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird 2.0 Embedded on Linux
Hello: > Well, I regularly ask the same question but... is there any progress on > Firebird/Mono Embedded on Linux? And what the problems of the embedded suppoer on linux ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Unable to get Firebird 2.0 to work on WinXP x64 (w/ AMD64)
Hello: > What are those for anyway? Built-in SQL functions? For the unicode support if i'm notworn ( not sure if they are used for other encodings, hope, yes, and if i'm not sure if it's used for the collations support as well ) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
