date:20080804

Re: [Firebird-net-provider] [firebird-support] Not convert to UNICODE in Embeded

2008-08-04 Thread Dean Harding

Pham Huu Le Quoc Phuc wrote:
> Thanks for your reply,
> 
> When my program catches exception, it gets message property from Exception.
> I sure 100% I write "correct code" because it works OK! on SuperServer.
> But when I connect by Embedded(with the same connection string, I just
> modify server type), message of Exception still UTF8. In my opinion, this
> bug in Firebird .Net

Please include a sample of the messages you get from SuperServer and 
from Embedded.

As I mentioned in the last email, there is no such thing as a "UTF-8 
string" in .NET -- strings are opaque. It is possible that .net provider 
is interpreting the encoding incorrectly and you end up with garbage 
instead, but I would need to see samples of the strings to confirm.

Also, on including samples of your code -- it's not about whether you've 
written "correct code" or not, I do not doubt you. However code samples 
help the developers to reproduce the problem themselves much more simply 
than just a vague description.

Dean.

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
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-support] Not convert to UNICODE in Embeded

2008-08-04 Thread Pham Huu Le Quoc Phuc

Thanks for your reply,

When my program catches exception, it gets message property from Exception.
I sure 100% I write "correct code" because it works OK! on SuperServer.
But when I connect by Embedded(with the same connection string, I just
modify server type), message of Exception still UTF8. In my opinion, this
bug in Firebird .Net

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Tuesday, August 05, 2008 10:44
To: For users and developers of the Firebird .NET providers
Cc: [EMAIL PROTECTED]
Subject: Re: [Firebird-net-provider] [firebird-support] Not convert to
UNICODE in Embeded

Pham Huu Le Quoc Phuc wrote:
> Anybody fall into this problem. Please help me.

It's only been a few hours, have patience. Many people on this list will 
be asleep at the moment.

In the meantime, I would suggest you try to provide some more 
information about the problem you're seeing. As a quick guess, I'd say 
this is something to raise on the .net provider list, but you'll need to 
include some more information first. For example:

1. What does the stored procedure code look like?
2. What does your C# code that is catching the exception look like?
3. What does the message display as when it works (from SuperServer)
4. What does the message display as when it does not work (from Embedded)

UTF-8 *is* unicode, so your assertion that "UNICODE" and "UTF-8" are 
somehow different does not make sense. UTF-8 is one method of encoding 
unicode and I'm assuming when you say "UNICODE" you actually mean 
UTF-16.  Additionally, string in .NET are opaque data structures -- 
there is no such thing as a "UTF-8 string" or a "UTF-16 string" in C#.

Dean.



-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
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-support] Not convert to UNICODE in Embeded

2008-08-04 Thread Dean Harding

Pham Huu Le Quoc Phuc wrote:
> Anybody fall into this problem. Please help me.

It's only been a few hours, have patience. Many people on this list will 
be asleep at the moment.

In the meantime, I would suggest you try to provide some more 
information about the problem you're seeing. As a quick guess, I'd say 
this is something to raise on the .net provider list, but you'll need to 
include some more information first. For example:

1. What does the stored procedure code look like?
2. What does your C# code that is catching the exception look like?
3. What does the message display as when it works (from SuperServer)
4. What does the message display as when it does not work (from Embedded)

UTF-8 *is* unicode, so your assertion that "UNICODE" and "UTF-8" are 
somehow different does not make sense. UTF-8 is one method of encoding 
unicode and I'm assuming when you say "UNICODE" you actually mean 
UTF-16.  Additionally, string in .NET are opaque data structures -- 
there is no such thing as a "UTF-8 string" or a "UTF-16 string" in C#.

Dean.



-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
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-support] Not convert to UNICODE in Embeded

2008-08-04 Thread Pham Huu Le Quoc Phuc

Anybody fall into this problem. Please help me.

 

  _  

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Pham Huu Le Quoc Phuc
Sent: Tuesday, August 05, 2008 07:46
To: [EMAIL PROTECTED]
Cc: 'For users and developers of the Firebird .NET providers'
Subject: [Firebird-net-provider] [firebird-support] Not convert to UNICODEin
Embeded

 

