problem connecting to oracle database using SAS

Hi All,

I am facing some problem while connecting to oracle database using SAS. Please help me as I am unable to find out what is the exact problem.

I have pasted the SAS log below:


247 proc sql;
248 Connect To ORACLE(dsn=abc User=kunalkelkar Password=XXXXXXX );
ERROR: The ORACLE engine cannot be found.
ERROR: A Connection to the ORACLE DBMS is not currently supported, or is not installed at your
site.
249 create table abc as select * from connection to Oracle
250 (select
251 * from
252 dailyperf where cal_dt='09AUG2006'd );
ERROR: The ORACLE engine cannot be found.
ERROR: A Connection to the Oracle DBMS is not currently supported, or is not installed at your
site.
253 disconnect from oracle;
ERROR: Connection to the oracle DBMS does not exist.
254 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time

Thanks ,
Kunal
__________________________________________________ ______________________
Check Out the new free AIM(R) Mail -- 2 GB of storage and industry-leading spam and email virus protection.