accessing "blob" objects with crystal reports 8

[uksub]

i have signatures stored as "bmp" in sql 2000. i can retrieve the signatures (stored in an image field) when i use an odbc as the datasource. the problem is when i try to access the bitmap signatures using a store procedure. i get an error saying that the data type is not "supported". whats the difference between the odbc which works and the stored procedure that does'nt work. are there parameters i need to include in my stored procedure?

 

[NathanGriffiths]

From Books Online ('Retrieving text, ntext or image values'):

You can retrieve ntext, text or image values by:

Simply referencing the column in a SELECT statement.
For example, this query returns all information in the pr_info column for each publisher:

USE pubs
SELECT pr_info
FROM pub_info

This is the method used in a database application using an API such as ADO, OLE DB, ODBC, or DB-Library. The column is bound to a program variable, and then a special API function or method is used to retrieve the data one block at a time.

When this method is used in Transact-SQL scripts, stored procedures, and triggers, it works only for relatively short values. If the length of the data is longer than the length specified in SET TEXTSIZE, you must use increase TEXTSIZE or use another method. The current TEXTSIZE setting is reported by the @@TEXTSIZE function and is changed with the SET TEXTSIZE statement:

SET TEXTSIZE 64512

The default setting for TEXTSIZE is 4096 (4 KB). This statement resets TEXTSIZE to its default value:

SET TEXTSIZE 0

The full amount of data is returned if the length is less than TEXTSIZE.

Hope that helps,




Nathan