Clob fields

Hi folks,
I try to fetch some data which contains a clob field, nut
infortnatly I always get this error message:
[Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data
conversion
Anyone got an idea why and what I could do?
Storing data with my program and creating some clob data
works fine
Thx mates
- MAXX
| Content-Class: urn:content-classes:message
| From: "MAXX" <anonymous@.discussions.microsoft.com>
| Sender: "MAXX" <anonymous@.discussions.microsoft.com>
| Subject: Clob fields
| Date: Wed, 16 Jun 2004 00:46:09 -0700
| Lines: 15
| Message-ID: <1cce401c45375$fd39d000$a601280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcRTdf05/QBYPISzRweeDMzhVrkd7g==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6108
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| Hi folks,
|
| I try to fetch some data which contains a clob field, nut
| infortnatly I always get this error message:
| [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data
| conversion
|
| Anyone got an idea why and what I could do?
|
| Storing data with my program and creating some clob data
| works fine
|
| Thx mates
|
| - MAXX
|
Hello,
The Microsoft JDBC driver does not support getBlob/getClob. Unfortunately,
the error message does not accurately reflect this point. We are aware of
this problem and plan to address this sometime in the future. You will
have to use a different JDBC driver in order to retrieve BLOB/CLOB data.
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

CLOB & BLOB with microsoft JDBC driver ?

The microsoft JDBC driver doesn't accept CLOB & BLOB field.
Does anyone know about this problem ?
Is it possible to found another driver that works correctly and that is free ?
Thank'swhich driver u r using ?
is it jdbc-odbc.|||Sorry, I'm talking about TEXT object, and if i use the term BLOB it is for large binary object.
Do you know about my problem ?