topic Re: ORA-12504: TNS:listener was not given the SERVICE NAME in CONNECT DATA in New SAS User

ORA-12504: TNS:listener was not given the SERVICE NAME in CONNECT DATA

Angold5 — Mon, 31 Jul 2023 15:07:14 GMT

I have installed Oracle drivers and am trying to add a new “data source” as “oracle”

This is on Sas Viya 4 (2023.03) on aws.

The connection to the data source driver failed.
General error ORA-12504: TNS:listener was not given the
SERVICE NAME in CONNECT DATA
( There was a problem testing the co source driver failed. View details
Function failed.

Re: ORA-12504: TNS:listener was not given the SERVICE NAME in CONNECT DATA

ballardw — Mon, 31 Jul 2023 15:11:30 GMT

As a minimum you should show the SAS code and any messages from the log so we have at least some chance of seeing what connection options were attempted and possibly address.

Installing drivers may not be enough. If you are attempting to use ODBC for connection then you need to make sure that your system is set up to connect using that channel, and likely well outside the SAS side of things.