- Apoorva JUKANTI
- PowerBuilder
- Tuesday, 21 May 2024 05:09 AM UTC
Hi,
We are migrating our application from SQL native client to ODBC 18 for SQL server driver, but facing an issue while using SELECTBLOB as the PBMAXBlobSize is default set to 32767.
Already tried updating the pbodb.ini, its working, but need it to be done through code.
Tried the sqlca.dbparm = "CONNECTSTRING='DSN=MSS2022;UID=MSS2022;PWD=MSS202212',PBCATALOGOWNER='MSS2022',DATASOURCE='DEVTEST',PBMaxBlobSize=1966020,DISABLEBIND=1"
But of no use, SELECTBLOB is not working as expected.
How can we increase the blob size while connecting to odbc driver using dbparm??
And if we have to use pbodb.ini, can the modified PBODB.ini be deployed with PBRuntime MSI?
Please suggest
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.