471,896 Members | 2,570 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,896 software developers and data experts.

Defining AS400 Linked Server

fn
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

Jul 20 '05 #1
3 7763
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

fn wrote:
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

Jul 20 '05 #2
fn <f_**************************@hotmail.com> wrote in message news:<56********************@britsys.net>...
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


This discussion may help:

http://groups.google.com/groups?hl=e...40cpmsftngxa07

Simon
Jul 20 '05 #3
I found IBM's Client Access drivers to be error prone and slow.

Although not-free, Hit Software, www.hitsw.com, provides OLEDB and
ODBC drivers for accessing DB2/AS400 servers. I used the OLEDB driver
with great success.
ffoiii

fn <f_**************************@hotmail.com> wrote in message news:<56********************@britsys.net>...
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

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by mechweb | last post: by
reply views Thread by Noor | last post: by
4 posts views Thread by Brad Allison | last post: by
1 post views Thread by accyboy1981 | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.