skip to main content
OpenEdge Data Management: DataServer for ODBC
Troubleshooting : Tuning your environment with the -Dsrv startup parameter : Using ODBC and DataServer options : Large rows: The PRGRS_MINBUF option
 
Large rows: The PRGRS_MINBUF option
Some data rows can be very large; for example, in a Sybase data source, rows often have large fields such as IMAGE and MEMO. The ODBC protocol specifies a dynamic buffer allocation process for handling large rows that do not initially fit into clients' buffers; however, some drivers do not yet follow the correct ODBC protocol and do not handle these large rows correctly. Use the -Dsrv PRGRS_MINBUF,size option to force a minimum buffer size. For example, -Dsrv PRGRS_MINBUF,15000 enables the DataServer to handle 15K rows even with drivers that fail to follow the ODBC protocol.
Note: It is often difficult to determine when there is a buffer size problem and how to choose the correct value for PRGRS_MINBUF. Be careful when using this option.