SUPPORT / SAMPLES & SAS NOTES
Problem Note 15269: Cannot create SQL Server table if LIBNAME option IGNORE_READ_ONLY_COLUMNS=YES is set
 |  |  |  |  |
Attempting to create a SQL Server table using the SAS® SQLSVR LIBNAME engine will fail if the LIBNAME option IGNORE_READ_ONLY_COLUMNS=YES is set.
The error received will be similar to:
ERROR: CLI prepare error: [DataDirect][ODBC SQL Server Driver][SQL
Server]Line 1: Incorrect syntax near ')'. : [DataDirect]
[ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared.
The workaround for this issue is to remove the LIBNAME option when attempting to create tables.
Select 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 Microsoft SQL Server | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP4 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| Linux on Itanium | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||