AS400 error message (RESOURCE LIMIT EXCEEDED)?

Question

Hi, I'm trying to create a regular view at AS400 but i recieve an error message : SQLSTATE S1000 IBM CLIENT ACCESS EXPRESS ODBC DRIVER 32 BITS DB2/400 ( RESOURCE LIMIT EXCEEDED )

Answer 1

UPGRADE your client access edition to the one that is on the AS/400 system...I usually uninstall Client Access and start fresh. You can map a drive to \\YourAS400NameorIPAddress \QIBM\ (no spaces...i needed spaced because this site truncates links)
(You will need to authenticate using As400Name\UserID then Password,

then drill down to \ProdData\CA400\ Express\Install\Image (again, no spaces...damn yahoo) and run the SETUP.EXE. This will prompt you for a particular setup....use custom and you can specify ONLY the Client Access ODBC driver if you wish................I have found that using an older driver will cause problems.

If that don't work....
I believe that the amount of libraries in your ODBC connection is too many. Limit this library to your production library and see if this resolves your issue.

Good luck