Connect to Oracle 10g using Odbc

Posted on 2008-11-07
Last Modified: 2013-12-19
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 ?
Question by:interbus
    LVL 8

    Expert Comment

    For me, the most useful site for doing a "live" connection string configuration is:

    Author Comment

    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

    LVL 8

    Accepted Solution

    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...

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now