Not able to Connect to 64 Bit Oracle DB 11g Express Edition through UiPath

Help
1

I have Oracle XE 11g 64 bit version installed in my laptop and I have created a user DSN in the ODBC Datasource tool 64 bit tool for the XE. and that got displayed in Uipath under connection settings but providing all the required uid and upassword, it is displaying architecture mismatch
error when test connection.

err1
err11366Ă—699 55.8 KB

I understand I can uninstall 64 bit oracle xe and install 32 bit but is there any other way since in my project they say they have to go with 64 bit only. Please help and it is urgent

1 Like
2

Hi @Mohanraj_Murugesan,

Welcome to UiPath Community…!! :slight_smile:

Install 32 bit and 64 bit Oracle 11g Client versions in your machine. While installing create separate folders for 32 bit version and 64 bit version. Try this and let me know.

Thanks.!
Ramprasad

2 Likes
3

I installed both clients now what should I do in UiPath and ODBC tool? Please give steps

1 Like
4

Hope you have installed both client versions in different folders and installed UiPath.Database.Activities in UiPath Studio.

First Connect the Database…

  1. Prepare Connection String as below :

SERVER= (DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=#HostName#)(PORT = #PORT_Number#)))(CONNECT_DATA =(SERVICE_NAME = #Service_Name#)));uid=#UserID#;pwd=#Password#;

  1. Replace all # tags with your information.

  2. Take Connect Activity.

  3. Update your connection string in the ConnectionString field.

  4. Select ProvideName as “System.Data.OracleClient”

  5. Create a Variable for DatabaseConnection.

Connect1

  1. Now use this DatabaseConnection Variable as a ExistingConnection to Execute Query, Execute Non Query , Insert, Start Transaction. Create a DataTable variable for Database Output.
    Connect12
    Connect121228Ă—488 22.5 KB
  2. Then Close the Database Connection with Disconnect activity.

Cheers @Mohanraj_Murugesan

Thanks.!
Ramprasad

2 Likes
6

Don’t post Confidential information in the Forum(DB Details, Credentials etc). Check the Connection string once again , Seems there is a dot at the end, remove it.

Cheers @Mohanraj_Murugesan,

1 Like
7

Hi Ram,
Thanks, I was little exited.
My Bad, I missed to put the expression inside the quotation “” now no compile error but when I execute the main script, I get the below error,

DB_error
DB_error1366Ă—582 54.1 KB

is there any specific folder I need to install the 32 and 64 bit clients, Will the re installations helps?

8

@Ramprasad Hi Any update on my error I posted after installing both clients 32 & 64 bit

9

Install both Clients in different folders…It will work.