Help with SqlOleDB

[Jim Bish]

I am feeding a connection string and a query (stored procedure that uses a
temp table) to a MS Office Pivot Table control. I have read the article
listed below

http://support.microsoft.com/defaul...ticles/q235/3/40.asp&NoWebContent=1#appliesto



I have set "SET NOCOUNT ON" as the first line of my procedure and it still
does not work. Can someone please help.



Jim

 

[[MSFT]]

Hi Jim,

Thank you for using the community.

Regarding the issue, can you provide the store procedure and how you use it
with MS Office Pivot Table control? Is this problem related to a .NET
application?

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)