[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Larger Blobs in Powerbuilder

Posted on 2004-11-17
8
Medium Priority
?
1,041 Views
Last Modified: 2013-12-26
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?
0
Comment
Question by:AxfordA
  • 5
7 Comments
 
LVL 1

Author Comment

by:AxfordA
ID: 12604854
I have used both MS SQL Server and Sybase ASE databases with the same problem.
0
 
LVL 5

Expert Comment

by:berXpert
ID: 12615461
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
0
 
LVL 1

Author Comment

by:AxfordA
ID: 12616155
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.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Author Comment

by:AxfordA
ID: 12616912
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?
0
 
LVL 1

Author Comment

by:AxfordA
ID: 12623415
I think that this is now closed.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12848557
PAQed with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question