Problem Note 5330: PROC APPEND to SQL Server using BCP option will insert data incorrectly
When using SAS/ACCESS to ODBC and PROC APPEND to append SAS
data to a Microsoft SQL Server table, the data might be inserted
incorrectly. This will occur if you define the field in the
SQL Server table as REAL and you are use the BCP data set option.
A fix for Release 8.1 is available at
http://www.sas.com/techsup/download/pc/odbc_81_fix.zip.
We have patches that can be downloaded from:
V8.2 SAS/ACCESS to DB2:
A Technical Support hot fix for this problem is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82d204
V8.2 SAS/ACCESS to ODBC :
A Technical Support hot fix for this problem is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82od02
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows NT Workstation | 8.1 TS1M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Professional | 8.1 TS1M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Server | 8.1 TS1M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 8.1 TS1M0 | 8.2 TS2M0 |
| Microsoft Windows 95/98 | 8.1 TS1M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 8.1 TS1M0 | 8.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines
Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity)
|
| Date Modified: | 2002-04-23 16:21:27 |
| Date Created: | 2001-06-28 16:46:33 |
