OraOLEDBpus10.dll: The specified module could not be found. Test Connection failed because of a error in initializing provider. Not in

Source: Internet
Author: User
Tags microsoft sql server
Neither SSMs Export Wizard (include linked server) nor vs2012 SSIS can acess oracle 10g successfully,can anyone help M E to solve this problem,best regards!

When testing a connection:

---------------------------
OraOLEDBpus10.dll: The specified module could not be found.
---------------------------


Click OK:

Title: Connection Manager
------------------------------

Test Connection failed because of a error in initializing provider. The "oraoledb.oracle.1" provider is not registered on the local computer.

------------------------------

The system environment variable is set as follows:

Installed Oracle 11g client32/11g client64/10g db/sql Server 2008 R2/sql Server 2012/odac121012xcopy_x64/odac121012xcopy



Path=:

D:\oracle\product\10.2.0\db_2\BIN;
D:\oracle\product\10.2.0\db_2;
F:\app\Patrick\product\11.2.0\client_2\bin;
%SystemRoot%\System32;
%SystemRoot%;
%systemroot%\system32\wbem;
%systemroot%\system32\windowspowershell\v1.0\;
C:\Program Files (x86) \microsoft SQL server\100\tools\binn\;
C:\Program Files (x86) \microsoft SQL server\100\dts\binn\;
C:\Program Files (x86) \microsoft SQL Server\100\tools\binn\vsshell\common7\ide\;
C:\Program Files (x86) \microsoft Visual Studio 9.0\common7\ide\privateassemblies\;
C:\Program Files\Microsoft SQL Server\110\dts\binn\;
C:\Program Files (x86) \microsoft SQL server\110\tools\binn\;
C:\Program Files\Microsoft SQL Server\110\tools\binn\;
C:\Program Files (x86) \microsoft SQL server\110\tools\binn\managementstudio\;
C:\Program Files (x86) \microsoft Visual Studio 10.0\common7\ide\privateassemblies\;
C:\Program Files (x86) \microsoft SQL server\110\dts\binn\;
C:\Program Files\microsoft\web Platform installer\; C:\Program Files (x86) \microsoft Asp.net\asp.net Web Pages\v1.0\;
C:\Program Files (x86) \ Windows Kits\8.0\windows performance toolkit\;
D:\Program Files (x86) \microsoft Visual Studio 11.0\common7\ide\privateassemblies\;
C:\Program Files\Microsoft SQL Server\120\tools\binn\; C:\Program Files\mysql\mysql Server 5.5\binpath


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.