Re: Losing first four characters of a LONG

From: Jay Valdez <jay_at_dontspamme.com>
Date: Wed, 3 Oct 2001 09:04:01 -0700
Message-ID: <AIGu7.2119$3x.7545@news.bc.tac.net>

After some hair pulling...

The solution to the problem is to replace the Oracle ODBC driver with the latest Microsoft ODBC driver for Oracle. Works better with ADO too.

Thanks,

Jay

"Jay Valdez" <jay_at_dontspamme.com> wrote in message news:RZmu7.2107$3x.7518_at_news.bc.tac.net...
>
> Hello,
>
> As in my previous posts. I am an SQL Server person doing some proof of
> concept work in Oracle. Basically converting some components an existing
> *.asp application running off SQL Server to assess how it could be easily
> converted to Oracle (and still use *.asp)
>
> Thanks for all the responses to my questions from all the folk.
>
> I appear to be experiencing some sort of anomaly with short data in the
LONG
> field. I am storing pretty much ordanary text (more like strips of HTML)
> code that I query from and assemble into various web pages. The longest
> text strip is abour 11,000 characters. I have been using the ADO GetChunk
> method to retrieve the data (in 8K portions).
>
> I have noted that:
>
> (1) When the data is short like "<HTML><BODY>", I end up with something
like
> "ODY>"
> (2) When it is short, it is also possible to retreive the data without
using
> GetChunk --> rst.Fields("HTMLCHUNK").Value
>
> Anybody have any idea why this is happening, and suggest a workaround.
>
> I am using the Oracle ODBC Driver 8.01.06
>
>
> Jay
>
>
>
>
>
>
Received on Wed Oct 03 2001 - 11:04:01 CDT