DATA Step, Macro, Functions and more

connect sql database DB instance ip port

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 127
Accepted Solution

connect sql database DB instance ip port

 

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


Accepted Solutions
Solution
‎02-17-2017 05:42 AM
Super User
Posts: 6,951

Re: connect sql database DB instance ip port


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Frequent Contributor
Posts: 127

Re: connect sql database DB instance ip port

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!

Super User
Posts: 3,112

Re: connect sql database DB instance ip port

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

 

 

Frequent Contributor
Posts: 127

Re: connect sql database DB instance ip port

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

Solution
‎02-17-2017 05:42 AM
Super User
Posts: 6,951

Re: connect sql database DB instance ip port


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 116 views
  • 0 likes
  • 3 in conversation