Actually, loading Microsoft's 32 bit-ODBC drivers did work in accessing the MS Access 2.0 database. It's only because I don't have Office 97 yet that I needed to get those 32 bit ODBC drivers from Microsoft. Once I did that it worked like a charm. It's just easier if you already have Office 97 but not necessary.

Susan

--- On Mon, 30 Jun 1997 07:38:42 -0400 Tim Latendress <TIM.LATENDRESS@latent62. customs.sprint.com> wrote:

>Eric, > >Two things to consider: > >1) You license a SAS/ACCESS product other than ODBC (check the PRODuct >list in your SETINIT) which means that you can't use SAS and ODBC to >read your Access data. Or, > >2) You license SAS/ACCESS to ODBC but you're running WIN95/NT and trying >to use ODBC against ACCESS 2.0 which doesn't work. In that environment, >SAS is a 32-bit app and isn't designed to use the 16-bit ODBC driver for >Access 2.0. > >If the latter is the case, even loading the MS Access 32-bit ODBC >drivers won't help. You'll need to upgrade to Access 7.0 which, as Susan >suggests, comes with Office 97. > > >HTH > >Tim Latendress >latendress@latent62.customs.sprint.com > >======================================================================== >Eric Ellsworth <exe1@MHG.EDU> posted: > >Hi Susan, > >First of all, thanks for replying. I really appreciate it. > >I installed the Access 32 bit-ODBC drivers, and then made an ODBC data >source using them, but I don't think SAS ever gets that far. >When I run the sample code, I get the following output: > >3 proc sql; >4 >5 connect to odbc (dsn=podb); >ERROR: Module SASIOODB not found in search paths. >ERROR: A Connection to the ODBC DBMS is not currently supported, or is >not installed at your > site. >6 >7 create table work.fromhost as >8 select * >9 from connection to odbc >10 (select * from Main); >ERROR: Module SASIOODB not found in search paths. >ERROR: A Connection to the ODBC DBMS is not currently supported, or is >not installed at your > site. >11 >12 disconnect from odbc; >ERROR: Connection to the ODBC DBMS does not exist. >13 quit; >NOTE: The SAS System stopped processing this step because of errors. >NOTE: The PROCEDURE SQL used 0.82 seconds. > >I have subsequently tried to reinstall the SAS ODBC drivers. Do you >think its possible that my version of SAS/ACCESS doesn't include a >license to use ODBC? I know that sounds ridiculous, but this is SAS. >Any advice or suggestions you have would be much appreciated. > >Eric Ellsworth

-----------------End of Original Message-----------------