Hi Mike;

Yes, all the SS DB connections need to have the PB App set the SQLCA DBParm field as follows:

SQLCA.DBParm = "Database='Chris',TrimSpaces=1,DelimitIdentifier=1,AppName='PowerBuilder',Host='STD-Chris',PBMaxTextSize=1024000"

where *PBMaxTextSize* is the key setting if you want to use anything > 32K. ;-)

However, this connection parameter *only* applies to the folloing SS DB drivers...

SNC SQL Native Client for Microsoft SQL Server

MSOLEDBSQL Microsoft OLE DB Driver for SQL Server

AFAIK: OLEDB does not support this.

FWIW: ODBC does support this setting but you would have to set that in the PBODB.ini file & then make sure that you deploy that INI with your PB App;s EXE.

HTH

Regards ... Chris

PBODB.ini also controls it (i assume) for oledb as it is used for other things:

"The PowerBuilder OLE DB interface file is required if your application uses OLE DB. The ODBC initialization file is required if you have used it to customize OLE DB settings:"



in any case, this the setting to have the datawindow char(32766) to be more than 32766 without manually editing the datawindow syntax