SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 13283: Setting INSERTBUFF with the PCFILES engine on UNIX gives CLI error

DetailsHotfixAboutRate It
Setting INSERTBUFF with the PCFILES engine leads to an error when
creating tables in a MS Access database (and probably other data
source too).  You will recieve the following error message:

  ERROR: CLI execute error: [Microsoft][ODBC Microsoft Access Driver]
         The field is too small to accept the amount of data you
         attempted to add.  Try inserting or pasting less data.


A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013283

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#013283


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to PC Files64-bit Enabled HP-UX9.1 TS1M39.1 TS1M3 SP1
HP-UX IPF9.1 TS1M39.1 TS1M3 SP1
64-bit Enabled Solaris9.1 TS1M39.1 TS1M3 SP1
64-bit Enabled AIX9.1 TS1M39.1 TS1M3 SP1
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP1
* 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.