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
in sections [Microsoft SQL Server] and [SQL Server].
For DbParm, I have tried
In PB 12.5, we only had to set the parameter in pbodb125.ini to get this to work. What am I missing?