This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?).