Date:         Wed, 2 Aug 2006 16:19:34 -0700
Reply-To:     "Nordlund, Dan (DSHS)" <NordlDJ@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Nordlund, Dan (DSHS)" <NordlDJ@DSHS.WA.GOV>
Subject:      Re: ODBC/SQL Server
Comments: To: Ryan McNeill <RMcNeill@OKLAHOMAN.COM>
Content-Type: text/plain; charset=utf-8

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ryan
> McNeill
> Sent: Wednesday, August 02, 2006 4:00 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: ODBC/SQL Server
>
> I'm trying to connect to the SQL Server ... I've set up the ODBC....and
> wrote the following line:
>
> libname vinfo dsn'dsVoters2006';
>
> But I get the following error:
>
> Libname VINFO is not assigned.
>
> What am I missing?
>
>
>

Your libname statement is not correct.  If dsVoters2006 is the name of your
data source, and you have set up your data source correctly, and you don't
need a username or password, then this should work for you:

 libname vinfo odbc dsn=dsVoters2006;

hope this is helpful,

Dan

Daniel J. Nordlund
Research and Data Analysis
Washington State Department of Social and Health Services
Olympia, WA  98504-5204