Problem Note 3268: Write Access Violation Error using ODBC when updating a database table
on an AS400
It is possible to receive the following errors when updating a database
table on an AS400 machine. The problem occurs while processing row 7251
of the resulting database table.
ERROR: Write Access Violation in Task [SQL]
Exception occurred at [address-number]
"address-number" will vary. A task traceback follows these errors.
Once such scenario reported to cause this problem is a PROC SQL INSERT
into the database table. The problem occurs when an attempt is made to
insert into row number 7251 of the database table.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows NT Workstation | 8 TS M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 8 TS M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Professional | 8 TS M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Server | 8 TS M0 | 8.2 TS2M0 |
| OpenVMS VAX | 8 TS M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 8 TS M0 | 8.2 TS2M0 |
| IRIX | 8 TS M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8 TS M0 | 8.2 TS2M0 |
| Solaris | 8 TS M0 | 8.2 TS2M0 |
| OS/2 | 8 TS M0 | 8.2 TS2M0 |
| ABI+ for Intel Architecture | 8 TS M0 | 8.2 TS2M0 |
| z/OS | 8 TS M0 | 8.2 TS2M0 |
| CMS | 8 TS M0 | 8.2 TS2M0 |
| HP-UX | 8 TS M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8 TS M0 | 8.2 TS2M0 |
| Microsoft Windows 95/98 | 8 TS M0 | 8.2 TS2M0 |
| OpenVMS Alpha | 8 TS M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8 TS M0 | 8.2 TS2M0 |
| Tru64 UNIX | 8 TS M0 | 8.2 TS2M0 |
| AIX | 8 TS M0 | 8.2 TS2M0 |
*
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: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines
Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity)
|
| Date Modified: | 2000-09-17 18:53:07 |
| Date Created: | 2000-08-22 08:24:26 |
