question

apple avatar image
apple asked

Connection to Oracle

Hello! I have Oracle 12 installed on 64 bit machine. I get the connection error when trying to connect though SSIS package -- Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. Is there a way to find what is missing. Also I did verify the Oracle_Home environment variable exists. Appreciate the help Thank you
ssisoracle
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Lukasz8519 avatar image
Lukasz8519 answered
https://www.mssqltips.com/sqlservertip/4396/creating-a-sql-server-2014-linked-server-for-an-oracle-11g-database/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Lukasz8519 avatar image
Lukasz8519 answered
You need attunity connector, download from link below https://www.microsoft.com/en-gb/download/details.aspx?id=29284
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.