For ADS v14, we enabled BCP import by default by setting ENABLE_BULK_LOAD=BCP for Sybase related DBs. (ASE & IQ). After conducting many tests, we've determined that certain necessary conditions need to be met before the user can successfully use the BCP Import. So, I'd like to modify the design as follows:

For Sybase IQ:

-- When we create a connection for import, if the server registration property of 'iAnywhere' is set to true, then set ENABLE_BULK_LOAD=BCP

-- When user gets to the Transaction tab of the import wizard, introduce a checkbox field called "Enable BCP (for extremely fast imports)". Description should read: Imports are significantly faster if BCP (Bulk Copy) is enabled. To enable Bulk Copy, you must be using the iAnywhere driver. For instructions on setting up the iAnywhere, <click here>. If iAnywhere is set to true, default this checkbox to enabled and checked. If iAnywhere is set to false, default this checkbox to not checked and disabled.

-- If user toggles the BCP checkbox and clicks next or previous, you will need to close the current connection and create a new connection (b/c connection properties can only be set at conn creation time).

For Sybase ASE:

-- When we create a connection for import, set ENABLE_BULK_LOAD=BCP

-- When user gets to the Transaction tab of the import wizard, introduce a checkbox field called "Enable BCP". Description should read: Imports are significantly faster if BCP (Bulk Copy) is enabled. To enable Bulk Copy, you must 1) Enable 'select into/bulkcopy/pllsort' on your database by executing sp_dboption <dbname>, 'select into/bulkcopy/pllsort', true. To determine whether this value is already enabled, you may execute sp_helpdb <dbname> and if the status column contains select into/bulkcopy/pllsort, then this option is enabled. 2) Ensure that you are using the [Default] charset. You can check your current charset by going to Server Properties > Advanced tab > Charset.

-- If user toggles the BCP checkbox and clicks next or previous, you will need to close the current connection and create a new connection (b/c connection properties can only be set at conn creation time).

Separately, remove isValid() check or only do this check for Sybase ASE & IQ