Configuring an ODBC Connection for Oracle

To configure an ODBC Connection for Oracle you will need the following:

  • Install the Oracle Client or Instant Client on your PC.
  • Service Name. This is the global database name for your database.
  • Communication Protocol. Use TCP.
  • Host Name. Enter the IP address or host name of the machine on which the Oracle server resides. Use localhost if the database resides on your own machine.
  • Port Number. The default port (1521) will generally be the correct value. However, it is possible to configure Oracle to use a different port.
  • Set up a tnsnames.ora file. This can be placed either in the same directory as the Instant Client or some other directory. The Instant Client provides no means to configure the tsnames.ora file (which contains the Oracle network names). The easiest way to create tnsnames.ora is to set it up on a machine that has the full client then copy it across.
  • Set environment variable TNS_ADMIN to the directory containing tnsnames.ora

About Jennifer Siegel

Jennifer (aka Pixie), OCI, OCWE, OCWV, has over 20 years of experience in the Information Technology field, which includes 13 years of Systems Administration, 15 years of developing and implementing technical documentation and training, and 10 years supporting OnBase deployments. She has extensive experience with SQL and a firm foundation in computer science. Despite this, she considers herself a well-adjusted nerd with hobbies including archery and knitting in public.

Subscribe to our Newsletter!

We will send you a newsletter once a month with updates from our blog, resource library, and events calendar.

Newsletter Sign Up
Interested to see what ECM can do for your company?
Get in touch with us today to learn more
Contact Us
  Contact Us

Contact Us Today

  • This field is for validation purposes and should be left unchanged.