Cannot connect odbc to Oracle

Chrystopher — Tue, 06 Jun 2017 00:10:58 GMT

Hi, I'm a rookie on this subject, I'm trying to connect my SAS Visual Analytics to a Oracle DB through ODBC but i don't have SAS/ACCESS, so, when i'm trying to import a table, SAS show me this message:

1
2
/* *********************************************** */
/* Assign the libref for the data in a ODBC table */
/*
2 ! *********************************************** */

LIBNAME db_odbc ODBC PRESERVE_COL_NAMES=YES PRESERVE_TAB_NAMES=YES
2 ! DATAsrc="DWH" USER=user PASSWORD="{sas002}878D5B5C3B2BCCFC89DC745E59E548C" ;

ERROR: CLI error trying to establish connection: Specified driver could not be loaded due to system error 5: Access is denied.
(Oracle en OraClient12Home1, C:\ORACLE\product\12.1.0\client_2\SQORA32.DLL).
ERROR: Error in the LIBNAME statement.
3 options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND;

My questions are:

I need SAS/CONNECT to import a table from Oracle?

Or there is another way to import a table from Oracle?

BTW. I configure successfully the odbc in the ODBC Data Source Administration (Windows).

Thanks.

Re: Cannot connect odbc to Oracle

SASKiwi — Tue, 06 Jun 2017 00:16:51 GMT

You need SAS/ACCESS to ODBC not SAS/CONNECT. Your LIBNAME wont work unless this product is both installed and licensed.

Re: Cannot connect odbc to Oracle

LinusH — Tue, 06 Jun 2017 08:41:08 GMT

SAS/CONNECT is used for connecting to another SAS server. For Oracle, as @SASKiwi says, you need SAS/ACCESS For either ODBC or Oracle (with a SQL*NET client).

topic Cannot connect odbc to Oracle in SAS Visual Analytics

Cannot connect odbc to Oracle

Re: Cannot connect odbc to Oracle

Re: Cannot connect odbc to Oracle