Hi,
Alteryx 2022.1 - I'm trying to configure an input tool to run a stored procedure on a SQL Server 2017 instance.
Microsoft SQL Server 2017 (RTM-CU21) (KB4557397) - 14.0.3335.7 (X64)
When I try to do this I receive the following message in the Stored Procedures tab "Stored Procedures are not supported for this type of connection. "
I have read the following article but I'm not sure if this is relevant since I have SQL Server 2017 and I'm using a Gallery connection alias that works fine elsewhere in my workflows?
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Input-Tool-Not-Displaying-Stored-Pr...
My alias defined ODBS connection string is of the following form:
odbc:DRIVER={ODBC Driver 17 for SQL Server};DATABASE=myDatabase;SERVER=mySQLServer;Trusted_Connection=yes
I realise that the above article specifically calls out driver version 17 but then it also only speaks to SQL versions up to 2016.
All of our current Gallery aliases are configured to use driver version 17.
Attempting to follow the link in the article results in a 404 error.
EDIT - I found the updated version of the linked page. This suggest to me that driver version 17 should be supported?
https://help.alteryx.com/20223/designer/microsoft-sql-server-2012-2014-2016-and-2019
