Date: Tue, 22 Oct 2002 11:53:40 -0700
Reply-To: Dale McLerran <stringplayer_2@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dale McLerran <stringplayer_2@YAHOO.COM>
Subject: Re: Libraries, ODBC, and Access database
In-Reply-To: <D68AE532436AD411828500D0B74A06A57EAA5F@KAI_EMAIL01>
Content-Type: text/plain; charset=us-ascii
Bob,
Thanks for the suggestion. Unfortunately, I still get the queries
rather than the tables.
Dale
--- Robert Abelson <rabelson@KAI-RESEARCH.COM> wrote:
> Dale,
>
> I don't know if this will help or not, but I set up my ODBC libname
> statements like this:
>
> libname MYLIB odbc
> required="Driver={Microsoft Access Driver (*.mdb)};
> DBQ=C:\MYDB.mdb;
> SYSTEMDB=G:\WorkGroup\System.mdw;
> UID=MOI;PWD=notyrbiz;";
>
> And I get to see all the tables.
>
> Bob Abelson
> KAI
> 6001 Montrose Rd.
> Suite 920
> Rockville, MD 20852
> T: 301-770-2730
> F: 301-770-4183
> rabelson@kai-research.com
>
> "Anyone who cannot cope with mathematics is not fully human. At best
> he is a
> tolerable subhuman who has learned to wear shoes, bathe, and not make
> messes
> in the house."
> - Robert A. Heinlein
>
>
>
> > -----Original Message-----
> > From: Dale McLerran [SMTP:stringplayer_2@YAHOO.COM]
> > Sent: Tuesday, October 22, 2002 2:10 PM
> > To: SAS-L@LISTSERV.UGA.EDU
> > Subject: Libraries, ODBC, and Access database
> >
> > Folks,
> >
> > How do I get a library which points to an Access database to show
> > the Access tables rather than queries? I have set up a pointer
> > to the database alternatively using the "User DSN" and "System DSN"
> > tabs in the ODBC Data Source Administrator. I then issue in SAS
> > a libname constructed as
> >
> > libname MYLIB odbc dsn='<name of ODBC data source>';
> >
> > If I am in an interactive session and open up the library MYLIB
> > in the Explorer, then all I see are Access queries and not Access
> > tables. Similarly, the dictionary table MEMBERS lists queries
> > and not tables. Is there an option on the SAS side which can be
> > specified to pick up database tables rather than database queries?
> >
> > Thanks,
> >
> > Dale
> >
> >
> > =====
> > ---------------------------------------
> > Dale McLerran
> > Fred Hutchinson Cancer Research Center
> > mailto: dmclerra@fhcrc.org
> > Ph: (206) 667-2926
> > Fax: (206) 667-5977
> > ---------------------------------------
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Y! Web Hosting - Let the expert host your web site
> > http://webhosting.yahoo.com/
=====
---------------------------------------
Dale McLerran
Fred Hutchinson Cancer Research Center
mailto: dmclerra@fhcrc.org
Ph: (206) 667-2926
Fax: (206) 667-5977
---------------------------------------
__________________________________________________
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
| 
