Error In Initializing Provider Oracle
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Test test connection failed because of an error in initializing provider oracle connection failed because of an error in initializing provider. Oracle microsoft data link error initializing provider oracle client client and networking components were not found. SQL Server > SQL Server Integration Services Question 0
Error In Initializing Provider Ssis
Sign in to vote Hi, I have created a SSIS package using Oracle source. But i dont have Oracle components installed on my machine so getting
Test Connection Failed Because Of An Error In Initializing Provider Access
error : Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. I am test connection failed because of an error in initializing provider. dbnetlib connectionopen searching online but dont know which components i need to install. Can somebody provide me the link where i can download those components? I am using 64 bit operating system and sql server 2008. Thanks Saturday, October 27, 2012 8:32 PM Reply | Quote Answers 0 Sign in to vote Hi Skydiver01, You can download Oracle Client version 10.x or 11.x from ORACLE: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html You can download Microsoft Connector for Oracle by Attunity using link as below: http://www.microsoft.com/en-us/download/details.aspx?id=29284 For more detail steps about using the Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services, please see: http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx Thanks, Eileen Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread. Marked as answer by Eileen Zhao Thursday, November 08, 2012 1:28 AM Friday, November 02, 2012 1:51 AM Reply | Quote
- Connect to Oracle on a 64-bit machine (Updated for SSIS 2008 R2) We recently had a few customers where a connection to Oracle
Test Connection Failed Because Of An Error In Initializing Provider Microsoft Odbc
on a 64 bit machine was necessary. A quick search on the internet showed test connection failed because of an error in initializing provider ora-12154 that this could be a big problem. I found all kind of blog and forum posts of developers complaining about this. test connection failed because of an error in initializing provider sql server A lot of developers will recognize the following error message: Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0819acf0-f53e-402a-8113-e8d87f8def5b/test-connection-failed-because-of-an-error-in-initializing-provider-oracle-client-and-networking?forum=sqlintegrationservices Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. After a lot of searching, trying and debugging I think I found the right way to do it! Problems Because BIDS is a 32 bit application, as well on 32 as on 64 bit machines, it cannot see the 64 bit driver for Oracle. Because of http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx this, connecting to Oracle from BIDS on a 64 bit machine will never work when you install the 64 bit Oracle client. Another problem is the "Microsoft Provider for Oracle", this driver only exists in a 32 bit version and Microsoft has no plans to create a 64 bit one in the near future. The last problem I know of is in the Oracle client itself, it seems that a connection will never work with the instant client, so always use the full client. There are also a lot of problems with the 10G client, one of it is the fact that this driver can't handle the "(x86)" in the path of SQL Server. So using the 10G client is no option! Solution Download the Oracle 11G full client. Install the 32 AND the 64 bit version of the 11G full client (Installation Type: Administrator) and reboot the server afterwards. The 32 bit version is needed for development from BIDS with is 32 bit, the 64 bit version is needed for production with the SQLAgent, which is 64 bit. Configure the Oracle clients (both 32 and 64 bits) by editing the files tnsnames.ora and sqlnet.ora. Try to do this with an Oracle DBA or, even be
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2012 » SQL 2012 - General http://www.sqlservercentral.com/Forums/Topic1468382-2799-1.aspx » SSIS Package - Oracle client and networking... SSIS Package - Oracle client and https://community.oracle.com/thread/2548947 networking components were not found. Rate Topic Display Mode Topic Options Author Message HookSqlDba7HookSqlDba7 Posted Thursday, June 27, 2013 4:38 PM Old Hand Group: General Forum Members Last Login: Thursday, September 29, 2016 1:59 PM Points: 376, Visits: 503 We are running SQL Server 2012 EE 64-Bit Eval Copy on Windows Server 2008 R2 error in EE 64-Bit SP1 on our DB Server. We have installed Oracle 11G Client Install. We did a Custom Install and selected the following:SQL*PlusOracle NetOracle ODBC DriverOracle Services For Microsoft Transaction ServerOracle Objects for OLEOracle Provider for OLE DBOracle Data Provider for .NETConfigured sqlnet.ora and tnsnames.ora files. Tested tnsping to our Oracle Server/Database and it worked.Tested sqlplus to our Oracle Server/Database and it worked.Tested ODBC (System DSN and error in initializing 'Oracle in OraClient11g_home1' driver) to our Oracle Server/Database and it worked.Set up Linked SQL Server to Oracle using the following and it worked:--With Microsoft OLE DB Provider for Oracle, use the Oracle server alias --(that is configured in the TNSNames.Ora file) for the @datasrc parameter.-------------------------------------------------------------------------- Test_DBTest Link-------------------------------------------------------------------------- Add a linked server for Test DBTest.USE [master]GOEXEC sp_addlinkedserver @server = 'Test_DBTest_shared' ,@srvproduct = 'DBTest' ,@provider = 'OraOLEDB.Oracle' ,@datasrc = 'DBTest'GO-- Add a login for the the remote linked server.USE [master]GOEXEC sp_addlinkedsrvlogin @rmtsrvname = 'Test_DBTest_shared' ,@useself = 'False' ,@locallogin = NULL ,@rmtuser = 'shared' ,@rmtpassword = 'Test1232' Then to create the SSIS Package, I go into Microsoft Visual Studio 2012 (it opens and displays Microsoft Visual Studio 2010 Shell). When I try to create a new OLE DB Connection to Oracle via Connection Manager, I select the "Native OLE DB\Microsoft OLE DB Provider to Oracle" I get the following error:"Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed."The Connection Manager does not display any o
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Financial Data Management All PlacesBusiness IntelligencePerformance Management ApplicationsFinancial Data Management This discussion is archived 6 Replies Latest reply on Jun 16, 2013 11:35 AM by Madhusudhan. M Unable to connect to the target database when creating FDM app Praveen. A Jun 10, 2013 10:53 AM Hi all,I am creating FDM application using Oracle database. i have all information to create application(Oracle database username,password, service name). i have verified that all the information also correct about the Oracle Database.[Hyperion 11.1.2.3, Oracle Database 11.1.1.6]But the problem, after entering all the information about the database in the application creation window, i am creating an error;Unable to connect to target database, please check the database details or contact Administrator.Please help me to resolve this issue..!Regards,Praveen. A 1701Views Tags: none (add) connectContent tagged with connect, databaseContent tagged with database, targetContent tagged with target, theContent tagged with the, toContent tagged with to, unableContent tagged with unable, fdm:Content tagged with fdm: This content has been marked as final. Show 6 replies 1. Re: Unable to connect to the target database when creating FDM app JeffJon Jun 10, 2013 12:47 PM (in response to Praveen. A) Is this a 64 bit machine?If so, the issue is most likely that the 32 bit Oralce Client and Oracle Provider for OLEDB have not been installed on the FDM application Server. If they have been installed, the proper TNSNAMES.ORA file with the connect descriptor for the database does not exist in the <32bitclientHome>\Network\Admin folder. Like Show 0 Likes(0) Actions 2. Re: Unable to connect to the target database when creating FDM app Praveen. A Jun 11, 2013 1:09 PM (in response to JeffJon) Hi,At the time installation, 32bit and 64bit clients installed.As you said, in <32bitclientHome>\Network\Admin folder, we dont have tnsnames.ora file. So, i have copied tnsnames.ora file from C:\app\dssadmin\product\11.2.0\dbhome_1\NETWORK\ADMIN to C:\Oracle\Middleware\dbclient32\network\admin.but still i am getting same error.Regards,Praveen.A Like Show 0 Likes(0) Actions 3. Re: Unable to connect to the target database when creating FDM app JeffJon Jun 11, 2013 2:57