How to create an Oracle DSN?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to create an Oracle DSN?

  1. #1
    Join Date
    Apr 2001
    Posts
    19
    Hi,

    I don't know whether or not I am posting this question at the right forum, but I was wondering if anyone can show me how to create a DSN to connect to Oracle DB? TIA
    Knowledge is the function of being.

  2. #2
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    First configure tnsnames.ora, then go to odbc connections and create a entry for DB.

    (e.g)

    STEP 1)
    using configuration wizard.

    DB Alias = ORCL
    Protocol = TCP/IP
    Port = 1521
    DB name = ORCL
    test the service username/password (scott/tiger)

    STEP 2)

    Go to ODBC Driver

    System DSN -->ADD--> Give it a same name as you have given in STEP1 --> give username and Password for Database (scott/tiger) you should be ready to go.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width