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

Filed under: Database Design, Internals and Architecture — SQL Stan at 10:25 pm on Tuesday, July 31, 2007

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:



No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>