SUPPORT / SAMPLES & SAS NOTES
Problem Note 18538: "Error: DIAG[42000] [HP ODBC driver] ERROR [4118] The cursor query expression is not updatable. (-4118) when using HP ODBC driver SQL"
 |  |  |  |  |
The HP Neo ODBC driver has a bug in that when you try and do a "SELECT..FOR UPDATE" query (which SAS/ACCESS to ODBC does as part of it's UPDATE/DELETE operations) it will return an error similar to the following:
DIAG [42000] [HP][HP ODBC Driver][SQL Database] SQL error:*** ERROR[4118] The cursor query expression is not updatable. (-4118) DIAG [X08MU] [HP][HP ODBC Driver][SQL Database] SQL error:*** ERROR[8822] The statement was not prepared. (-8822)
In essence, the driver ignores the setting of TXN_ISOLATION at run time. The next rev of their driver will default to READ_COMMITTED (it currently defaults to READ_UNCOMMITTED).
We have a hotfix to provide this workaround for now so that any early adopters of the HP Neo system can use SAS with it.
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 ODBC | Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||