Use the SuppressRowFormat2 connection string property to force Adaptive Server to send data using the TDS_ROWFMT byte sequence where possible instead of the TDS_ROWFMT2 byte sequence. TDS_ROWFMT contains less data than TDS_ROWFMT2—which includes catalog, schema, table, and column information—and can result in better performance for many small select operations. Because the server sends reduced result set metadata when SuppressRowFormat2 is set to 1, some information is not available to client programs. If your application relies on the missing metadata, you should not enable this property.
Values:
0 – the default value; TDS_ROWFMT2 is not suppressed.
1– forces the server to send data in TDS_ROWFMT where possible.
You should not use the SuppressRowFormat2 connection
string property with an ODBC program that uses the SQLBulkOperations
API. Enabling SuppressRowFormat2 suppresses information that SQL
bulk operations requires and will result in an error.
When you are connecting to Adaptive Server 15.7 ESD #1
or later, the SuppressRowFormat2 property should be considered obsolete.
Use the SuppressRowFormat connection property instead for better
performance results and lesser restrictions.
