Oracle Connection Error After Successful Connection
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
scottondata
5 - Atom
‎09-20-2021
06:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
Seconds later an error:
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:
- Labels:
- Connectors
- Workflow
1 REPLY 1
16 - Nebula
‎09-20-2021
11:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
