September 10, 2009 at 8:54 am
When I tried to execute 'sp_OAMethod' procedure in SQL 2005, i got the error as '[SQL-DMO] This cache contains no result sets, or the current result set contains no rows.'
The 'sp_OAMethod' procedure we executed as follows:
sp_OAMethod @objQueryResults, 'CurrentResultSet', @objCurrentResultSet OUT
I also enabled 'Ole Automation' from Surface Area Configuration.
Please give a solution for this.
September 10, 2009 at 9:09 am
John Marcuz (9/10/2009)
When I tried to execute 'sp_OAMethod' procedure in SQL 2005, i got the error as '[SQL-DMO] This cache contains no result sets, or the current result set contains no rows.'The 'sp_OAMethod' procedure we executed as follows:
sp_OAMethod @objQueryResults, 'CurrentResultSet', @objCurrentResultSet OUT
I also enabled 'Ole Automation' from Surface Area Configuration.
Please give a solution for this.
where is the sp_OACreate call before the sp_OAMethod call. and is that the full error. what are you trying to achieve using sp_oa procedures
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply