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!
Solved! Go to Solution.
Turns out it was permissions for my worker - had to get the "real IT" guys involved....haha