Hi all,
I have a workflow with an input using ODBC connection from server to connect to a SQL database and select* a small table. It works as expected when running from designer locally, and on the VM where Server is installed.
When I attempt to save to the gallery the validation fails stating "No Columns Returned". Looking at the logs of the validation job I see the connection is made, just no columns returned,
After testing further I see that any input tool configured to look at this specific database yields the same results (fine on designer, no columns returned on server). Anybody have any suggestions??
Thanks!