To enable LOB locator support in Adaptive Server ODBC Driver, establish a connection to Adaptive Server with the EnableLOBLocator connection property set to 1. When EnableLOBLocator is set to 0, the default value, the Adaptive Server ODBC Driver cannot retrieve a locator for a LOB column. When enabling LOB Locators, the connection should be set to autocommit off.
You must also include the sybasesqltypes.h file in your program. The sybasesqltypes.h file is located in the include directory, under the ODBC installation directory.
LOB Locators can be used reliably when the application
is linked directly to the driver. When a driver manager is used
and LOB Locators are used, some driver managers may restrict the
use of vendor defined C and SQL Types and the application may encounter
an "Unsupported Type" error.
