Problem Note 16512: "CLI execute error: Invalid cursor state" issued accessing MS SQL
Server
The following error message may be issued when attempting to access MS
SQL Server using SAS/ACCESS Interface to MS SQL Server.
ERROR: CLI execute error: [DataDirect][ODBC SQL Server Driver]Invalid
cursor state
To resolve this error, set the libname options INSERTBUFF and
CURSOR_TYPE simlilar to the following. These options and values are
documented in the online documentation.
LIBNAME test sqlsvr uid=uid password=pwd dsn=dsn insertbuff=32767
cursor_type=dynamic;
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Microsoft SQL Server | 64-bit Enabled HP-UX | 9.1 TS1M3 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 | |
| Linux | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 9.1 TS1M3 | |
*
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: | low |
| Date Modified: | 2005-11-21 12:47:22 |
| Date Created: | 2005-11-15 08:51:46 |
