I am using IBM client Access drivers to connect to an as400 server in my Visual Basic App. Whenever I try to access a certain table I get the following error:

-2147217865 : [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]PWS0007 - Operation result set not found.

The I paste the query into Microsoft access and it works. Any ideas??