Results 1 to 2 of 2

Thread: Oracle&Delphi

  1. #1
    Join Date
    May 2003
    Posts
    1

    Exclamation Unanswered: Oracle&Delphi

    Dear Sir(s):

    I have a Delphi application , dealing with Oracle DB , I tried 2 make a

    service 4 connecting Oracle with Delphi , but this message always

    appears when I try to make The connection from Delphi :

    "couldn't resolve service name"

    Plz help me.
    Last edited by 7ala; 05-21-03 at 18:15.

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Could not resolve service name simply means that the Oracle client does not know of a server or instance by the name you've given.

    Check it at a command prompt using
    TNSPING <servicename>

    If that works, then you know the service is configured properly. If not, have a look in a file called TNSNAMES.ORA located somewhere under c:\oracle (or wherever you installed the oracle client).

    All of the various instances and names will be in there. If you can't find your instance named in there, then copy the tnsnames.ora entry from another machine that has got a correct entry, or copy & paste an existing entry and make the necessary changes.

    Use something like SqlPlus to confirm your client etc is configured correctly, once you've done that, then try to get Delphi connecting.

    HTH
    Bill

Posting Permissions

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