Sybase to SqlServer

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  December 13, 2007 at 2:34 am

  #73876

  I need to connect sybase from sqlserver.How should i connect ?

  karthik

• Key DBA

  SSCertifiable

  Points: 6029

  More actions

  December 14, 2007 at 12:39 pm

  #760429

  Karthik,

  If you can provide the Version of SQL Server and Sybase, I can get more specific.

  I found a walkthrough for "Configuring a Microsoft SQL Server Linked Server with Sybase ASE (TDS) OLEDB Provider Using NT Authentication

  " at:

  http://www.sybase.com/detail?id=1029118

  There is a link to a Word document with Text and Screenshots, covering the configuration.

  If that will not work for you, I would go the route of configuring and ODBC Connection or a Linked Server from within SQL Server.

  Hope this helps.

  "Key"
  MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  December 21, 2007 at 1:06 am

  #761993

  I am using sqlserver2000 and sybase12.5.3.

  karthik