topic Re: Oracle DB connection in Product Forum

Oracle DB connection

RahulRamesh — Wed, 05 May 2021 05:47:16 GMT

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 :?

Re: Oracle DB connection

_Amlansahoo — Wed, 05 May 2021 06:56:49 GMT

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 😉

Re: Oracle DB connection

RahulRamesh — Wed, 05 May 2021 13:08:49 GMT

@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

Re: Oracle DB connection

_Amlansahoo — Wed, 05 May 2021 13:22:52 GMT

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

Re: Oracle DB connection

michaeloneil — Mon, 10 May 2021 15:30:33 GMT

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.