Click to See Complete Forum and Search --> : ADO


November 17th, 1999, 03:02 PM
Hi,
I have written a small VB application which talks to DB2 on mainframe.The drivers that I am using is UDBCAE5.2(IBM drivers).With DAO's ans RDO's the application works fine.When I use ADO's I am getting an empty recordset even though there are records.For some of the methods like Move first back end throws the Error "Driver Does not support this".Only Execute method works on the ADO connection object.
The doubt that I get is UDBCAE5.2 drivers not OLE DB compliant.If anyone has tried ADO with IBM DB2 as backend can you please share your knowledge and experiance.Your help is much appreciated.

Ganesh

pasangha
December 1st, 1999, 10:02 AM
hi
Set the property adUseCursor = Client in your connection parameter