The driver supports DataDirect bulk load and its related connection options. Bulk load connection options are located on the Bulk tab of the driver Setup dialog box. See Using DataDirect Bulk Load for a general description of DataDirect bulk load and its implementation.
For Sybase, some additional database configuration is required when the destination table for a bulk load operation does not have an index defined. If you are using a destination table that does not have an index defined, you can ask the database operator to execute the following commands:
use master sp_dboption test, "select into/bulkcopy/pllsort", true
This option is required to perform operations that do not keep a complete record of the transaction in the log. For more information, refer to the Sybase documentation.
Alternatively, you can define an index on the destination table.
Failure to properly configure the database results in errors such as the following:
"You cannot run the non-logged version of bulk copy in this database. Please check with the DBO."
