How to update parameters in a SQL stored procedure?

[nmosley]

I have a stored procedure in SQL Server with two parameter requirements.  I thought that I would use the Dynamic Input Tool here to update the values for the parameters.  I do something similar with updating variables in a query so I thought this would work.  However, when I establish the connection via ODBC the option for Stored Procedures is gray and says "Stored Procedures are not supported for this type of connection."  I noticed that the option exists under "Modify SQL Query > Add > SQL: Update Stored Procedure" but without connecting to the stored procedure in the Input Data Source Template I'm not sure that it will update anything.  What am I missing in the configuration to be able to send parameters to a stored procedure?

[RishiK]

@nmosley

Can you view the stored procedures via the Input Data tool / In-DB tools? - I am wondering if its a permissions thing with your connection.

 This link may be useful for you :

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-To-Pass-Dynamic-Parameters-Fields-...

[nmosley · Accepted solution]

After some searching and chatting with our internal IT resources I have found a solution.  For any one else who stumbles upon this thread.  Switching the connection type to OleDB rather than ODBC seems to have resolved the issue.