SAS EG use Library Oracle ODBC error

[haibh]

I have a problem with oracle db using odbc, please help me.

1. on SAS APP: 
   - OS: RHEL8.9
   - instal oracle client 19c, unixODBC
   - test local OK

   [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>

2. on SAS META, config Library and add table OK

1. on client, window 10, using SAS Enterprise Guide, have one error

[JosvanderVelden]

Can you create the library using code as explained in the thread: https://communities.sas.com/t5/SAS-Programming/Connecting-to-Oracle-via-libname-odbc-Schema-spec-doe...

[haibh]

use code, i can create library

[Patrick]

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.

[Sajid01]

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.