Recordset Failure problem

[Meekee3]

I have a vb program which connects to a DB2 database. I am using command objects to connect and generate recordsets. I have compiled the application into an executable and have loaded it successfully on my machine(the development machine, Win98) and on 3 WinNT machines (non have VB loaded). I am able to run the program and generate recordsets. However, when I try and run the program on any Win95/98 machine other than mine, I receive a error on the "Set recordeset.Execute" line. The error is "Runtime Error 3021 - Either BOF or EOF is True or the current record has been deleted. The application requires a current record." The EOF and BOF are True so I know that there is some sort of error happening.

Am I missing something? ANy help would be appreciated. Thanks.

 

[MatsHulten]

BOF and EOF are true at the same time under one condition only: Your query did not produce any data.
But the error should not occur until you try to access a field in the recordset. (An empty recorset is not an error per se.)

If I were you I would put in some messageboxes in the application, showing the progress of the code.

Good Luck
-Mats

 

[culshaja]

You need to check that the client machines have firstly the DB2 connect setup correctly. Secondly make sure that the ADO install is clean as a corrupt install will cause these types of errors.
Thirdly, check the users access rights into the dtabase, as they might not be able to get data from the correct tables.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305