What is the SQL Server equivalent of TNSNAMES.ORA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: What is the SQL Server equivalent of TNSNAMES.ORA

Hybrid View

  1. #1

    What is the SQL Server equivalent of TNSNAMES.ORA

    Hello Gang,

    At the moment am looking into consolidating SQL Server databases. I am basically an Oracle DBA and know very little about SQL Server.

    The question is, if I move the database to a new server then in Oracle I will change the values in TNSNAMES.ORA to point in the right direction. Where should I do this in case of SQL Server 7?

    Thanks in advance,
    -Shyami
    ------------------------------------------
    Shyami.S.Seelan, OCP 8i, 9i DBA
    Dublin, Ireland.
    http://www.geocities.com/shyamiseelan/OCP
    ------------------------------------------

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    I guess you should make entry in the DSN ??
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    Oracle:
    Client->ODBC or OLE DB->Net8->TNS->Listener->Server

    MS:
    Client->ODBC or OLE DB->Client Net Library->TDS->Server Network Library->SQL Server RDBMS

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Windoz right? Did you try to reboot?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    CTRL+ALT+DELETE

    Try sqlteam.com

Posting Permissions

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



Click Here to Expand Forum to Full Width