In an app I am working on I need to update a column in a Microsoft SQL Server database table with a PDF file.
I am using the Microsoft SQL Server ODBC connection.
The table (ISPDF02) has a column called ISPDF which is of data type IMAGE and a CHAR column ISNAME which is a primary key.
This app is running in PB11.5. The pbodb115.ini file has PBMAXBLOBSIZE=2147483647 and PBMAXTEXTSIZE=2147483647,
The PDF file is read into a blob variable lb_blob.
On executing: updateblob ispdf02 set ispdf02.ispdf = :lb_blob where ispdf02.isname = :ls_name using mytr;
This works fine EXCEPT I get this error whenever the size of lb_blob is greater than approx 409,000 bytes:
Error updating ISPDF02.ISPDF SQLSTATE = S1010 [Microsoft][ODBC Driver Manager] Function sequence error
Any ideas? Suggestions? I read that IMAGE is deprecated. I get the same result with VARBINARY(max).