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.