michellecole
Programmer
We are experiencing an "ODBC-- CALL Failed" error while trying to "query on" or "open" a linked table, named "PTI", via ODBC; the other 7 tables linked by the same ODBC query/import fine.
From Access 2000, we call an ODBC linking to tables on a Tandem box. According to our IT Source, "the operating system the Tandem uses is called Guardian. The files that are tied to dataserver are ENSCRIBE type files, and are key sequenced. These would be the equivalent to VSAM files on the mainframe. The data structures are defined by Data Definition Language (DDL)."
When a query is called on the table "PTI", the information pulled from Dataserver has #NAME in each field and the error message above shows up.
The linked table, PTI, only has 23,000 records in it. There are approx. 220 fields per record. Most of the datatypes are "STRING", but there are some others including "WORD", "SCALED_QUADWORD, "NUMSTR_U". If we query on only (1) record, every field - it will return a recordset. However, if we query on all the records - it fails. We only need approx. 12 of the fields from the record, which are all "STRING", if we query on only 100 records - the recordset is returned but if we query on all the records (desire), then it fails. All of the other tables via the same ODBC have thus far been successful in returning results.
Does anyone know why we are getting the failure and what we can do to fix it or offer a workaround?
Thank you,
Michelle
From Access 2000, we call an ODBC linking to tables on a Tandem box. According to our IT Source, "the operating system the Tandem uses is called Guardian. The files that are tied to dataserver are ENSCRIBE type files, and are key sequenced. These would be the equivalent to VSAM files on the mainframe. The data structures are defined by Data Definition Language (DDL)."
When a query is called on the table "PTI", the information pulled from Dataserver has #NAME in each field and the error message above shows up.
The linked table, PTI, only has 23,000 records in it. There are approx. 220 fields per record. Most of the datatypes are "STRING", but there are some others including "WORD", "SCALED_QUADWORD, "NUMSTR_U". If we query on only (1) record, every field - it will return a recordset. However, if we query on all the records - it fails. We only need approx. 12 of the fields from the record, which are all "STRING", if we query on only 100 records - the recordset is returned but if we query on all the records (desire), then it fails. All of the other tables via the same ODBC have thus far been successful in returning results.
Does anyone know why we are getting the failure and what we can do to fix it or offer a workaround?
Thank you,
Michelle
