Defining AS400 Linked Server

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • fn
    #1

    Defining AS400 Linked Server

    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

    Tags: None
    • Tobias Marquart
      #2
      Re: Defining AS400 Linked Server

      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:
      [color=blue]
      > 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
      >[/color]

        Comment

        • Simon Hayes
          #3
          Re: Defining AS400 Linked Server

          fn <f_n_a_c_e_r_re moveunderlines@ hotmail.com> wrote in message news:<56-dnf8HPfeXyJrcRV n-qw@britsys.net> ...[color=blue]
          > 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[/color]

          This discussion may help:

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


          Simon

            Comment

            • ffoiii
              #4
              Re: Defining AS400 Linked Server

              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_n_a_c_e_r_re moveunderlines@ hotmail.com> wrote in message news:<56-dnf8HPfeXyJrcRV n-qw@britsys.net> ...[color=blue]
              > 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[/color]

                Comment

                Previous template Next
                Working...