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

• HVR 6
• Bulk Refresh
• Target: SQL Server

Resolution

To resolve this issue, do the following:

1. Clean up your existing driver versions.
2. Download and install Microsoft ODBC Driver 17 for SQL Server on the HVR Agent machine.
   If you do not use an HVR Agent, install the Microsoft ODBC Driver 17 for SQL Server on your HVR hub machine.

3. In HVR user interface, go to your SQL Server target location.
4. Go to the Database Connection pane, then click Edit.
5. Click Advanced Settings.
6. In the ODBC drop-down menu, select Automatic.
7. Run the Refresh operation.

Cause

This issue occurs when using an unsupported ODBC Driver version during Bulk Refresh.