When using SAS/ACCESS Interface to Microsoft SQL Server to update multiple rows in Microsoft SQL Server, if you are using driver version 08.02.1617 (B2215, U2040), you must set the following:

• the LIBNAME option CURSOR_TYPE=DYNAMIC
• the ODBC DSN option EnableServerSideCursors=4

If you do not set these options, updates to multiple rows might result in incorrect updates.

However, CURSOR_TYPE=DYNAMIC has a negative impact on READ performance. 

To check the version of the driver that is installed, assign a LIBNAME and run LIBNAME libref  LIST ;.  The output will display the version, as shown in the example below.

If you need to have good read performance and to ensure that updates work correctly, you must use two different libnames:

• one LIBNAME without CURSOR_TYPE=DYNAMIC to allow good performance for reading rows
• one LIBNAME with CURSOR_TYPE=DYNAMIC to allow correct update of rows

Click the Hot Fix tab in this note to access the hot fix for this issue.

Once the hot fix is deployed, you should stop using CURSOR_TYPE=DYNAMIC, and you should ensure that EnableServerSideCursors=4 is set in your ODBC DSN options.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Microsoft SQL Server 9.46 is available at:

A fix for this issue for SAS/ACCESS Interface to Microsoft SQL Server 9.45 is available at: