BookmarkSubscribeRSS Feed
zhongdianshi
Calcite | Level 5

SAS version: 9.4

OS: windows 7

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.

Please help.

1 REPLY 1
JuanS_OCS
Amethyst | Level 16

Hi,

did you checked out lready this SAS Support link? http://support.sas.com/kb/46/630.html 

This is reporting your error and mentioning it is fixed on SAS 9.4 M1 for Windows 7. 

It also described the workaround, so you can keep working before you apply hotfixes or apply the latest maintenance.

 

Best regards,

Juan

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1688 views
  • 0 likes
  • 2 in conversation