How to write TNS entry for server

Posted on 2009-02-15
Last Modified: 2013-12-18
Hi All,

I need to write TNS entry for to connect from organisation database.
test_db =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hydhtc100350)(PORT = 1521))
      (SERVICE_NAME = test)

Also can i connect to server from my organisation server (SQL Server).

Thanks in advance.
Question by:SivaKumarArepogu
    1 Comment
    LVL 3

    Accepted Solution

    In answer to your connectivity to SQL server, the best option is dbAmp from It installs to your SQL server as an SQL Linked Server and uses a provider that installs to the server and connects to your instance.

    You can read more about it in this post.

    As for TNS, I'm not sure what that means. Can you clarify? It looks like you are looking for some sort of API access? If so, check out the API docs. Here is the SOAP sample for initiating a session with salesforce from an external source.

    The full API docs/samples are here:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
    Read about achieving the basic levels of HRIS security in the workplace.
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now