Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

In-DB flow on gallery

SeanAdams
17 - Castor
17 - Castor

Cc @Rahul_Thakur 

 

Hi all,

We are seeing an error when we attempt to publish a canvas to the gallery which uses In-DB connectors.    The In-DB connection uses an OLE DB connection to an SQL server, and the SQL server drivers are installed on the gallery server.

 

Feedback we had received is that even though we're connecting via OLE DB, we also need to create a specific DSN on the gallery server in order for this workflow to connect to the SQL server.   This doesn't sound right given that we're using a direct OLE DB driver (not OLE DB via ODBC).

 

Do any of you know if such a constraint - that a specific DSN needs to be created on the Gallery server for any canvas that uses In-DB tools (eve if connecting via OleDB?).

 

Thank you all

Sean

 

 

3 REPLIES 3
Greg_Murray
12 - Quasar

Hi Sean, 

 

Did you get an answer to this? I am having a similar issue. 

 

Greg

SeanAdams
17 - Castor
17 - Castor

Based on investigation - there doesn't seem to be an easy solution on this - transferring into an idea.

 

davidhenington
9 - Comet

Assuming you're using a file based connection?