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