BookmarkSubscribeRSS Feed
haibh
Calcite | Level 5
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

haibh_0-1708416165486.png

 

 

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

haibh_1-1708416165490.png

 

 

4 REPLIES 4
haibh
Calcite | Level 5
use code, i can create library
Patrick
Opal | Level 21

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
Meteorite | Level 14

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1508 views
  • 2 likes
  • 4 in conversation