connect sql database DB instance ip port

[Sir_Highbury]

Dear experts,

I was used to access sql database using the following parameters:

LIBNAME NOP
ORACLE PATH="klm"
SCHEMA=abc 
USER=def
PASSWORD=ghi ;

Now I got the following data that should allow me to access a DB:

DB user/password: abc/def
DB Instance: ghi
DB machine: srv001 (IP: 22.22.22.222)
DB port: 222

Is it enough? I searched a lot but I did not find any string fitting these given parameters.

Thanks a lot in advance for your support.

Best regards, SH

[Sir_Highbury]

I just runned a proc setinit and this is the result:

---SAS Workspace Server for Local Access

is ist enough to access the DB via the parameters above described? Thanks again!

[SASKiwi]

The help you need is sitting right under your nose in the Recommendations box to the right of your post:

https://communities.sas.com/t5/SAS-Communities-Library/A-quick-guide-to-connecting-to-Oracle-from-SA...

[Sir_Highbury]

Dear Kiwi,

I saw it immediately after I posted the question, sorry but still I do not get to the point. I get the following errors:

ERROR: The ORACLE engine cannot be found.
ERROR: Error in the LIBNAME statement.

This is the reason why I asked if the component installed in my SAS version are enough....

[Kurt_Bremser · Accepted solution]

---

@Sir_Highbury wrote:

Dear Kiwi,

I saw it immediately after I posted the question, sorry but still I do not get to the point. I get the following errors:

ERROR: The ORACLE engine cannot be found.
ERROR: Error in the LIBNAME statement.

This is the reason why I asked if the component installed in my SAS version are enough....

---

You need SAS/ACCESS to Oracle. It is not installed/licensed.