Can anyone help me understand what it takes to define a Linked Server
connection to an IBM eSeries (AS400)? Do I need Microsoft's SNA Server
or some other product or can I simply do it with the tools provided with
SQL Server 2000?

Any guidance would be very appreciated. Thanks.

Farid

[quoted text, click to view]

This discussion may help:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=xn%23U2D9sBHA.1752%40cpmsftngxa07

Hi Farid,

I managed this installing the AS400 Client Access for windows components
on the database-server.
At least you need the as400 odbc-database-driver on the windows-server.
Create a (system) odbc connection to your as400 and then create a linked
server to this odbc connection.
you maybe have to tweak / play around with the odbc-options for the
as400-connection to make it work.

just to point out the direction...

Tobias

[quoted text, click to view]