Date:         Fri, 8 Feb 2008 15:01:34 -0700
Reply-To:     Ken Barz <Ken.Barz@CPCMED.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Barz <Ken.Barz@CPCMED.ORG>
Subject:      Re: SAS ODBC engine
Comments: To: mccabe.siobhan@GMAIL.COM
In-Reply-To:  A<b28eab0b-457f-47af-a874-9fe73d9be903@i7g2000prf.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

It looks like you have SAS/Access to PC Files which I don't believe
includes ODBC.  There is a separate SAS/Access to ODBC product.  There
was also a third party product called dbms engines (or something like
that) that SAS bought a few years ago and turned into something else (I
forget what they renamed it to.)  Not sure if that's still available or
not.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
mccabe.siobhan@GMAIL.COM
Sent: Friday, February 08, 2008 2:38 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SAS ODBC engine

I am trying to access Interbase files through SAS, but I am having a
lot of problems. I do have SAS/ACCESS installed on my computer, as a
proc setint confirmed:

Product expiration dates:
---Base
Product
30JUN2008
---SAS/
STAT
30JUN2008
---SAS/
GRAPH
30JUN2008
---SAS/
ETS
30JUN2008
---SAS/
FSP
30JUN2008
---SAS/
OR
30JUN2008
---SAS/
IML
29APR2008
---SAS/
CONNECT
30JUN2008
---OR
OPT
30JUN2008
---OR
PRS
30JUN2008
---OR
IVS
30JUN2008
---OR
LSO
30JUN2008
---SAS/ACCESS Interface to PC
Files                                        30JUN2008

Here is my syntax:
libname files odbc "C:\Documents and Settings\smccabe\My Documents
\Interbase";

and here is the error I get:
5    libname files odbc "C:\Documents and Settings\smccabe\My Documents
\Interbase";
ERROR: The ODBC engine cannot be found.
ERROR: Error in the LIBNAME statement.

It just seems to be unable to find the ODBC functionality.

Any suggestions?