When I try to connect oracle database through, I get the error message below.
Error: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASDRA found but not loadable..
Please make sure Oracle environment is set correctly.
Look in the install/Config doc for additional info for your platform.
Other possible reasons - incomplete ORacle client install, 32/64-bit mismatch between Oracle client &SAS, incorrect Oracle client verstion(Oracle client must match the version picked during post-install process), incompatible sasora for your OS or its attribs don't permit SAS to load it.
my best guess, my oracle version is 64bit, not 32.