The ADODB recordset has the value for properties BOF and EOF is set to True even though the stored procedure returns a row(Sybase 12.5)

This happens whenever a select condition returns with no rows.
But if i change the select condition to with an exist statement, it works properly.

The stored procedure works perfectly with Sybase System11 driver.

What shld i do to ensure that the rows returned are captured bythe result set . Pl. help on the same