Re: Need help with clob datatype and ADO

Which version of ADO are you using?

You need to use ADO 2.6 or 2.7

when specifing the CLOB column you need to the parameter object and specify a adLongVarChar datatype

Also, post some code

"Marc Robitaille" <marcmarie_at_videotron.ca> wrote in message news:oOsp9.2952$PU2.153879_at_wagner.videotron.net...
> Hello,
>
> We bought an application which functions with SQLServer 2000. This
> application is a Web application and uses ADO with COM+ objects. The COM+
> objects are written in VB whereas the Web part is in ASP. We wish to make
> function this application with our Oracle 8i server. In the data base
> SQLServer 2000, there are several fields of the Text datatype. In the
update
> with Oracle, these fields became clob. The application functions correctly
> except for the fields clob. Recordset contains only the first 255
> characters!!!!!.
> A fellow-member at works suggested me changing the client cursor to a
> server cursor. When we roll the application in debug, the contents of the
> field contain more than 255 characters but as it is a Web application, at
> the end of each request to the server, the connection is closed.
Therefore,
> we lose information. I also read that certain Oracle datatypes are not
> supported by ADO!!!!!
> Is there somebody who have an idea on the way of obtaining the contents
of
> this field with ADO or perhaps we do not use the good datatype field? ?
>
> Thank you very much
> excuse my bad english
>
> Marc Robitaille
>
>
>
>
>
>
Received on Sun Oct 13 2002 - 05:29:46 CEST