Oracle DB connection

[RahulRamesh]

Hello,
I am having credentials of Oracle DB and those credentials would be the 

Username, Password, Role, Hostname, Port, SID of the DB...

 I have imported the OLE DB VBO and tried to use Set connection, but not sure which values corresponds to which fields. can u please help me on this?
Database :?
password:?
provider:?
connection string :?

[_Amlansahoo]

Hey Rahul you can use connection string like below

Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[Host Name])(PORT=[Port]))(CONNECT_DATA= (SERVER = DEDICATED)(SERVICE_NAME=[Service Name])));User Id=[Database User ID];Password=[Database Password];

Sometimes the connection string may change according to your organization so ask DBA team to give you above string so you can format it
Those are square bracket just give all your details and it works.

Hope it helps 😉

[RahulRamesh]

@Amlan Sahoo
Hello Amlan,
Thanks for your response. Have tried the connection string which you have provided by providing the appropriate values. The error was not happening at "Set Connection" Activity.
While trying "Open" activity under OLE DB VBO it was throwing the following error:

"Could not execute code stage because exception thrown by code stage: The 'OraOLEDB.Oracle' provider is not registered on the local machine."
Can you please help me out on this Exception?

Thanks in advance,
Rahul Ramesh​​​

[_Amlansahoo]

Rahul I guess you need to install Oracle Client. You can google it how to do it.

[michaeloneil]

Hi Rahul

With the oracle provider error you are missing the Oracle Data Access Components on your machine. If you look for this or search for ODAC you should find the download on oracles website. You might need to register to download it though.