We need to use SAS/Access-ODBC to connect to our Oracle databases.
When I use the libname statement:
libname test odbc dsn=ora8_prdb1 user=read password=XXXX schema=public;
SAS connects to the database, but the Explorer window for the "test" library is empty, and I am unable to access any of the tables in the schema.
If I connect to Oracle with other clients, using the same credentials, I see lots of tables in the "public" schema, so I don't think this is a validation problem. Am I doing something wrong?
Your statement:
libname test odbc dsn=ora8_prdb1 user=read password=XXXX schema=public;
is correct as long as all upper/lower cases are correct.
Here is one I use to connect to an Oracle database:
libname test odbc user=read password=xxxx dsn='TEST' schema=SCHEMA1 preserve_tab_names=yes;
Good luck
Your statement:
libname test odbc dsn=ora8_prdb1 user=read password=XXXX schema=public;
is correct as long as all upper/lower cases are correct.
Here is one I use to connect to an Oracle database:
libname test odbc user=read password=xxxx dsn='TEST' schema=SCHEMA1 preserve_tab_names=yes;
Good luck
I didn't think schema-names were case-sensitive on our Oracle database, but when I changed "schema=public" to schema=PUBLIC, I suddenly started seeing the tables in the schema.
So the problem is solved.
Thanks.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.