1. 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?

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"


Regards .. Chris

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.