I am trying to connect SAS with the oracle and i wrote the below code: libname oralib oracle path='sukdc02ora01' user='login' password="password" schema='schema name'; sukdc02ora01 is host name I am getting following error 40 libname oralib oracle path='sukdc02ora01' user='login' password='password'
41 schema='schema_name';
ERROR: The ORACLE engine cannot be found.
ERROR: Error in the LIBNAME statement. oracle client is installed and working fine with my python. python code if that helps: import pandas as pd
import pandasql as ps
import sqlalchemy
import cx_Oracle
ip = 'sukdc02ora01'
port = 1521
SID = 'DEVNEW'
user = 'login'
password = 'password'
dsn_tns = cx_Oracle.makedsn(ip, port, SID)
conn = cx_Oracle.connect(user, password, dsn_tns)
print(conn.version) Please suggest what should be done to connect with oracle
... View more
