Date:         Tue, 7 May 2002 21:04:02 -0400
Reply-To:     FMAINVILLE <fmr@MAGMA.CA.NOSPAM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         FMAINVILLE <fmr@MAGMA.CA.NOSPAM>
Subject:      Re: SAS ODBC Libname engine??
Content-Type: text/plain;

Hello,

Assign the libref interactively, then issue the following
command immediately after connecting to the data source.
The connection string will be written to the SAS log.

%put &SYSDBMSG;

HTH
F. Mainville
Statistics Canada
=======================


"David Rubanowice" <rubanowice.d@GHC.ORG> wrote in message
news:scd78e1d.064@ROC403.ghc.org...
> How about
>
> libname guexcel odbc dsn="Guatmala Excel";
>
> ?
>
> >>> "Delaney, Kevin P." <khd8@CDC.GOV> 05/07/02 08:08AM >>>
> I think I am close, but this doesn't quite work:
>
> libname guexcel odbc noprompt="DSN=Guatmala Excel;DRIVER=Microsoft Excel
> Driver(*.xls); DBQ=C:\khd8\Test Export to excel\ABRIL 5 RESULTADOS.xls;";
>
> You would think Windoze and SAS could work together so that once you
> assigned the DSN that would be all SAS would need, but I guess not...
>
> Interactively (with the "New Library" tool) I can assign this, but I want
to
> put it in my code!!
> Normally, I would RTFM, but I can't find the ODBC Libname engine
> documentation??
>
>
> Win2k and V.8.2, if it matters...
>
> Thanks,
> Kevin Delaney
> KDelaney@cdc.gov