Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
Jiri Cincura wrote: On 11/1/07, paha [EMAIL PROTECTED] wrote: I've also read an interesting remark to DBConcurrencyException in MSDN When performing batch updates with the ContinueUpdateOnError property of the DataAdapter set to true, this exception is thrown if all row updates fail.

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
Jiri Cincura wrote: Oh, now I understand. I was almost sleeping, so I was thinking wrong. So the main idea behind this is, when I get error, let the row untouched (without AcceptChanges) so I'll be able to repeat the call to DB, right? Bingo :)) . I don't know if SqlDataAdapter does so

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread Jiri Cincura
On 11/2/07, Carlos [EMAIL PROTECTED] wrote: We should echeck what is being done by Sql Client if possible, and do the same thing. I agree. But I thread we're talking about more than one problem, so it's a little bit hard to keep what's going on. Maybe we can split prolems into seprate threads

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread Carlos
Hello: Maybe we can split prolems into seprate threads or create tracker items and solve problems there. What do you think? putting them into the tracker will be the best. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient :

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread Jiri Cincura
On 11/2/07, paha [EMAIL PROTECTED] wrote: You are 100% right, i asked the same questions yesterday on russian forum to know, how sqladapter performs, but still no response. What i can say for sure, if you get DBConcurrencyException, you definitely should have something in

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread Jiri Cincura
No Jiri, i mean, when we have ContinueOnError = true , and if we throw any exception or not, doesn't matter, we should call AcceptChanges (of course if AcceptChangesDuringUpdate = true) only for those rows, that have no error. As i said, imagine you have ContinueOnError=true and 2 rows violate

Re: [Firebird-net-provider] Possible issue in FirebirdSql.Data.FirebirdClient - Charset.cs

2007-11-02 Thread Carlos
Hello: retrieved. But when reading these string over ODBC or in IBExpert they IBExpert has no real support for UTF-8 ( at least as i know ), on ODBC you should check if UTF-8 is correctly supported by the driver you are using. -- Carlos Guzmán Álvarez Vigo-Spain Blog:

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
Concerning the second part of my suggestion. Of course i can achieve desired goals by setting AcceptChangesDuringUpdate= false and then after Update looping throw rows committing good rows, and leaving bad rows aside. Of course it would mean one extra loop for me what is not a problem for small

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread Carlos
Hello: This may be not big problem to change. If there's no objection, I can do this. We should echeck what is being done by Sql Client if possible, and do the same thing. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient :

Re: [Firebird-net-provider] Possible issue in

2007-11-02 Thread Jiri Cincura
On 11/2/07, Roman Rokytskyy [EMAIL PROTECTED] wrote: P.S. BTW, I'm pretty sure when you have correct unicode database and specify correct non-unicode charset when connecting in IBExpert or ODBC driver, you will get your characters back. This depends on characters. If you have UTF8 column

Re: [Firebird-net-provider] Possible issue in

2007-11-02 Thread Roman Rokytskyy
P.S. BTW, I'm pretty sure when you have correct unicode database and specify correct non-unicode charset when connecting in IBExpert or ODBC driver, you will get your characters back. This depends on characters. If you have UTF8 column and there's a japanese character in row, then using

[Firebird-net-provider] [FB-Tracker] Created: (DNET-129) Readme for installing DDEX has not correct info

2007-11-02 Thread Jiri Cincura (JIRA)
Readme for installing DDEX has not correct info --- Key: DNET-129 URL: http://tracker.firebirdsql.org/browse/DNET-129 Project: .NET Data provider Issue Type: Bug Components: DDEX

Re: [Firebird-net-provider] Possible issue in

2007-11-02 Thread Roman Rokytskyy
1] put back encoding of UNICODE_FSS to UTF-8 and find replacements for DB client and ODBC driver. Currently I use IBExpert and ODBC Firebird/Interbase Driver by IBPhoenix. 2] keep the changed version and possibly have invalid unicode characters in my DB when using other ODBC driver

[Firebird-net-provider] OT: (un)released version in Jira

2007-11-02 Thread Jiri Cincura
Hi Carlos, I've found, that in tracker we have 2.1.0 RC2 marked as unreleased. This can be a little bit confusing for reporters. Can you, please, mark it as released? -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
I've got confirmation, that SqlDataAdapter do throws DBConcurrencyException when all row updates fail in ContinueUpdateOnError=true mode, and erroneous rows are not committed (RowVersion remains Modified). -- View this message in context:

Re: [Firebird-net-provider] Possible issue in

2007-11-02 Thread Jiri Cincura
On 11/2/07, Roman Rokytskyy [EMAIL PROTECTED] wrote: Are you willing to tell me that with NONE charset you can see Japaneese, Chinese, Czech and Ukrainian characters simultaneously? :)) In some situations, when you're mad developer, you can (in application). :) Else not. -- Jiri {x2} Cincura

Re: [Firebird-net-provider] Possible issue in

2007-11-02 Thread Carlos
Hello: Are you willing to tell me that with NONE charset you can see Japaneese, Chinese, Czech and Ukrainian characters simultaneously? :)) IMHO, i will avoid the usage of NONE character set in the provider ( unless you are quite sure about what your are doing of course ), reasons are, using

