>>>If rsTest.RecordCount > 0 Then 'VB ERROR 3704 HERE
>>> MsgBox "Records Returned"
>>>End If
>>>
>>
>>What's the error message associted with error code 3704 ?
>
>"Operation is not allowed when the object is closed"
>
>The recordset is not being opened for some reason - which is strange because running the SP with the same params in QA does indeed return records. I'm stumped.

How long it takes for your SP to finish? Maybe it's times out? Did you check error collection of the connection object?