AxfordA
asked on
Larger Blobs in Powerbuilder
I am using PB9 on NT. I can save and load blobs from the database to a PB dw only when the blob is small (a few K). I can not load from the database when the blob is larger (> 100k). I am using an OLE control on the datawindow. Any suggestions?
Hi,
I have an autoupdate function in all my applications, I upload and download files (blobs) larger than 6MB in ASE 11.9.2. But it's not linked to an OLE in a datawindow but in a BLOB var.
To avoid concurrency I split my files in fragments of 32K when I upload to server. In download proccess I use standar FileWrite function which have a 32K limitation while saving, but as my file is already fragmented there is only a small processing to regenerate my file.
Can you post your function to load the blob?
BerX
I have an autoupdate function in all my applications, I upload and download files (blobs) larger than 6MB in ASE 11.9.2. But it's not linked to an OLE in a datawindow but in a BLOB var.
To avoid concurrency I split my files in fragments of 32K when I upload to server. In download proccess I use standar FileWrite function which have a 32K limitation while saving, but as my file is already fragmented there is only a small processing to regenerate my file.
Can you post your function to load the blob?
BerX
ASKER
Thanks,
I am using updateblob and selectblob to save and get the blobs respectfully. But it appear to only allow me to update files up to 32K into the blob. So are you saving that I need to have 100 records if I want to save a blob 3.2M, which I can do but what a pain. I was under the assumption that a blob was 4G. I would have thought that there is a configuration within Sybase that is causing the problem or is it the PB limitation as associated with file read.
I am using updateblob and selectblob to save and get the blobs respectfully. But it appear to only allow me to update files up to 32K into the blob. So are you saving that I need to have 100 records if I want to save a blob 3.2M, which I can do but what a pain. I was under the assumption that a blob was 4G. I would have thought that there is a configuration within Sybase that is causing the problem or is it the PB limitation as associated with file read.
ASKER
The problem is the odbc driver text size parameter. I changed to Open Client and upped the text size parameter and YEP it worked just great. Does anyone know the syntax for increasing the TEXTSIZE using ODBC?
ASKER
ASKER
I think that this is now closed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER