[IBM Client Access][ODBC] SQL 0901 System error

Technote (troubleshooting)


Problem(Abstract)

Errors:

[IBM Client Access][ODBC] SQL 0904 Resource limit exceeded

or

[IBM Client Access][ODBC] SQL 0901 System error

or

[IBM Client Access][ODBC] SQL 0908

when creating catalogs, adding tables to an existing catalog, or querying the an AS/400 database via Client Access ODBC.

Resolving the problem

These are ODBC errors that can be caused by a corrupt driver, an incorrectly installed driver, or a driver that needs to be updated

Also check the following

1) For some specific versions of this driver - Journalling needs to be turned on - Please contact the vendor for more detailed information
2) Confirm the Library names in the ODBC driver are correct
3) Confirm the AS/400 is not low on space
4) Reinstall the driver
5) Run an ODBC trace to trap any preceding errors and assist in identifying the call that is causing the error.
6) Install the the DB Service Pak PTF SF99103 from IBM. www.ibm.com

Historical Number

73831

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Series 7
Impromptu

Software version:

Impromptu 3.03, Impromptu 3.04, Impromptu 3.5, Impromptu 5.0, Impromptu 7.1, Impromptu 7.3

Operating system(s):

Legacy Cognos, WinXP

Reference #:

1348751

Modified date:

2008-05-23

Translate my page

Machine Translation

Content navigation