Date:         Tue, 27 Feb 2001 05:07:12 -0500
Reply-To:     Michael Davis <sas-l@BASSETTCONSULTING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Michael Davis <sas-l@BASSETTCONSULTING.COM>
Subject:      Re: Access files and Drivers
In-Reply-To:  <LAW2-F38EQILeM7Su9x000055cd@hotmail.com>
Content-Type: text/plain; charset="us-ascii"; format=flowed

Hello Jacque and other friends,

You need a SAS ODBC driver to read ODBC data into SAS.  I believe that you
have two choices:  SAS/ACCESS Interface to ODBC or the Universal ODBC
driver.  There are also third-party utilities that provide this
functionality that have been previously mentioned on this list.  Good luck.

- Michael "Mad Doggy" Davis

At 04:46 PM 2/26/01 -0500, Jacques Thibault <jacques_t@HOTMAIL.COM> 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.

Michael L. Davis
Vice President
Bassett Consulting Services, Inc.
10 Pleasant Drive
North Haven  CT  06473-3712
E-Mail:  michael@bassettconsulting.com
Web:  http://www.bassettconsulting.com
Telephone:    203-562-0640
Facsimile:    203-498-1414
Messages:     888-477-1412