topic Re: connect sql database DB instance ip port in SAS Programming

connect sql database DB instance ip port

Sir_Highbury — Fri, 17 Feb 2017 09:20:38 GMT

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

Re: connect sql database DB instance ip port

Sir_Highbury — Fri, 17 Feb 2017 09:51:53 GMT

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!

Re: connect sql database DB instance ip port

SASKiwi — Fri, 17 Feb 2017 09:54:48 GMT

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-SAS/ta-p/331849

Re: connect sql database DB instance ip port

Sir_Highbury — Fri, 17 Feb 2017 10:12:00 GMT

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....

Re: connect sql database DB instance ip port

Kurt_Bremser — Fri, 17 Feb 2017 10:40:06 GMT

@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.