Microsoft SQL server flow breaks once published

Question

Hello. I have an Alteryx flow that works on my laptop but breaks once published. I'm thinking the ODBC driver on Alteryx server is different than the driver on my laptop? How can I find out the various ODBC drivers that are on our Alteryx Server. We're using Alteryx server version 2021.2.1.35394

Also, any other ideas on what may be causing my problems.

Thanks in advance

charter747 · Answer

Yes, the table is visible within Toad. I tried adding dbo. and that still did not work. I've decided to attempt a DNS-less connection as described here:  Solved: DSN-less connection string issue - Alteryx Community

This is how the table shows up in Toad. The \FAA is my username for windows authentication. I don't know why it shows up like that; I think it has something to do with the way the DBA set-up my account.

This is the connection string inserted into the Alteryx output tool:

odbc:DRIVER={ODBC Driver 17 for SQL Server};UID=uid;PWD=pwd;DATABASE=BI;SERVER=server|||[BI].[FAA\Michael].[alteryx_sp_test]

When I run the Alteryx flow now on my laptop, I get

Error: Output Data (48): An unknown error occurred in II_PushRecord.

Aguisande · Answer

Is the table present when you connect via Management Studio with the same credentials you're using in the WF?

If so, and you can see and access the table, try adding dbo. before alteryx_sp_test ("BI.[\FAA Michael].dbo.alteryx_sp_test")

For some reason, when I connect to my local SQL server I need to add that

charter747 · Answer

I've decided to step away from the ODBC connection method and use the Quick Connect option. I'm thinking ODBC will not work since the name of the datasource on the server cannot be defined. The Quick Connect only asks for server name and credentials. It should work more easily using Quick Connect.

But now the problem is I cannot get the flow to work on my laptop in Alteryx. I'm getting the error message above. Why is it not finding that table?