- Don Olliver
- PowerBuilder
- Wednesday, 13 June 2018 08:47 PM UTC
We are connecting to SQL Server using ODBC Driver 11. Any embedded SQL using SELECTBLOB or UPDATEBLOB truncates data at 32K, which is the default for a SQL Server driver.
I have been unable to modify the default size to 1 GB, either by setting PBMaxBlobSize in pbodb170.ini or in the transaction object's DbParm property.
In the INI file, we set
PBMaxBlobSize='1073741824'
in sections [Microsoft SQL Server] and [SQL Server].
For DbParm, I have tried
ConnectString='DSN=esepicdev11_mssql_2014;PBMaxBlobSize=1073741824'
and
ConnectString='DSN=esepicdev11_mssql_2014',PBMaxBlobSize=1073741824
In PB 12.5, we only had to set the parameter in pbodb125.ini to get this to work. What am I missing?
Thanks,
Don Olliver
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.