[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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.