Date:         Wed, 16 May 2001 10:08:42 -0500
Reply-To:     Terry J Kohls <tjkohls@VPICORP.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Terry J Kohls <tjkohls@VPICORP.COM>
Subject:      ODBC_DSN
Content-Type: multipart/alternative;

I've set up a dsn the database "OpacityStats". When I run the following SQL, I get the errors below.
What am I doing wrong.  Any takers,

Thanks
Terry Kohls
tjkohls@vpicorp.com

proc sql;
 connect to odbc (dsn="OpacityStats");
  select *
  from connection to odbc
  (select * from tblDATA_2000_2001);
 disconnect from odbc;
quit;

HERE ARE THE ERRORS

proc sql;
connect to odbc (dsn="OpacityStats");
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.
select *
from connection to odbc
 (select * from tblDATA_2000_2001);
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.
disconnect from odbc;
ERROR: Connection to the ODBC DBMS does not exist.
quit;

[text/html]