Problem Note 57757: Using the UPDATE statement with SAS/ACCESS® Interface to Microsoft SQL Server might cause the error "A cursor with the name ... does not exist"
 |  |  |  |  |
Using an UPDATE SQL statement with SAS/ACCESS Interface to Microsoft SQL Server might result in an error similar to the following:
proc sql;
update sqllib.test_table set name='Bob' where age=12;
quit;
ERROR: CLI execute error: [SAS][ODBC 20101 driver][Microsoft SQL Server]A cursor
with the name 'SQL_CUR40B00F80AF7F0000' does not exist.
ERROR: ROLLBACK issued due to errors for data set SQLLIB.TEST_TABLE.DATA.
The error might occur if you are using the DataDirect 7.1.x or later driver. Previous versions of the driver, such as 7.0.x, do not exhibit this behavior.
Workaround
SAS® 9.4M3 (TS1M3):
There is only one way to avoid this issue. You must add the following option in the odbc.ini file under the DSN entry:
In Windows, you can set this value in the Extended Options field of the ODBC SQL Server Wire Protocol Driver Setup dialog box, as shown below:
Note: This workaround at SAS 9.4M3 has been known to cause poor "Read" performance issues when querying from SQL Server to SAS. It is highly recommended that you upgrade to the latest release of SAS and apply the following hot fix and solution.
SAS® 9.4M4 (TS1M4) to SAS® 9.4M6 (TS1M6):
You must apply the appropriate hot fix for your SAS version to update the driver and then set the following:
You can set this option either in the odbc.ini file or in the user interface (on Windows), the same as specified for SAS 9.4M3 above.
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 Microsoft SQL Server | Microsoft® Windows® for x64 | 9.4 TS1M3 | |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M3 | |||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M3 | |||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M3 | |||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Pro | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M3 | |||
| Microsoft Windows 10 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 Std | 9.4 TS1M3 | |||
| Windows 7 Enterprise 32 bit | 9.4 TS1M3 | |||
| Windows 7 Enterprise x64 | 9.4 TS1M3 | |||
| Windows 7 Home Premium 32 bit | 9.4 TS1M3 | |||
| Windows 7 Home Premium x64 | 9.4 TS1M3 | |||
| Windows 7 Professional 32 bit | 9.4 TS1M3 | |||
| Windows 7 Professional x64 | 9.4 TS1M3 | |||
| Windows 7 Ultimate 32 bit | 9.4 TS1M3 | |||
| Windows 7 Ultimate x64 | 9.4 TS1M3 | |||
| 64-bit Enabled AIX | 9.4 TS1M3 | |||
| 64-bit Enabled Solaris | 9.4 TS1M3 | |||
| HP-UX IPF | 9.4 TS1M3 | |||
| Linux for x64 | 9.4 TS1M3 | |||
| Solaris for x64 | 9.4 TS1M3 | |||