Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
10 - Fireball

Assuming you're using a file based connection?