Use ODBC to connect to the Oracle database

This section briefly introduces how to use ODBC to connect to the Oracle database,

To be honest, use oracleclient, oledb, and ODBC to access the Oracle database,

It is relatively simple. It is nothing more than a note that the database connection string is OK,

The following is a database connection string.

Then let's take a look at the Demo code-behind.

 

A simple demo is to use ODBC to access the EMP data table from the Oracle database,

Then retrieve all the data in the table and bind it to a gridview. The result is OK,

The effect is

At this point, the data in Oracle is successfully obtained !!!