How to Create ODBC Connection for Oracle 11g?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

Here I am giving a step-by-step example to create ODBC connection for Oracle 11g database on Windows 10 PC.

Steps to Create Oracle 11g Database ODBC Connection on Windows 10

  1. Click on the Start Menu > Windows Administration Tools > ODBC Database Sources 32bit or 64 bit according to your PC.
  2. An ODBC Data Source window will open as shown in the below image.

Create Oracle 11g Database ODBC connection on Windows

  1. You can create three types of ODBC connection here, User DSN, System DSN, and File DSN. Create User DSN if only you want to use the ODBC connection on your system. Create System DSN if you want to allow all the users can use this ODBC connection on your system. Create File DSN to share the connection file to users having the same system configuration.
  2. In this example, I am creating an ODBC connection using User DSN. Now click on the Add button to configure ODBC for Oracle 11g database connection. A window will open as shown in the below image:

Configure ODBC Connection for Oracle 11g

  1. Specify the Data source name, Description, TNS service name (Oracle Database name on your computer) and the User ID.
  2. Then click on the Test Connection button to test the connection by specifying the password when asked. Make sure your Oracle Database Service on Windows system is running with Oracle TNS service.
  3. If everything is ok, then you will get the successful connection message. Then click on the OK button to save the configuration.

Now you can use this connection into other applications such as Excel to connect to Oracle 11g Database.