Mega Code Archive

 

Categories / Delphi / ADO Database

 

Sql anywhere and blobs32k when requestlive=false

Question and Answer Database FAQ: FAQ4666B - SQL Anywhere and Blobs>32K when RequestLive=False Category: Database (ODBC) Platform: All-32Bit Product: BC++5.x, C++Builder1.0, C++Builder3.x, C++Builder4.x, Delphi2.x, Delphi3.x, Delphi4.x, VdBase7.x, Question: If I RequestLive=False with a TQuery, can I get blob data from SQL Anywhere greater than 32K? Answer: Not at this time. SQL Anywhere is not a certified driver and operates differently than any driver Inprise has certified. With other drivers, if Blob Size is set large enough, Data is Fetched successfully. With SQL Anywhere, even if Blob Size is large enough, the driver returns an error and fetching the data is unsuccessfull. TQueries with RequestLive=True appear to work because the exact size of the buffer is requested. Whereas when requestlive=false, your blobsize setting is used. If buffersize is too large, SQL Anywhere returns an error, whereas other ODBC Datasources do not.