Hi all,

I use Firebird 2.1.1, Windows XP SP3, Firebird .Net 2.1, UNICODE_FSS for all
database data, .Net 2.0, VS2008.

I write a procedure, it thows an exception with message that select from a
table. My program catches exception and show message to user.

All's OK if I use SuperServer, the message show in UNICODE. But when I try
to connect by Embedded, the message is UTF-8.

I think this is a bug? At Core or Firebird .Net?

 

Regard,

Phucphlq

www.tonyvn.com  

 

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [firebird-support] Not convert to UNICODE in Embeded

2008-08-04 Thread Pham Huu Le Quoc Phuc

Hi all,

I use Firebird 2.1.1, Windows XP SP3, Firebird .Net 2.1, UNICODE_FSS for all
database data, .Net 2.0, VS2008.

I write a procedure, it thows an exception with message that select from a
table. My program catches exception and show message to user.

All's OK if I use SuperServer, the message show in UNICODE. But when I try
to connect by Embedded, the message is UTF-8.

I think this is a bug? At Core or Firebird .Net?

 

Regard,

Phucphlq

www.tonyvn.com  

 

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

2008-08-04 Thread Jiri Cincura

On Mon, Aug 4, 2008 at 11:54 PM, zeko77 <[EMAIL PROTECTED]> wrote:
> If it is not too much trouble, I would ask you for link to latest source if
> possible.

RTFM http://www.firebirdsql.org/index.php?op=devel&sub=netprovider

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

2008-08-04 Thread zeko77


You are right.
It seems that the source I downloaded and targeted for framework 2.0 was
outdated.
I used last weekly build and it works.

Thank you very much.
If it is not too much trouble, I would ask you for link to latest source if
possible.
Best regards


Jiri Cincura wrote:
> 
> SQL> create exception rrr 'RRRrrrRRR';
> SQL> set term !!; create procedure U as begin exception rrr; end!! set
> term ; !!
> 
> using (FbConnection conn = new
> FbConnection(@"database=localhost/3050:rrr.fdb;user=sysdba;password=masterkey"))
> {
> conn.Open();
> using (FbCommand cmd = conn.CreateCommand())
> {
> cmd.CommandText = "U";
> cmd.CommandType =
> System.Data.CommandType.StoredProcedure;
> cmd.ExecuteNonQuery();
> }
> }
> 
> FirebirdSql.Data.FirebirdClient.FbException,
> FirebirdSql.Data.FirebirdClient, Version=2.5.0.0, Culture=neutral,
> PublicKeyToken=3750abcc3150b00cRRR
> RRRrrrRRR
> At procedure 'U' line: 1, col:
> 29FirebirdSql.Data.FirebirdClient.FbException:
> RRR
> RRRrrrRRR
> At procedure 'U' line: 1, col: 29 ---> RRR
> RRRrrrRRR
> At procedure 'U' line: 1, col: 29
>--- End of inner exception stack trace ---
>at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
> 
> [snip]
> 
> RRR
> RRRrrrRRR
> At procedure 'U' line: 1, col:
> 29
> 
> Using the current weekly build.
> 
> -- 
> Jiri {x2} Cincura (CTO x2develop.com)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
> 
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the
> world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Database-level-exceptions-and-FBExceptions-problem-tp18817844p18820638.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

2008-08-04 Thread Jiri Cincura

SQL> create exception rrr 'RRRrrrRRR';
SQL> set term !!; create procedure U as begin exception rrr; end!! set term ; !!

