Architecting, installing and maintaining your SAS environment

SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

Reply
New Contributor
Posts: 4

SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

I'm going crazy trying to get a SAS terminal server running properly. We recently purchased a new server and installed Windows 2008 R2 on it. I setup Oracle Client 11g 64-Bit and tested the connection to my DB and it works fine. After this, I installed SAS server 32-Bit and oppened it. When I try to connect to my DB from SAS, I get the following error:

1    libname libmqdms oracle user=mqdms password=XXXXXXXXX path=testdb1 schema=mqdms;

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA   found but not loadable.

ERROR: Error in the LIBNAME statement

I have tried many things and viewed different posts about the same error message, but the situations seem different. Does anyone know how to get this to work?

Any help is much appreciated.

Super Contributor
Posts: 349

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

Posted in reply to david_marques

Hi,

Just try this below links regarding compatibility of SAS and oracle.Hope it helps.

http://support.sas.com/matrix/summary?OS=WINDOWS&DBVer=All&Engine=ORACLE&SAS=9.2

Thanks,

Shiva

New Contributor
Posts: 4

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

Thanks for the link, but according to this configuration Matrix, my setup should work properly, assuming they include Windows Server 2008R2 when they indicate Windows Server 2003 64-Bit. That list seems out of date though, since it doesn't include newer OS like Vista and 7. I noticed something else though. SAS, being a 32-Bit software, wanted to install itself in my Program Files folder, where 64-Bit programs are installed. I Installed it in the Program Files (x86) folder instead. Can this cause the problem? Should I simply install it in C:\SAS?

Super Contributor
Posts: 273

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

Posted in reply to david_marques

I will be too interested by the official sas answer

about the required directory name

Program Files

or

Program Files(x86)

or the indication that both are accepted without any system adherence  further

between the sas functionning and the system.

Andre

Super Contributor
Posts: 356

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

Posted in reply to david_marques

Have a look at  (found by searching support site withyour error)

http://support.sas.com/kb/33/444.html

Barry

New Contributor
Posts: 4

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

Posted in reply to david_marques

I finally had to cal SAS directly, but have found the issue. Unfortunately Barry, the patch you mention is no longer available but in any case is included with Oracle Client 11g R2, which is the version I had installed. The main issue is that SAS 32-bit couldn't talk to Oracle 64-bit, so I reinstalled it on 32-bit since we don't have SAS Server 64-bit. Once this was done, everything started working perfectly. Thanks for all of your comments on this issue.

New Contributor
Posts: 3

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

Posted in reply to david_marques

Hi David ! 

I think you made the most logical choice as the solution is way convoluted.

I have a Windows 2003 Server R2 64-bit as my Enterprise guide server and I found the solution from Microsoft, not SAS.

In the structure of Windows 64 bit (not sure about 2008), there is the standard c:\windows\system32 directory which, according to MS, holds the 64-bit programs and code ! A little confusing ?  Yeah, I know !

Apparently, to use 32-bit drivers in the 64-bit Windows 2003 environment, you need to install your drivers through the 32-bit version of the Datasources (ODBC) program which is located in the c:\windows\SysWOW64 directory and is the executable odbcad32.exe.  Now, the executable in the normal SYSTEM32 directory has the same name, probably for coding reasons, so it's easy to get confused.

Also note that pulling 32-bit documents like Word, Excel and others need to use the SAS/Access for PC Server otherwise they won't load.

Maybe when we have more 64-bit apps at the user end, we won't have to worry about this incompatibility so much ?

Occasional Contributor
Posts: 14

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

David,

I the reverse problem, my 64bit SAS can't take to my 32bit Oracle.  My ODBC driver is SQORA32.DLL, I believe this is 32bit.  I really want the 64bit Oracle.  Where did you find the Oracle 64bit?

New Contributor
Posts: 4

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

I just googled Oracle Client 11g 64-bit

Occasional Contributor
Posts: 14

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

Posted in reply to david_marques


David,

Thanks, I did the same.  I keep ending on the Oracle Home page.  2 weeks and 10 calls with Oracle, I still can't get into their site.  "My kingdom for a 64bit Oracle ODBC drivers."  It's a small kingdom with lots of unsettled villagers, but it's Home.

Bob W.

Contributor
Posts: 27

Re: SAS 9.2 Server 32-Bit on Windows 2008R2 and Oracle Client 11g 64-Bit R2

Hi Bob,

here you can download the Oracle Instant Client driver with ODBC 64-bit version:

http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html

Full-Client 64-bit:

http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip

Regards,

Sándor

Ask a Question
Discussion stats
  • 10 replies
  • 2327 views
  • 0 likes
  • 7 in conversation