Hi everyone,
I am unable to run stored procedure in Alteryx Designer using ODBC Connection. Any Suggestions?
Hi @Pravallika_Pilli ,
We need more information. Why are you unable? What is the error? What are you trying to do? etc.
M.
Hello @Pravallika_Pilli ,
Use the ConnectIn-DB tool in the In-Database section.
I hope it helps. Let me know if you still have an issue.
Hi @Pravallika_Pilli ,
Some recommendations here from @randreag :
1. OLeDB connection from alteryx
2. In the sp it has to be the statement SET NOCOUNT ON
3. It has to have a select (any select at the end, I was updating and wihtout the select it didn't work, I had to added a simple select)
When you are trying to execute the stored procedure:
- What error are you getting
- are you using "exec SpName"?
- Have you turned off rowcounting
- are you calling the SP in pre-SQL; post-SQL or in the SQL text?
Hopefully with more info we'll be able to help with a solution.