Hi all, Want to import data from oracle to sql server 2008 r2. Therefor I installed oracle instance client (11gr2 x64) on the server. Connecting with ODBC DSN and SQLPlus works. When I try now Import Wizzard and choose Oracle Provider for OLE DB I get: The 'OraOLEDB.Oracle' provider is not registered on the local machine. (System.Data) and with Oracle Data Provider for .net I get: TITLE: SQL Server Import and Export Wizard ------------------------------ An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. ------------------------------ ADDITIONAL INFORMATION: Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ The type initializer for 'Oracle.DataAccess.Client.OracleClientFactory' threw an exception. ------------------------------ The provider is with the version of the Oracle client not compatible (Oracle Data Provider for .NET) What should I install to make this working ??? TIA acki4711
Removed instant client and installed x86 client (user defined, odbc, oledb + odbc 4 .net) added TNS_ADMIN variable and all works like a charme... Why does sql server import wizard needs the x86 client from oracle and cannot handle oracle x64 driver ???
