Connecting to Oracle ODBC in windows 10

I have pretty much read (I hope) all questions related to successfully connecting to an Oracle database using Microsoft ODBC Driver for Oracle. I even tried the following:

Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=UserName;Pwd=Secret

after replacing server, uid and password. I’m still running into trouble.

Has anyone really solved this other than those being lucky in the first attempt?

Hi @csathys

Does this topic help?

Hello Loginerror

This solution does not say what version of windows they installed in. Besides, Oracle instant client is available in different flavors such as 64 bit, Base package, tools package etc and for various versions such as 12.2.0.1.0, 12.1.0.2.0, 11.2.0.4.0, 11.1.0.7.0 , 10.2.0.5 etc with 18.5.0.0.0 being the latest. I’m really confused as to what versions these are referring to.

I have installed Oracle database 11g version 11.2.0.1.0 64 bit.

Any help from here?

What provider name have you set your activity too?

@loginerror Could you please help me How to execute PL SQL Procedure through UiPath?

My Procedure have 3 Input arguments and returns 5 Output values.

Let me know how to call PL SQL procedure through UiPath.

I advise you also to try ODBC Driver for Oracle
This driver provides a high-performance and feature-rich connectivity solution for ODBC-compliant applications to access Oracle databases from Windows, macOS, or Linux, both 32-bit and 64-bit