Re: [Firebird-net-provider] Possible issue in

2007-11-02 Thread Jiri Cincura
On 11/2/07, Carlos [EMAIL PROTECTED] wrote: He can ask in the ODBC driver list how to set up it correctly to use UTF-8, and check if he is doing thinks the right way :) Yep. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
Jiri Cincura wrote: On 11/2/07, paha [EMAIL PROTECTED] wrote: Correct, but i would like to get from provider original localized messages for standard exceptions like concurrency to identify the exception itself, not to show it direct to user ;-) . It is not perfect, and must be avoided

Re: [Firebird-net-provider] Possible issue in FirebirdSql.Data.FirebirdClient - Charset.cs

2007-11-02 Thread Jiri Cincura
Changing to NONE does the same thing, that IBExpert do. Saving raw UTF-8 date into column without any interpretation. So that you match with IBEXpert. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

[Firebird-net-provider] Possible issue in FirebirdSql.Data.FirebirdClient - Charset.cs

2007-11-02 Thread Pave Sejrek
Hallo, I'm using: fbembed.dll - 2.0.3.12981 FirebirdSql.Data.FirebirdClient.dll - 2.1.0.0 my db is in UNICODE_FSS I was still having problems with encoding. Unicode strings saved from my .NET application were correctly writen and retrieved. But when reading these string over ODBC or in

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread Jiri Cincura
On 11/2/07, paha [EMAIL PROTECTED] wrote: Correct, but i would like to get from provider original localized messages for standard exceptions like concurrency to identify the exception itself, not to show it direct to user ;-) . It is not perfect, and must be avoided in any way, but if it

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
paha wrote: Could you give me direct link to bugtracker please :) I found it -- View this message in context: http://www.nabble.com/DBConcurrencyException-tf4731950.html#a13544215 Sent from the firebird-net-provider mailing list archive at Nabble.com.

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread Jiri Cincura
On 11/2/07, Carlos [EMAIL PROTECTED] wrote: putting them into the tracker will be the best. OK. Please, Paha, can you put every single problme into tracker, with description (try to use as much as possible info from this thread, etc.)? We'll look at it and it will be more clear. You can assing

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
Jiri Cincura wrote: On 11/2/07, Carlos [EMAIL PROTECTED] wrote: putting them into the tracker will be the best. OK. Please, Paha, can you put every single problme into tracker, with description (try to use as much as possible info from this thread, etc.)? We'll look at it and it will be

Re: [Firebird-net-provider] Possible issue in

2007-11-02 Thread Carlos
Hola: My vote is 1). But hard to say, whether you'll find ODBC driver with Unicode support (if this has no support). He can ask in the ODBC driver list how to set up it correctly to use UTF-8, and check if he is doing thinks the right way :) -- Carlos Guzmán Álvarez Vigo-Spain Blog

Re: [Firebird-net-provider] Possible issue in

2007-11-02 Thread Jiri Cincura
On 11/2/07, Pave Sejrek [EMAIL PROTECTED] wrote: OK, so what should I do? 1] put back encoding of UNICODE_FSS to UTF-8 and find replacements for DB client and ODBC driver. Currently I use IBExpert and ODBC Firebird/Interbase Driver by IBPhoenix. 2] keep the changed version and possibly have

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread Jiri Cincura
On 11/2/07, paha [EMAIL PROTECTED] wrote: Jiri Cincura wrote: Oh, now I understand. I was almost sleeping, so I was thinking wrong. So the main idea behind this is, when I get error, let the row untouched (without AcceptChanges) so I'll be able to repeat the call to DB, right?

Re: [Firebird-net-provider] Possible issue in

2007-11-02 Thread Pave Sejrek
OK, so what should I do? 1] put back encoding of UNICODE_FSS to UTF-8 and find replacements for DB client and ODBC driver. Currently I use IBExpert and ODBC Firebird/Interbase Driver by IBPhoenix. 2] keep the changed version and possibly have invalid unicode characters in my DB when using

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
Jiri Cincura wrote: One more little question, also about this Exceptions. What do you think about throwing localized messages? (I mean storing once (new DBConcurrencyException()).Message, (new DataException()).Message and so on somewhere in local dictionary, and using them instead of

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
Jiri Cincura wrote: On 11/2/07, paha [EMAIL PROTECTED] wrote: You are 100% right, i asked the same questions yesterday on russian forum to know, how sqladapter performs, but still no response. What i can say for sure, if you get DBConcurrencyException, you definitely should have

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread paha
Carlos Guzmán Álvarez ™ wrote: Hello: This may be not big problem to change. If there's no objection, I can do this. We should echeck what is being done by Sql Client if possible, and do the same thing. You are 100% right, i asked the same questions yesterday on russian forum to

Re: [Firebird-net-provider] DBConcurrencyException

2007-11-02 Thread Jiri Cincura
On 11/2/07, paha [EMAIL PROTECTED] wrote: I've got confirmation, that SqlDataAdapter do throws DBConcurrencyException when all row updates fail in ContinueUpdateOnError=true mode, and erroneous rows are not committed (RowVersion remains Modified). I'll test this myself. -- Jiri {x2} Cincura