Unable to connect Oracle Database

Help
, ,
1

Hi All,

I have followed all the instructions from different solutions in the DB connectivity for oracle db, but nothing helped me for successful DB connection from UIPath.

I am using Oracle 11g, Windows 10 64-bit operating system and installed oracle 11g client. Using below connection strings which doesn’t helped.

  1. “Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.0)(PORT=1521)));Uid=xxx;Pwd=xxx;”
    System.Data.odbc and System.Data.Oracleclient

  2. “DRIVER={Oracle in OraClient11g_home2};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.0)(PORT=1521)));Uid=xxx;Pwd=xxx;”
    System.Data.odbc and System.Data.Oracleclient

  3. Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=TESTUAT))(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.0)(PORT=1521)));Uid=XXX;Pwd=XXX;”
    System.Data.odbc and System.Data.Oracleclient

Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=UserName;Pwd=Secret;
System.Data.odbc and System.Data.Oracleclient

Can I get immediate assistance to resolved this issue.

Thanks a ton
Kiran

2

Have you installed 11g client 32 bit?

If not try installing 32 bit and try to create ODBC

Thanks

3

I have installed 11g client, created ODBC connections.
Connections are successful.

4

Ok, what’s the issue?

Can you share me a screeshot of error?

Thanks

5

I am getting “Connect: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application”

6

Please check this

Hope this will helps

Thanks

1 Like