ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.

Alteryx Server Discussions

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

Gallery: Error opening connect string: Cant create Data Source Object

mpot
6 - Meteoroid

Hi, 

 

In my workflow I take data from MSSQL and import it into Oracle Database. Recently my connection to Oracle details changed. After that when I run workflow from Alteryx app it works as usual, no errors. But if I run it from Gallery I get the following error:  Error opening connect string: Can't create Data Source Object 

 

Do you know what can be an issue here? 

RishiK
Alteryx
Alteryx

@mpot this is most likely down to the due to the database connection changing. Can you verify that the connections set up on the Server/Gallery are valid/updated?