[Firebird-odbc-devel] odbc DRIVER AND blob FIELDS

[Hussain, S. (UK - Epsom) <shu...@bw...>]

Can you use the ODBC driver to return BLOB fields. My SQL statement is:

	SELECT Documentation FROM ADOBJECT;

where Documentation is a BLOB field. I am using the latest ODBC driver and
using it in ADO 2.1 with VB6 SP5. If I ask for any other field in the
ADOBJECT table the SQL returns a recordset with no problems. However
requesting the Documentation fields causes a fatal exception and crashes the
whole VB environment!! I assume the fact that it is a BLOB field is the
probem.

Is this supported?

Any comments/help would be appreciated.

Regards
Marc fakkel





____________________________________
Saiyid T.E. Hussain		B&W Deloitte

Tel:	          +44 1372 824000	Horizon House
Direct Dial:           +44 1372 824180*	28 Upper Street        
Fax:                    +44 1372 802824 *	Epsom, Surrey
<mailto:shu...@bw...> *	KT17 4RS  
www.bw-deloite.com			 

IMPORTANT NOTICE

This communication contains information which is confidential and may also
be privileged.

It is for the exclusive use of the intended recipient(s).

If you are not the intended recipient(s) please note that any form of
distribution, copying or use of this communication or the information in it
is strictly prohibited and may be unlawful.

If you have received this communication in error please return it (with the
title "received in error") to the sender then delete the email and destroy
any copies of it.  We would be grateful if you would also copy the
communication to IT....@de...

This communication is from Deloitte & Touche whose principal office is at
Stonecutter Court, 1 Stonecutter Street, London, EC4A 4TR, United Kingdom.
A list of partners' names is available at this address.

Deloitte & Touche is authorised by the Financial Services Authority in
respect of regulated activities.