When I try to navigate by hitting the next button on my DB2 connection (using Client Access DSN) with ASP-DB I get the following error:

"Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[IBM][Client Access ODBC Driver (32-bit)]Driver not capable.

/as400test.asp, line 25 "

It displays the initial records just fine and allows me to use edit mode. However, as soon as I try to navigate through the records I get that error.

Is there a fix to this? It looks like the Client Access DSN can't support the method ASP-DB uses to navigate through ADO objects (such as MovePrevious).

Also, when using Oracle with pureASP I'm given an error when I hit the next button:

"Microsoft OLE DB Provider for ODBC Drivers error '80040e24'

The rowset does not support fetching backwards

/aspdb2/PureASP.asp, line 56 "


Are there newer providers that I should be getting? The information for the ones I am currently using for both Oracle and DB2 versions are the following:

Client Access ODBC Driver (32-bit) Version 3.00.0005 IBM Corporation CWBODBC.DLL 2/8/97

Oracle ODBC Driver Version 8.00.0300 Oracle Corporation SQORA32.DLL 6/3/97

Any insight/suggestions would be greatly appreciated.

Thanks,
Greg