Unable to run Stored Procedure with ODBC connection

[Pravallika_Pilli]

Hi everyone,

I am unable to run stored procedure in Alteryx Designer using ODBC Connection. Any Suggestions?

[mceleavey]

Hi @Pravallika_Pilli ,

We need more information. Why are you unable? What is the error? What are you trying to do? etc.

M.

[ImadZidan]

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.

[jamielaird]

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)

Source: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-2020-2-is-not-reading-the-SQL-...

[SeanAdams]

Hey @Pravallika_Pilli 

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.