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
And I have set the Enviroment Variable PATH to the directory of the Oracle Instant Client extraction.
Still it does not work. Can you please be more specific what am I doing wrong?
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?
I have similar issues failing to understand how to set a oracle db connection up.
But my question is: Do I have to the client installed for this to work?
This is what I had to do to get a working connection to a Oracle database in a Windows Server 2012 R2 server.
Install Oracle Instant Client (done by an Oracle expert)
Create System DSN data source in the ODBC Data Sources (done by an Oracle expert)
Use DatabaseConnect activity in UiPath
3a. Enter ConnectionString, for example “Dsn=YourDBName;uid=UserID;pwd=password”
3b. Enter ProviderName “System.Data.Odbc”
I was able to install a Oracle client (both a x32 and a x64, since i got the error from this post: Connecting to Oracle Database) .
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:
ProviderName: “System.Data.OracleClient”
ConnectionString: “SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myHostNam)(PORT=myPort))(CONNECT_DATA=(SERVICE_NAME=mySID)));uid=myUsername;pwd=myPwd;”
I get the error message:
“Connect : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor”
Yes please check your tnsnames.ora file that it contains valid information. Also test your DSN connection from the ODBC driver conf if possible. This example is from Win Server 2012 R2
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).