BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
S_S
Obsidian | Level 7 S_S
Obsidian | Level 7

Hi,

 

I am trying to create a Oracle connection in SAS Viya 3.4. 

 

When I do a Test Connection, it tell me that "There was a problem testing the connection: An unexpected error has occurred"

 

I have tested the connection using sqlplus in the cas server and it is working fine.

 

Any help or pointer on how to resolve this error is very much appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Mark_sas
SAS Employee

I'm assuming you're attempting to test the connection within the Data Viewer in a SAS Viya client like SAS Environment Manager.  You'll need to follow the instructions on the Oracle Data Connector page to make this work.  You can also link to this page from the "?" icon next to the Source type field in the Data Viewer Connection Settings dialog.  You may want to submit the associated CASUTIL code from SAS Studio or a batch job to see what shows up in the log.  If you're still having trouble making the connection, feel free to call or chat up Tech Support.


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

View solution in original post

1 REPLY 1
Mark_sas
SAS Employee

I'm assuming you're attempting to test the connection within the Data Viewer in a SAS Viya client like SAS Environment Manager.  You'll need to follow the instructions on the Oracle Data Connector page to make this work.  You can also link to this page from the "?" icon next to the Source type field in the Data Viewer Connection Settings dialog.  You may want to submit the associated CASUTIL code from SAS Studio or a batch job to see what shows up in the log.  If you're still having trouble making the connection, feel free to call or chat up Tech Support.


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 3017 views
  • 2 likes
  • 2 in conversation