Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Troubleshooting : ODBC options : Using MS SQL Server and DataServer options : Key-buffer size: the PRGRS_IDBUF option
 
Key-buffer size: the PRGRS_IDBUF option
The PRGRS_IDBUF option sets the size of the keys buffer. Generally, a default of 25 keys is sufficient. If the ODBC driver being used to access the MS SQL Server database has preserved cursors enabled across a transaction boundary, the keys buffer is used with all non-lookahead cursors. If the driver does have preserved cursors enabled, the PROGRS_IDBUF value and the keys buffer are unused.