topic Re: Connection to Oracle in SAS Enterprise Guide

Connection to Oracle

deleted_user — Mon, 24 Jan 2011 23:34:48 GMT

Hello

I am a SAS EG User and i am trying to connect to the Oracle data base.
I am using the following code to connect the oracle

libname oralib oracle user=XXYY password=*****# path=ASDEW;

I am getting the following error

ERROR 22-7: Invalid option name #.
16 path=ASDEW;
ERROR: Libname ORALIB is not assigned.
ERROR: Error in the LIBNAME statement.

I am a user and i dont have acess to create a library...

Re: Connection to Oracle

DBailey — Tue, 25 Jan 2011 00:20:14 GMT

try this.

libname oralib oracle user='XXYY' pw='*****#' path='ASDEW';

that is..put single ' around the text.

Re: Connection to Oracle

twocanbazza — Tue, 25 Jan 2011 18:49:06 GMT

Ummm Looking at your last statement, might be difficult to do as you state you don't have permissions to create a library....

"I am a user and i dont have acess to create a library"

Re: Connection to Oracle

darrylovia — Thu, 03 Feb 2011 13:11:28 GMT

I believe you need to add the SCHEMA= option

Re: Connection to Oracle

deleted_user — Thu, 03 Feb 2011 17:52:50 GMT

thank you

my problem was resolved i used double quotation marks for the password.

Then it was connected to the database