Problem Note 37255: An error occurs when you write a SAS® data set to the Microsoft SQL Server
 |  |  |  |
The following error might occur when you write a SAS data set to the Microsoft SQL Server:
ERROR: BRIDGE FAILURE CALLING UNKNOWN." "ERROR: UNABLE TO LOAD sasbcp_n FOR SUBSYSTEM 447." "ERROR: Image sasbcp_n found but not loadable.
The error occurs when you submit a LIBNAME statement that specifies the following:
- A libref that is assigned to a Microsoft SQL Server 2008 database
- The ODBC engine
- The ODBC driver that is included in the Microsoft SQL Native Client v10
- The BCP=YES option
The following LIBNAME statement illustrates this scenario:
libname sqldb odbc noprompt="driver=sql server native client 10.0;
server=SQLServer; database=MyData;
trusted_connection=yes;" bcp=yes;
As a workaround, use the INSERTBUFF= LIBNAME option or the INSERTBUFF= data set option:
libname sqldb odbc noprompt="driver=sql server native client 10.0;
server=SQLServer; database=MyData;
trusted_connection=yes;" insertbuff=150;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 9.21_M1 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2013-01-24 10:48:18 |
| Date Created: | 2009-09-24 15:44:29 |