• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2020
  • Last Modified:

Connect to Oracle 10g using Odbc

How I can connect Oracle 10g through Odbc ?

I'm using Oracle in OraDb10g_home1 driver

What exatly I can write in TNS Service Name in Oracle ODBC Driver Configuration ?
  • 2
1 Solution
For me, the most useful site for doing a "live" connection string configuration is:

interbusAuthor Commented:
I want to using Data Sources (ODBC) to connect Oracle Database.

The Data Sources (ODBC) is available in administrative tools in Control Panel

There was new driver is called Oracle in OraDb10g_home1

my question here about TNS Service Name what I write inside this combobox

The TNS name is something you need to configure through the Oracle Net Configurator. In the configurator, you will need to specify the following information:
- the service name
- the server's name you are connecting to
- the protocol (in the case of a network connection, select TCP/IP)
- the port (usually 1521)

The Configurator will then allow you to test this connection, and then save it using a service name you choose. This service name is what you will need to type into the "TNS Service Name" in the ODBC configuration screen.

Please remember: the DSN (Data Source Name) is what your applications will use for a connection, rather than the TNS Service Name!

The only thing which I am a little unclear about is where you got the "OraDb10g_home1" name from? Was that already in the TNS Name drop-down? That is not a standard driver name that I recognize...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now