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.
You need SAS/ACCESS to ODBC not SAS/CONNECT. Your LIBNAME wont work unless this product is both installed and licensed.
You need SAS/ACCESS to ODBC not SAS/CONNECT. Your LIBNAME wont work unless this product is both installed and licensed.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.