Therefore, below steps would install everything required. When installing the Oracle Instant Client, we are automatically installing the ODBC driver for Oracle as well. Since, our target is a Oracle Database, we need below components along with a up and running Oracle database server (local/remote). NET Framework Data Provider for ODBC can be used for data sources exposed using ODBC.
Net Framework data providers can be used to execute commands, and retrieve results. As we are dealing with Oracle database, which is a relational database, let’s focus on ODBC. Net application, we must use either ODBC (Open Database Connectivity) or OLEDB (Object Linking and Embedding Database). If it is a Java application, you can use the JDBC (Java Database Connectivity) driver. You can get an idea about relational and non-relational databases from here. OLEDB – API developed by Microsoft to access both relational and non-relational databases.ODBC – API developed by Microsoft to access relational databases.JDBC – API developed by Oracle to access the relational and non-relational database.
There are three main types of APIs that can be used to connect to various kind of databases. For any software which requires to access a database, it is required to use an API, which connects the application to the database and facilitate the insert, update and delete functions on data. Suppose you need to access data in a Oracle Database from a. It enables applications to connect to a local or remote Oracle Database, while providing the necessary network connectivity, as well as basic and high end data features. Oracle Instant Client is a collection of free, light-weight, and easy to install Oracle Database tools, libraries and SDKs which can be used for building and connecting applications to an Oracle Database instance.
How to Install Oracle Instant Client in Windows