Connect to Oracle Data Base

A

Abhinav

New Member
Hi Folks,

Is anyone assist me how to connect with Oracle Data base 11 G . If we have database server information , it is possible to provide directly a connection string in BluePrism VBO so that we can connect successfully without installing any Oracle software (like ODAC).

In case its mandatory to install ODAC , could you please assist what all are the steps to set up the connection .

Thanks
 
V

VJR

Well-Known Member
Abhinav said:
Hi Folks,

Is anyone assist me how to connect with Oracle Data base 11 G . If we have database server information , it is possible to provide directly a connection string in BluePrism VBO so that we can connect successfully without installing any Oracle software (like ODAC).

In case its mandatory to install ODAC , could you please assist what all are the steps to set up the connection .

Thanks
Click to expand...
Hi Abhinav,

This link should be able to help you in achieving the same for Oracle 11g via Blue Prism.
It also has the information on where to find the ODAC downloads but for the installation instructions you can do a websearch and get the same.
 
E

elhamdouni.dina

Member
VJR said:
Hi Abhinav,

This link should be able to help you in achieving the same for Oracle 11g via Blue Prism.
It also has the information on where to find the ODAC downloads but for the installation instructions you can do a websearch and get the same.
Click to expand...
Hello, even if i do the same logique i recieve this error msg " The ConnectionString property has not been initialized."!!
any idea about this problem ?!
 
E

elhamdouni.dina

Member
sivagelli said:
Could be something to do with your connection string. Can you validate your connection string? If you need assistance post your connection string here.
Click to expand...
should i already have oracle database installed on my devise ?,,, because when i tried to istalled ,,,it doesn't unstall successfuly !
 
S

sivagelli

Well-Known Member
Connection string is what is going in the below -

oracle-settings-for-data---oledb-object.JPG


Can you share screenshots of 'set connection' with expression evaluated? Also, do you have ODAC installed on your machine?
 
S

sivagelli

Well-Known Member
Lets take a step back, were able to use the same connection string and connect to the Database using any Oracle client?

I guess the connection string is not right here.
 
S

sivagelli

Well-Known Member
Are you using the same connection string taken from SQL Developer to BP? The error clearly says there is problem with credentials.
 
E

elhamdouni.dina

Member
sivagelli said:
Are you using the same connection string taken from SQL Developer to BP? The error clearly says there is problem with credentials.
Click to expand...

i use this cnx String : Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=port))(CONNECT_DATA=(SERVICE_NAME=name)));User Id=username;Password=pass;
 
S

sivagelli

Well-Known Member
Add Provider=OraOLEDB.Oracle; to the above cnx string and give a try.

Like this-
Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=port))(CONNECT_DATA=(SERVICE_NAME=name)));User Id=username;Password=pass;
 
E

elhamdouni.dina

Member
sivagelli said:
Add Provider=OraOLEDB.Oracle; to the above cnx string and give a try.

Like this-
Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=port))(CONNECT_DATA=(SERVICE_NAME=name)));User Id=username;Password=pass;
Click to expand...
i am working with UtilityDB VBO and it doesn't need the Provider attribute !
 
You must log in or register to reply here.
Top