Problem Note 64705: The "BRIDGE FAILURE..." error occurs when you bulk load to Microsoft SQL Server and use the Microsoft SQL Server Native Client 17 ODBC driver
 |  |  |  |  |
When using SAS/ACCESS® Interface to ODBC, you might receive an error similar to the following:
ERROR: BRIDGE FAILURE - ERROR LOADING IMAGE
MODULE: sasbcp11sasxb ä–ê_ SUBSYSTEM: 456 SLOT: 2
Traceback:
00000000052F1625 000000000A18E8D8 sasioodb:tkvercn1+0x305E5
00000000054959E8 000000000A18EB58 sasxdbi:tkvercn1+0x149A8
0000000005B34594 000000000A18EC18 sasyoio:tkvercn1+0x3554
0000000005C7907A 000000000A18F428 sassqx:tkvercn1+0x1803A
0000000005C77EA5 000000000A18F7F0 sassqx:tkvercn1+0x16E65
0000000005C79B09 000000000A18F850 sassqx:tkvercn1+0x18AC9
0000000005C9D429 000000000A18F8B0 sassqx:tkvercn1+0x3C3E9
0000000005C956F5 000000000A18F9D0 sassqx:tkvercn1+0x346B5
0000000005C94B6E 000000000A18FB40 sassqx:tkvercn1+0x33B2E
00000000089C13B2 000000000A18FB48 sassql:tkvercn1+0x372
0000000001BDA066 000000000A18FF20 sashost:Main+0x11BA6
0000000001BE011D 000000000A18FF50 sashost:Main+0x17C5D
00007FFD22E813D2 000000000A18FF58 KERNEL32:BaseThreadInitThunk+0x22
00007FFD238654F4 000000000A18FF88 ntdll:RtlUserThreadStart+0x34
ERROR: Unable to load transient module (Bridge failure).
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 the Microsoft SQL Server Native Client 17 ODBC driver.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for x64 | 9.4 TS1M5 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
A fix for this issue for SAS/ACCESS Interface to ODBC 9.4_M5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B7V.html#64705| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-04-07 14:56:03 |
| Date Created: | 2019-08-28 13:18:17 |