When using SAS/ACCESS Interface to ODBC, you might receive an error similar to the following:

ERROR: BRIDGE FAILURE - ERROR LOADING IMAGE
MODULE: SASBCP10SASXB

The problem occurs under the following conditions:

• You use SAS/ACCESS^® Interface to ODBC to connect to Microsoft SQL Server.
• You set BULKLOAD=YES.
• You use a Microsoft Windows 10 operating system.

This problem occurs because the following ODBC driver versions have problems with bulk loading:

• the version 10 driver (typically, it is version 10.0.14393.0 or a similar number)
• the version 13 driver (typically, it is version 2015.131.4413.46 or a similar number)

To circumvent the problem, do one of the following:

• Upgrade to SAS^® 9.4M5 (TS1M5) of the SAS system and install the latest Microsoft SQL Server Native Client 13 driver.
• Use the INSERTBUFF= option in your LIBNAME statement instead of BULKLOAD=.