In answer to your first question, you may be interested in looking up the options:

libname ... dbprompt=yes defer=no;

Defer=no makes it do the prompting when the libname statement is executed. Defer=yes makes it wait until the libname is actually used.

Hope this helps, Pat

Larry Kaskey <LKaskey@TRACFONE.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 02/03/2004 02:14 PM Please respond to Larry Kaskey

To: SAS-L@LISTSERV.UGA.EDU cc: Subject: connecting to oracle

Hello all...

I am creating a library like this...

libname clfy oracle user=xxxxxx password=xxxxxxx path='oracleserver';

I have two questions....

1. Is there a way to avoid the hard coding of my username and password...perhaps have sas prompt me for those. I believe someone asked a similar question today

2. When I create the library, I can access the data tables, but when I drill down in the folder to see the names of the tables, the folder appears blank. Why would that be?

I am using EG 2.0 for this.

Thanks for any and all help!!

Larry kaskey Tracfone Wireless.