Using VB6 with DB2 v8.2 - problems with ado control

[sp1502]

We are in the process of converting from DB2 v7.2 to DB2 v8.2. We have visual basic 6.0 applications that use the datagrid ado control. In DB2 v7.2 datagrid works fine. In DB2 v8.2 the datagrid cannot find any results with BOF & EOF = True. Has anyone encountered this type of problem with using Visual Basic 6.0 with DB2 v8.2?

Thanks in advance.

 

[JerryKlmns]

BOF & EOF = True

For a recordset (rst)

rst.BOF & rst.EOF = True

doesn't mean that there is no record?

 

[fredericofonseca]

I have seen that before.

What MDAC are you using? and are you using the DB2 Drivers, OLEDB or ODBC one?

And how are you setting up your connection/recordset modes? e.g. cursortype and lock type?

All these settings can affect, as can some DB2 driver settings.

And you would be better NOT to use BOUNd controls, as this is one of the problems you have with them.... search the net/these forums for BOUND vs UNBOUND to see plenty of threads on the subject.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com