Either BOF or EOF is true error message problem

[LumpHammer]

Is there a way to make SQL server return this error message when doing operations on an empty result set?

I am doing development on SQL server with MS-DAC components and in the development environment it works fine. When I go onto the customer site the same code connecting to Sybase 11 via ODBC comes back with the error "Either BOF or EOF is true, or the current record is deleted..."

I understand why this is happening, I would just like to be able to duplicate it while doing development to avoid nasty surprises on site.

Richard

 

[swampBoogie]

Is there a way to make SQL server return this error message when doing operations on an empty result set?

No, the message is returned by ADO. It has nothing to do with the DBMS. You should always check the status of the recordset before doing any operation, e.g.

set rs = connect.execute("select * from t where c1 = 4711")
if rs.eof then
'no data found
else
'proceess data
end if

If you need more help you need to be more specific.