I’ve been trying to connect my robot to an Oracle database.
I read one of the articles under “Knowledge Base” called “How to query data from a SQL database” which states the workflow to query a DB, I cant really see anything that helps to connect to the DB, rather than this:
“A. First connect to the database using the Connect activity. This activity requests a connection string used to establish a database connection and a ProviderName. The string must contain a data source, a user name and a password”
However is vague and it does not justify what the String format should look like.
I need some insights from someone who managed to successfully connect to a DB with a String example and a connection setting summary
Following this thread, I am also trying to connect UiPath to an existing Oracle database. To do so, as said in previous posts, it is necessary to enter a string indicating user name, password and provider. I know the structure of the string but I don’t know exactly what provider means. Besides this, is it necessary to install a Oracle client to make the connection?
Now though i get the same error as described in this post: Error connecting to database but the solution doesnt help me. As far as I can read I have a problem with my ODBC, but what is the prerequisite for using this setup?
Alternately if I try to set up my connection with:
I get the error message:
“Connect : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor”
Hi, it looks like your connection is fine but there’s an error in your SQL query. You should be able to see the Oracle error message in UiPath Studio Output window. The Oracle SQL queries may need to be modified when you transfer them to UiPath, depending on what you want to do. For example double quotes need to be given as ascii character chr(34).