Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Question Unanswered: ORA 12154: TNS: Service name could not...

    Hi,

    At work I'm writing a program to store reports in to an oracle database.
    On the developing computer I can access the database and do what is needed.
    With Toad I can look in to the database from any point on the network.
    The database is on de coporate network.

    When I run my program on another pc then the developers one, I get the error: "ORA 12154: TNS: service name could not be resolved."

    I have checked the tnsnames.ora file and the entry in there is exactly the same as in the tnsnames.ora file on the developer computer.

    Since Toad uses the tnsnames.ora file as well, I know the entry in there is ok.
    But then what is the problem?

    I am writing the program in VB.NET and I use Oracle 9i.

    What could be the difference between the developers computer and any other pc, if they both have the same tnsnames.ora file and oracle 9i installed?

    Please help?

    rg,
    Eric

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Did you check "sqlnet.ora" in the same directory too?

  3. #3
    Join Date
    Dec 2004
    Posts
    2
    Yes I have and I didn't find anything that is not how it should be.

Posting Permissions

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