Problem Note 69064: Errors occur when bulk loading to Microsoft SQL Server and using the Microsoft ODBC Driver 18 for SQL Server
 |  |  |  |  |
When you use the Microsoft ODBC Driver 18 for SQL Server to connect to Microsoft SQL Server and use SAS/ACCESS® Interface to ODBC, SAS might fail if you specify bulkload=yes. If you are running in batch the following error occurs:
NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
ERROR: BRIDGE FAILURE - ERROR LOADING IMAGE
MODULE: sasbcp11sasxb D'
MODULE: sasbcp11sasxb D'
Traceback:
0000000008E827F5 000000000CD6D9D8 sasioodb:tkvercn1+0x317B5
0000000008EF6288 000000000CD6E698 sasxdbi:tkvercn1+0x15248
000000000CA74694 000000000CD6E758 sasyoio:tkvercn1+0x3654
0000000010018B40 000000000CD6EFE0 tkmk:tkBoot+0x16D90
0000000008EF6288 000000000CD6E698 sasxdbi:tkvercn1+0x15248
000000000CA74694 000000000CD6E758 sasyoio:tkvercn1+0x3654
0000000010018B40 000000000CD6EFE0 tkmk:tkBoot+0x16D90
ERROR: Unable to load transient module (Bridge failure).
Record written to the Windows event viewer:
Faulting application name: sas.exe, version: 9412.0.24363.19622, time stamp: 0x5f2b4cab
Faulting module name: ntdll.dll, version: 10.0.19041.1466, time stamp: 0xe2f8ca76
Exception code: 0xc0000374
Fault offset: 0x00000000000ff199
Faulting process id: 0x24e0
Faulting application start time: 0x01d828a447e1e9d6
Faulting application path: C:\Program Files\SASHome\SASFoundation\9.4\sas.exe
Faulting module path: C:\WINDOWS\SYSTEM32\ntdll.dll
Report Id: 0e86f753-6492-4ec4-928a-2e9167015730
Faulting package full name:
Faulting package-relative application ID:
Faulting application name: sas.exe, version: 9412.0.24363.19622, time stamp: 0x5f2b4cab
Faulting module name: ntdll.dll, version: 10.0.19041.1466, time stamp: 0xe2f8ca76
Exception code: 0xc0000374
Fault offset: 0x00000000000ff199
Faulting process id: 0x24e0
Faulting application start time: 0x01d828a447e1e9d6
Faulting application path: C:\Program Files\SASHome\SASFoundation\9.4\sas.exe
Faulting module path: C:\WINDOWS\SYSTEM32\ntdll.dll
Report Id: 0e86f753-6492-4ec4-928a-2e9167015730
Faulting package full name:
Faulting package-relative application ID:
A workaround is to use the Microsoft ODBC driver 17 for SQL Server.
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 | Windows 7 Ultimate 32 bit | 9.4 TS1M7 | 9.4 TS1M8 |
| Windows 7 Professional x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2022 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2019 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2016 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 11 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 10 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Microsoft® Windows® for x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M7 | 9.4 TS1M8 | ||
A fix for this issue for SAS/ACCESS Interface to ODBC 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J2X.html#69064| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-05-25 11:19:58 |
| Date Created: | 2022-04-07 14:33:44 |