| Title: | SQL/Services Forum |
| Notice: | kits(3) ft info(7) QAR access (8) SPR access (10) |
| Moderator: | SQLSRV::MAVRIS |
| Created: | Thu Oct 13 1988 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 2214 |
| Total number of notes: | 8586 |
Not sure if this should be posted here or DBI.
VAX/VMS 6.1; SQL/Services 6.1-02; RDB6.1-04
Customer using query tool (IQ/OBJ) to query a RDB DBI database and
is getting an SYSTEM-F-ACCVIO. Appears that the problem is
related to number of columns being queried. If the number of
columns is 500 or >, then ACCVIO. Less (-100) the query works.
Customer stated that she has upgraded to the latest IQ releases.
There is an associated dump, which we can get.
What are some other things we might look at?
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 2201.1 | BROKE::BASTINE | Mon May 12 1997 09:51 | 4 | ||
Bob, what version of DBI are they using? Renee | |||||
| 2201.2 | 3.1-02a | M5::BLITTIN | Mon May 12 1997 13:43 | 2 | |
DBI$SHR.EXE says 3.1-02a
| |||||
| 2201.3 | Give me a call | BROKE::GREEN | Mon May 12 1997 15:36 | 5 | |
Bob,
Call me. I have a test environment set up we can try.
Don
| |||||
| 2201.4 | limit of 500 columns | SQLSRV::MAVRIS | Sue Mavris - [email protected] | Tue May 13 1997 10:35 | 5 |
This shouldn't cause an accvio, but SQL/Services can only handle 500 columns. I'm not sure if this is documented anywhere... but it has always been the case. Sue | |||||
| 2201.5 | Thanks! | BROKE::GREEN | Tue May 13 1997 12:06 | 3 | |
Thanks a bunch Sue. I never knew this.
Don
| |||||