using (FbConnection conn = new
FbConnection(@"database=localhost/3050:rrr.fdb;user=sysdba;password=masterkey"))
{
conn.Open();
using (FbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "U";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
}

FirebirdSql.Data.FirebirdClient.FbException,
FirebirdSql.Data.FirebirdClient, Version=2.5.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00cRRR
RRRrrrRRR
At procedure 'U' line: 1, col:
29FirebirdSql.Data.FirebirdClient.FbException:
RRR
RRRrrrRRR
At procedure 'U' line: 1, col: 29 ---> RRR
RRRrrrRRR
At procedure 'U' line: 1, col: 29
   --- End of inner exception stack trace ---
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()

[snip]

RRR
RRRrrrRRR
At procedure 'U' line: 1, col:
29

Using the current weekly build.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

2008-08-04 Thread zeko77


Thanx for fast response.

The problem is that i throw
"WEB_PLAYER_USERNAME_EXEPTION" with message "Username already exists!"
in stored proc
WEB_PLAYER_I if username already exists.

The content of FBException message is:

"No message for error code 335544382 found.\r\nNo message for error code
335544382 found.\r\nAt procedure 'WEB_PLAYER_I' line: 33, col: 13"

The only way to identify the exception is "line:33" part.
And routine breaks if this changes in stored proc.

So FbException does not mention WEB_PLAYER_USERNAME_EXEPTION or Username
already exists!
anywhere in message, or in error collection.




Jiri Cincura wrote:
> 
> On Mon, Aug 4, 2008 at 9:21 PM, zeko77 <[EMAIL PROTECTED]> wrote:
>>
>> I am using 2.5.0 alpha 2 provider.
> 
> Use 2.1 whis is considered as stable.
> 
>> The problem is that if a throw an exception in stored proc or trigger, i
>> get
>> 'No message for error code 335544382 found.
>> At procedure 'XYZ' line x etc...'
>> The only way to identify exception is to get line number, whisch is
>> cumbersome at least.
> 
> You're probably mixing two things together. First look at
> http://tracker.firebirdsql.org/browse/DNET-162.
> 
>> Why not get an EXCEPTION_NAME or exception message?
>> Was this working before, and now is broken?
>>
>> I know that there were some problems with resource file and other
>> messages
>> were not
>> available, but i don't now if this was relevant for custom db exceptions.
>>
> 
> You should get the message from exception on server side in message of
> FbException.
> 
> -- 
> Jiri {x2} Cincura (CTO x2develop.com)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
> 
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the
> world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Database-level-exceptions-and-FBExceptions-problem-tp18817844p18819032.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

2008-08-04 Thread Jiri Cincura

On Mon, Aug 4, 2008 at 9:21 PM, zeko77 <[EMAIL PROTECTED]> wrote:
>
> I am using 2.5.0 alpha 2 provider.

Use 2.1 whis is considered as stable.

> The problem is that if a throw an exception in stored proc or trigger, i get
> 'No message for error code 335544382 found.
> At procedure 'XYZ' line x etc...'
> The only way to identify exception is to get line number, whisch is
> cumbersome at least.

You're probably mixing two things together. First look at
http://tracker.firebirdsql.org/browse/DNET-162.

> Why not get an EXCEPTION_NAME or exception message?
> Was this working before, and now is broken?
>
> I know that there were some problems with resource file and other messages
> were not
> available, but i don't now if this was relevant for custom db exceptions.
>

You should get the message from exception on server side in message of
FbException.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Database level exceptions and FBExceptions problem

2008-08-04 Thread zeko77


I am using 2.5.0 alpha 2 provider.
The problem is that if a throw an exception in stored proc or trigger, i get
'No message for error code 335544382 found.
At procedure 'XYZ' line x etc...'
The only way to identify exception is to get line number, whisch is
cumbersome at least.

Why not get an EXCEPTION_NAME or exception message?
Was this working before, and now is broken?

I know that there were some problems with resource file and other messages
were not 
available, but i don't now if this was relevant for custom db exceptions.

Any pointers on this one?
-- 
View this message in context: 
http://www.nabble.com/Database-level-exceptions-and-FBExceptions-problem-tp18817844p18817844.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
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-support] Not convert to UNICODE in Embeded

Re: [Firebird-net-provider] [firebird-support] Not convert to UNICODE in Embeded

Re: [Firebird-net-provider] [firebird-support] Not convert to UNICODE in Embeded

Re: [Firebird-net-provider] [firebird-support] Not convert to UNICODE in Embeded

[Firebird-net-provider] [firebird-support] Not convert to UNICODE in Embeded

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

Re: [Firebird-net-provider] Database level exceptions and FBExceptions problem

[Firebird-net-provider] Database level exceptions and FBExceptions problem

11 matches

Site Navigation

Mail list logo

Footer information