[sas@sasapp ~]$ vi /home/sas/.odbc.ini
[Oracle19]
Driver = /u01/app/sas/product/19.0.0/client_1/lib/libsqora.so.19.1
Description = Oracle 19.3 ODBC driver
ServerName = ORA19TEST
[sas@sasapp ~]$ isql Oracle19 test <pw>
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
on SAS META, config Library and add table OK
on client, window 10, using SAS Enterprise Guide, have one error
If you right click on your libname metadata definition then you can generate the libname. Use this libname in SAS code to debug the syntax (looks like you've got an issue with credentials).
Once you've got your libname working fix the metatdata library definition.
N.B: When generating the libname from metadata it creates it with parameters user and password even if you've actually defined it using an authdomain - but even in this case this will help you to figure out if there is something wrong with your authdomain.
Hello @haibh
The error message is very clear about invalid credentials.
Just checking. Did you create an auth domain attached to the server and saved oracle credentials?
If yes please check for username and password.
This is a very specific paper on establishing connection to Oracle through SAS Management Console. TS-771: Define an Oracle Library in SAS Management Console. Not available on the site but you can request SAS or search on google.
A must have and read for SAS Admins.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.