Solved it myself. The problem was in the definition of the parameter of
the stored proc.

NOTE BLOB

I needed something like

NOTE BLOB SUB_TYPE 1 SEGMENT SIZE 80

Joe Garry
Software Engineer
US Biometrics


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Sunday, September 04, 2005 6:47 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] problems with .net provider`

At 04:39 PM 4/09/2005 -0500, you wrote:

>I can't get access to the .net provider mailing list, so here I am.

I've subscribed you as jgarry@....

As a consideration to others, you should avoid posting messages and
requests to list servers in non-plain-text formats. Some of the
Sourceforge list servers seem to enforce this rule.

>The .net provider promises:
>
> "Transparent Text BLOB Support
>BLOB fields with TEXT subtype can be accessed as strings

transparently."

>
>
>
>Not true. I had to do something like the following:
>
>
>
>byte[] chr = new byte[500];
>
>myReader.GetBytes(2, 0, chr, 0, 500);
>
>
>
>Has anyone else run into this?

Firebird doesn't read text blobs as strings. What it can do is accept a

string as input to a text blob for inserts and updates; and it can
accept
some string functions in search expressions.

So you do need to post to the firebird-net-provider list to find out
exactly how to make the .net provider read a text blob as a string (or
to
alert the developer to a possible documentation error...)

^ heLen





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links









[Non-text portions of this message have been removed]