Unable to run Stored Procedure with ODBC connection
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone,
I am unable to run stored procedure in Alteryx Designer using ODBC Connection. Any Suggestions?
- Labels:
- Database Connection
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Pravallika_Pilli ,
We need more information. Why are you unable? What is the error? What are you trying to do? etc.
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
