Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
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
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Oracle Connection Error After Successful Connection

scottondata
5 - Atom
‎09-20-2021 06:13 PM

I am a little baffled here. I successfully connect to Oracle, preview the data, but as soon as I try to run the workflow, I get an error.

 

Preview Data:

 

scottondata_0-1632186528353.png

 

Seconds later an error:

scottondata_1-1632186636526.png

 

Error text: Error: Input Data (2): Error SQLDriverConnect: [Oracle][ODBC][Ora]ORA-12545: Connect failed because target host or object does not exist
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

 

I did nothing other than click onto the canvas after previewing the data.

 

 

Labels:
Reply
0 Likes
1 REPLY 1
RolandSchubert
16 - Nebula
16 - Nebula
‎09-20-2021 11:29 PM

Hi @scottondata ,

 

do you try to connect to a RAC?  If so, using OCI instead of ODBC and configuring a local listener could be a solution.  Doc ID 364855.1 in Oracle support provides some details.  

 

Best,

 

Roland

Reply
0 Likes
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All