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.

Learn more
I AGREE
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.
community Data Science Portal Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close

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
‎12-13-2020 11:24 PM

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? 

Reply
0 Likes
RishiK
Alteryx
Alteryx
‎12-14-2020 12:38 AM

@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?

Reply
0 Likes
Labels