The connection method you attempted would have required the output to show something like
For SAS/ACCESS to Oracle
The result means that was not loaded.
You can run Proc Setinit; run; to show what is licensed. It may be that you have a license but the module wasn't installed for you. Which could be an easy partial reinstall. If Oracle (or the ODBC) doesn't appear in the license then license changes will be needed and then an updated install.
Without ODBC or the Oracle you will be stuck until one is installed.
... View more