Home » Developer & Programmer » Data Integration » MS Visual Studio and Oracle connectors (Oracle11g - MS VS 2015 SSDT or 2017)
MS Visual Studio and Oracle connectors [message #674028] Thu, 27 December 2018 07:39 Go to next message
gerkus
Messages: 1
Registered: December 2018
Location: DC
Junior Member
I am using MS Visual Studio SSDT 2015 for SSIS but I am not able to get connections to Oracle 11g database
I have downloaded Oracle XE for oracle client to my laptop and I am using Oracle Oledb and .NET connectors but I am getting error.

Pls check the 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.
Re: MS Visual Studio and Oracle connectors [message #674032 is a reply to message #674028] Thu, 27 December 2018 10:27 Go to previous message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Oracle client and networking components were not found.

You need to 1/ Install an Oracle client, 2/ set ORACLE_HOME and PATH environment variables.

Then the first test you have to make is to connect using SQL*Plus.

[Updated on: Thu, 27 December 2018 10:29]

Report message to a moderator

Previous Topic: ODI installer version 10.1.3.5 Unix compatibility
Next Topic: Issue while connecting to AS400 database from talend ESB
Goto Forum:
  


Current Time: Sat Dec 14 12:39:38 CST 2019