Date:         Mon, 26 Feb 2001 22:19:41 -0500
Reply-To:     "Lawrence H. Muhlbaier" <lawrence.muhlbaier@DUKE.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Lawrence H. Muhlbaier" <lawrence.muhlbaier@DUKE.EDU>
Organization: Duke University, Durham, NC, USA
Subject:      Re: Access files and Drivers
Content-Type: text/plain; charset=us-ascii

Do you have SAS/Access to ODBC licensed?  sasioodb.dll is the ODBC .dll, not the
PC File Formats .dll. They would both be in that same directory.  You can run
PROC SETINIT; to see what you have licensed.

Doc

Jacques Thibault wrote:

> Hi SAS-L'ers
>
> I'm trying to read an Microsoft Access db from SAS V8e, and I defined my
> connectivity in Control Panel --> Data Sources (ODBC), but when running my
> program, SAS tells me that I don't have SASIOODB.
>
> Is a driver called SASIOODB.dll should be installed with SAS/ACC-PC  (folder
> V8/access/sasexe)?
>
> Pgm:
> libname myfile odbc dsn=mylabel;
>
> where mylabel is the alias I defined in Data Sources (ODBC)
>
> Log:
> ERROR: Module SASIOODB not found in search paths.
> ERROR: Error in the LIBNAME statement.
>
> I'm on Win2000 with SAS V8e
> Any Idea anyone?
> Thanks
>
> Jack
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

--
Lawrence H. ('Doc') Muhlbaier           muhlb001@mc.duke.edu
Assistant Research Professor
Duke University Medical Center          919-668-8774 (office)
DUMC 3865                               919-383-0595 (home)
Durham, NC 27710-7510                   919-668-7057 (FAX)