Date:         Mon, 28 Jul 2008 12:25:30 -0700
Reply-To:     jfh@stanfordalumni.org
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: How to specify connection strings to Oracle Express
Comments: To: Mary <mlhoward@avalon.net>
In-Reply-To:  <012101c8f0e5$2eff27f0$832fa8c0@HP82083701405>
Content-Type: text/plain; charset="ISO-8859-1"

I would use the PROMPT option in the ODBC libname statement, and look at
the resulting value in &SYSDBMSG.

I think it's telling you in this case that it doesn't know how to find
the tnsnames.ora file, or that the tnsnames.ora file doesn't contain the
needed connection information.



On Mon, 28 Jul 2008 14:07:27 -0500, "Mary" <mlhoward@AVALON.NET> said:
> Hi,
>
> I've just downloaded Oracle Express and am trying to connect to it
> through
> SAS, without luck.  I am able to connect to it from MS Access so I know
> that
> it is working:
>
> What I'm trying is:
>
> 51 proc sql;
> 52 connect to oracle (user=HagemanDB pw=XXXXXXX path='c:\oraclexe');
> ERROR: ORACLE connection error: ORA-12154: TNS:could not resolve the
> connect
> identifier specified.
> 53 select * from tbl_test;
> ERROR: File WORK.TBL_TEST.DATA does not exist.
> 54 quit;
> NOTE: The SAS System stopped processing this step because of errors.
> NOTE: PROCEDURE SQL used (Total process time):
> real time 4.54 seconds
> cpu time 0.01 seconds
> 55 run;
>
>
> I've also tried libname statements- but am not sure how to set them up-
>
> In the ODBC window, I have setup an ODBC driver called ORACLEEXPRESS with
> username, password, and then "xe" as the server name.   How would I setup
> a
> SAS Libname to match this?
>
> Thanks.
>
> -Mary


--
Jack Hamilton
Sacramento, California
jfh@alumni.stanford.org  <== Use this, not jfh@stanfordalumni.org