Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    46

    Unanswered: Question with TNSNames file

    I work for a company where there is an Oracle Database on the network. When I create a data source name within the ODBC configuration tool, I need to point to a server called local which will be used as part of my connect string.

    The problem is that I do not see the keyword local in my TNSNames.ORA file.
    How am I connecting to the Oracle database which is on the network and which has a name of local.

    Thanks.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    For the ODBC connection to be useable, you need to have sqlNet installed on the client machine, a valid tnsnames.ora table containing the defination, an uptodate oracle ODBC driver installed, and a system DSN setup for the server.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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