How can I connect SQL server 2005 to DB2 on AS400?

by SQL Stan

Q:  How can I connect SQL server 2005 to DB2 in As400?

Jason Hall says:  On your SQL Server machine you should create an ODBC data source that connects to your DB2 instance. Once the datasource exists you should create a linked server inside of SQL Server. This linked server will allow you to run queries on your DB2 instance from within the SQL Server query engine. For more information you should look up “Linked Servers” in SQL Server 2005 books online.

Technorati Tags:





Related Posts

  1. How do I query DB2 data from SQL Server? Q:  We use DB2 Connect to access DB2 from MS...
  2. AS400 Linked Server not returning all rows Recently ran into an issue with a linked server...
  3. ETL Method – Fastest Way To Get Data from DB2 to Microsoft SQL Server For a while, I have been working on figuring out...
  4. Toughest SQL Server 2005 migration ever ! We're still not ready to support sql 2008 (Company...

About This Post

  • Digg
  • del.icio.us
  • DZone
  • DotNetKicks
  • Google Bookmarks
  • Ping.fm
  • Reddit
  • StumbleUpon
  • TwitThis
Share this post with friends

Leave a Reply