Problem Note 16831: "Error Trying to Establish Connection" Using OLE DB Provider from Oracle
Using SAS/ACCESS Interface to OLE DB and assigning a LIBNAME statement
to an Oracle database, using the Oracle OLE DB provider, the following
error may be returned:
ERROR: Error trying to establish connection: Unable to create Data
Source.: Class not registered
ERROR: Error in the LIBNAME statement.
This error can be returned when the OraOLEDB.dll is not registered
during the installation of the provider.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
*
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.
| Type: | Problem Note |
| Priority: | low |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> OLEDB
SAS Reference ==> LIBNAME Engines
Third Party ==> Information Exchange ==> OLE DB (Object Linking and Embedding Database)
|
| Date Modified: | 2006-02-24 14:26:00 |
| Date Created: | 2006-01-11 15:07:24 |
