creating a connection to DB2 from sql server

• sahana

  SSCrazy

  Points: 2530

  More actions

  December 22, 2004 at 8:46 am

  #361795

  Can We Create a SQL Server connection to DB2 using linked servers?If yes, how can we do that.ANd one more thing is that my DB2 is on unix and sqlserver is on windows.

  Thanks.

• Tom Goltl

  SSCertifiable

  Points: 5815

  More actions

  December 22, 2004 at 1:50 pm

  #534827

  I connect to db2/400.  I created an ODBC datasource to the db2, and then created my linked server to the odbc datasource.  Works great.

  Tom