Assigning Oracle Library in SAS 9.2

[Yennie]

Hi People,

I am trying to assign a oracle library in SAS 9.2 something similar to this

libname mydblib oracle user=u317092 password=*** path='jdbc:oracle:thin:@JEEPROD1:1526:PRD0GIP';

however, my log came up with this error

7522 libname mydblib oracle user=u317092 password=XXXXX
7522! path='jdbc:oracle:thin:@JEEPROD1:1526:PRD0GIP';
ERROR: The ORACLE engine cannot be found.
ERROR: Error in the LIBNAME statement.

does anyone knows how to solve this?

thanks in advance! Cheers.

[twocanbazza]

Have you got "SAS/Access to oracle" installed?