Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved BLOBS > 32k

  1. Issue
0
Votes
Undo
  1. Mark Winsor
    Mark Winsor
  2. PowerBuilder
  3. Friday, 21 September 2018 15:04 PM UTC

When getting a blob using SQL server, I only get the first 32767 bytes even though I have updated the max blob size in the pbodb170.ini file. Is there somewhere new where I have to alter this?

ASA12 Runtime installed as 32 or 64 bit?
How to use mailFileDescription.position property?
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 21 September 2018 15:22 PM UTC
  2. PowerBuilder
  3. # 1

Hi Mark;

   You can also use the DBParm field, for example  ...

SQLCA.DBParm = "ConnectString='DSN=SS2017;UID=sa;PWD=<******>;PBMaxBlobSize=1000000',Async=1,DBGetTime=5,ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT',PacketSize=2048"

HTH

Regards .. Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.