topic Re: SAS EG use Library Oracle ODBC error in SAS Enterprise Guide

SAS EG use Library Oracle ODBC error

haibh — Tue, 20 Feb 2024 08:05:25 GMT

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

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>
on SAS META, config Library and add table OK

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

Re: SAS EG use Library Oracle ODBC error

JosvanderVelden — Tue, 20 Feb 2024 09:43:46 GMT

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-doesn-t-work/td-p/17859

Re: SAS EG use Library Oracle ODBC error

Patrick — Tue, 20 Feb 2024 11:18:18 GMT

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.

Re: SAS EG use Library Oracle ODBC error

Sajid01 — Tue, 20 Feb 2024 18:32:39 GMT

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.

Re: SAS EG use Library Oracle ODBC error

haibh — Wed, 21 Feb 2024 03:32:36 GMT

use code, i can create library