Usage Note 41034: "Error: Connection to Oracle not found" when using SAS/ACCESS® Interface to Oracle on Windows 7 machines
When attempting to use SAS/ACCESS Interface to Oracle on a Windows 7 machine, you can get the following error:
Error: The Oracle engine can not be found. Connection to Oracle
engine not found or installed at your site.
The problem occurs when the User Account Control Settings in Windows 7 does not allow the customer to run the Oracle client. You can test with SQL*Plus to see whether you can run the Oracle client.
To resolve the issue do one of the following:
- Right-click on the SAS icon and select Run as Administrator when starting SAS.
- Change your User Account Control settings to be able to run the Oracle client itself.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows Server 2008 | 9.2 TS2M2 | |
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M2 | |
| Windows 7 Enterprise 32 bit | 9.2 TS2M2 | |
| Windows 7 Enterprise x64 | 9.2 TS2M2 | |
| Windows 7 Home Premium 32 bit | 9.2 TS2M2 | |
| Windows 7 Home Premium x64 | 9.2 TS2M2 | |
| Windows 7 Professional 32 bit | 9.2 TS2M2 | |
| Windows 7 Professional x64 | 9.2 TS2M2 | |
| Windows 7 Ultimate 32 bit | 9.2 TS2M2 | |
| Windows 7 Ultimate x64 | 9.2 TS2M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
"Connection to Oracle not found" error occurs when using SAS/ACCESS Interface to Oracle on a Windows 7 machine. The problem occurs when the user is not an administrator on the machine or cannot run the SAS/ACCESS Interface to Oracle client.
| Date Modified: | 2010-12-21 17:26:16 |
| Date Created: | 2010-09-27 12:00:04 |
