[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: What dose SAS has to do with Oracle?
From:       "Michael G. Sadof" <mgs () MGSNET ! NET>
Date:       2002-07-31 20:23:06
[Download RAW message or body]

Sounds like you might have allocated sashelp to an oracle table.  You should
not get that message unless you have linked to Oracle with some code like:
libname test1 oracle user=scott password=tiger path=o8i;

Check your autoexec.sas file and your sasv8.cfg file


"Huang, Ya" <ya.huang@PFIZER.COM> wrote in message
news:6300328FB7CFD511AACF0002A589357D024C84CF@lajgrdexm04.agouron.com...
> Hi there,
>
> Sometimes I got the following ERROR when I try to use sashelp view:
>
> ERROR: Oracle CONNECT Error: ORA-12505: TNS:listener could
> not resolve SID given in connect descriptor
>
> The code is as simple as:
>
> proc print data=sashelp.vcolumn;
> run;
>
> Interesting enough is that the result seems OK.
>
> Just wonder what dose SAS has to do with Oracle?
>
> The environment is Unix(Solaris) with SAS v612 or v8.2
>
> Thanks
>
> Ya Huang

[prev in list] [next in list] [prev in thread] [next in thread]