DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2001

    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
    Virginia, USA
    First configure tnsnames.ora, then go to odbc connections and create a entry for DB.


    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.