Data Report w/stored procedure does not return record set (object not open)

[t013385]

I have a data report that runs a stored procedure. In the test environment it returns a result set which I check for EOF/BOF to see if it returned any report data. In the production environment the recordset does not exist so the EOF/BOF check blows up saying that it is not allowed because the object is not open. Why would it not return a recordset object? There is data that the stored procedure should return. Thanks.

[HunterMcCray]

Originally posted by t013385
I have a data report that runs a stored procedure. In the test environment it returns a result set which I check for EOF/BOF to see if it returned any report data. In the production environment the recordset does not exist so the EOF/BOF check blows up saying that it is not allowed because the object is not open. Why would it not return a recordset object? There is data that the stored procedure should return. Thanks.

You will get more help if you can give a bit more information, but it sounds like you are either not opening a connection, or that you are testing the recordset before you establish it. If you want your code to run through this checking (can't think why, but...) in the procedure or event where the EOF/BOF checks are made begin the code with OnError Resume Next and end the code with OnError GOTO 0. This will only help you if these checks are occurring before you open the recordset which you really should not be doing any way....More information would make it easier to see where your problem is.

Hope This Helps,

Hunter