Hey Patrick -
I used to use this trick all the time in order to fire stored procedures. Always worked fine for me.
A couple thoughts:
- Have you confirmed that the troublee isn't the sproc itself? Can you get a resultset from another sproc with simple SQL like SELECT * FROM Bar?
- Can you fire a simple SELECT in place of EXEC [dbo].[sproc]? Maybe '.SELECT * from [some table in adventureworks]
- In Tableau 8.1 (due out soon), you'll be able to execute stored procedures directly and won't have to jump through these hoops to begin with.
I have used a simple SELECT * FROM [TABLE} to ensure that the connection is working
I have executed the sproc in SQL and it works so I believe it is the connection to the linked server. I am thinking it may have to do with permissions, but then I can pull back data using a SELECT statement.
When I try the sproc via custom SQL it actually says I actually cant connect to the server?
It would be great if this was resolved in Tableau 8.1