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?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AxfordAAuthor Commented:
I have used both MS SQL Server and Sybase ASE databases with the same problem.

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?

AxfordAAuthor Commented:
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.
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

AxfordAAuthor Commented:
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?
AxfordAAuthor Commented:
I think that this is now closed.
PAQed with points refunded (250)

Community Support Moderator

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Editors IDEs

From novice to tech pro — start learning today.