1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

complex error with 12154: TNS:could not resolve the connect identifier specified

Discussion in 'SQL PL/SQL' started by SAMI1, Apr 5, 2011.

  1. SAMI1

    SAMI1 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi
    I searched to find any solution to solve this problem but I failed
    I am trying to solve this problem to connect my XE database
    I am using asp.net 2008
    Error Description
    If I build windows application the connection will be OK
    if I test the connection throw server explorer the connection will be OK
    but if I try to connect by website page the error will be TNS:could not resolve the connect identifier specified
    TNSNAME file is OK because I connected already
    main problem happened if I try to connect by running any website
    notice : My laptop is 64 bit
    TNSNAME TEXT IS

    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SAMI-TOSHIBA)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )



    please help me
     
  2. debasisdas

    debasisdas Active Member

    Messages:
    46
    Likes Received:
    3
    Trophy Points:
    90
    Location:
    Bangalore, India
    That will depend on your connection string that you are using from asp.net 2008.
     
  3. SAMI1

    SAMI1 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    waiting any solve