dbTalk Databases Forums  

What is the buffer limit for SQLPutData()?

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss What is the buffer limit for SQLPutData()? in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Al Koch
 
Posts: n/a

Default What is the buffer limit for SQLPutData()? - 11-15-2004 , 12:35 PM






Hello,

I am using SQLPutData() in a loop to move a large BLOB (3MB in total) to and
from the database and when I retrieve the BLOB I find that a large section
of data has been replaced with the "BAADF00D" data sequence. This is used
in many cases to init memory, including, I believe, by XP to init the Heap.
Whatever the source, my data is getting trashed and I suspect it may be
caused by processing too much data in a single call to SQLPutData() because
this problem is occurring when I transfer 128k blocks of data in a single
call to SQLPutData() but disappears when I only transfer 32k at a time

I cannot find any information on SQLPutData() that discusses a maximum
buffer size that can be transferred in a single call, yet I suspect that
there must be a limit.

Can anyone point me to some documentation that specifies a limit?

Thanks,
Al Koch
AlKoch (AT) MyRealBoxREMOVEALLTHESECHARS (DOT) com



Reply With Quote
  #2  
Old   
Chris Keating \(iAnywhere Solutions\)
 
Posts: n/a

Default Re: What is the buffer limit for SQLPutData()? - 11-26-2004 , 09:37 AM






It is 32k. I cannot recall exactly where this is documented but I had seen
in in the ODBC SDK documentation.


"Al Koch" <AlKoch (AT) MyRealBox (DOT) com> wrote

Quote:
Hello,

I am using SQLPutData() in a loop to move a large BLOB (3MB in total) to
and
from the database and when I retrieve the BLOB I find that a large section
of data has been replaced with the "BAADF00D" data sequence. This is used
in many cases to init memory, including, I believe, by XP to init the
Heap.
Whatever the source, my data is getting trashed and I suspect it may be
caused by processing too much data in a single call to SQLPutData()
because
this problem is occurring when I transfer 128k blocks of data in a single
call to SQLPutData() but disappears when I only transfer 32k at a time

I cannot find any information on SQLPutData() that discusses a maximum
buffer size that can be transferred in a single call, yet I suspect that
there must be a limit.

Can anyone point me to some documentation that specifies a limit?

Thanks,
Al Koch
AlKoch (AT) MyRealBoxREMOVEALLTHESECHARS (DOT) com





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.