Incomplete retrieval from SYBASE using ADO

Hi all,

I have an asp page which reads files from SYBASE that are stored as IMAGE
data type

It appears that there only 1MB of data is retrieved, although data_length
had suggest that there are 5 MB ++ worth of data.
And because of that , the document does open at all cos of the incomplete data

And using an interactive tool, i am able to export the file out completely (
5MB ++), so I know that the saving into the DB is working ok.

Any idea if there is some limit to the data retrieved via ADO from SYBASE
into an ASP page?

Thanks
Shirley

RE: Incomplete retrieval from SYBASE using ADO

May I also add that the pages work fine for files less than 1 MB.
It was able to retrieve those files and display them correctly.

RE: Incomplete retrieval from SYBASE using ADO

It is an ODBC default DefaultLongDataBuffLen, that had limited the retrieval
to 1MB.
We can manipulate this value thru setting it in the connection string and
now big files are opening fine

Example of my connectionString where DefaultLongDataBuffLen is set to a
1024X6.

myConnString = "DRIVER={" & driver & "};" & _
"SRVR=" & server & ";" & _
"DATABASE=" & db & ";" & _
"APP=app; DefaultLongDataBuffLen=6144 "

RE: Incomplete retrieval from SYBASE using ADO

And may I add that I had a lot of help from my brilliant colleague, Mister
Kumar Anil, for sorting this out.