Error - F_JD20F2 DBMS Error Connection Is Not Enabled for BCP
Documentation: Error - F_JD20F2 DBMS Error Connection Is Not Enabled for BCP
Error: F_JD20F2: DBMS Error Connection Is Not Enabled for BCP
Issue
While using Bulk Refresh to load a table into a SQL Server target database, the following error appears:
F_JD20F2: DBMS error [[ODBC Driver xx for SQL Server]Connection is not enabled for BCP]
Environment
- DSS 6
- Bulk Refresh
- Target: SQL Server
Resolution
To resolve this issue, do the following:
- Clean up your existing driver versions.
- Download and install Microsoft ODBC Driver 17 for SQL Server on the DSS Agent machine.3. In DSS user interface, go to your SQL Server target location. 4. Go to the [**Database Connection**](/docs/dss6-user-interface-locations-location-details#databaseconnection) pane, then click **Edit**. 5. Click **Advanced Settings**. 6. In the ODBC drop-down menu, select **Automatic**. 7. Run the [**Refresh**](/docs/dss6-user-interface-channels-refreshing-data) operation.
If you do not use an DSS Agent, install the Microsoft ODBC Driver 17 for SQL Server on your DSS hub machine.
Cause
This issue occurs when using an unsupported ODBC Driver version during Bulk Refresh.