Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    13

    Unanswered: Need inof on DataSource..

    HI,
    Can anyone educate me what exactly refers to creating a datasource in oracle? Is it somekind of creating a shrotcut to the existing schema which can be referred from outside using webapplication or different?


    thanks in advance,
    S

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Are you refering to an ODBC datasource for Oracle connection?
    If so, go to the MS ODBC Administrator and:
    - Click on System DSN tab> Add
    - Select the name of the Oracle driver (vg. Oracle in Ora9i); click Finish
    - Set Data source name to your name of DB
    - Set Decription (optional)
    - Set TNS Service name = name of DB service in TNSNAME.ora file.
    - Set User ID = Oracle user id (optional).
    - Click OK.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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