June 4, 2004 at 10:27 am
I seem to be having problems using temp tables when accessing the database through an approle. If the application calls two identical stored procedures except for a statement like "select 'abc' as abc into #t", the call to the SP containing that statement fails.
Any assistance would be much appreciated.
Thanks,
-Paul
June 7, 2004 at 5:37 am
Could you elaborate on how this fails?
Like what error do you get?
/Kenneth
June 7, 2004 at 6:21 am
The error message I get is:
Load\ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
Everything works fine from Query Analyzer, and the App seems to work fine with most Stored Procedures, but when the App calls an SP containing a temp table it throws this error.
I even tried giving the guest user in the tempdb Database Owner privileges just to test whether or not permissions were jamming me (because I think approle uses the guest account for any secondary databases).
-Paul
June 7, 2004 at 7:25 am
This seems to be a client error..?
(of which I'm not too familiar with.. ADO, ASP et all)
It seems like the recordset method is attempting something on a closed connection?
Anyway, this isn't a server error, so I'm afraid I'm not too much of help here..
/Kenneth
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply