CODEWITHSUNDEEP
oracle-databasesas
Lee Masamune
Lee Masamune

Reputation: 13

In SAS, how do I connect to a remote Oracle database by specifying the IP address of the Oracle's host?

We have two computers, A and B. Computer A (AIX 5.3, not sure about the version) is running the SAS server, and computer B (Win 7) is running an Oracle XE. Both computers see each other in the LAN without any problems.

I have explored many ways to connect to an Oracle database such as the LIBNAME statement and the Pass-Through Facility, but I can't find any way to explicitly say in these declarations the IP address of the Oracle's host.

I am hoping for a solution that doesn't require installing another Oracle in computer A, since we have no admin privileges there. I can't also use ODBC or OLE DB, since these require admin privileges in computer A to configure.

Have I missed anything in my Googling? Or is there another way? Thank you all for your help.

EDIT: I don't mean if it means something, but I found out that there is an Oracle in computer A. I don't have any means of configuring it, though. Same goes for its listener.

Upvotes: 1

Views: 6327

Answers (1)

BellevueBob
BellevueBob

Reputation: 9618

To use SAS/Access to Oracle on your server "A", that server must have the Oracle networking client software installed and configured. Normally that is managed by an Oracle administrator on that server.

It can be as simple as adding an entry into the tnsnames.ora file on your server that "points" to the Oracle instance running on your Windows machine "B". The details of what needs to be added should come from your Oracle DBA.

Once you can successfully connect to that Oracle environment from your server "A" (using something like sqlplus or testing with the tnsping command), SAS will use the same connection.

The point is that this does not have anything directly to do with SAS; you must set up the environment first. However, note that there are certain posit-installation steps that must be performed by your SAS administrator for everything on the SAS side to work. Double-check with whoever installed SAS on your server to make sure those steps were completed.

Upvotes: 1

Related Questions