Post reply

Data transfer from as 400 to SQL

  • October 11, 2006 at 4:05 am

    #170610

    Hi

    I am trying to tranfer data from a as400 / iSeries 5 to SQL. I am using the iSeries connector on my local PC but it is not on the server. IS there any way that i can connect to the as400 from the SQL server with out the connector?

    Please help

    New Developer

  • October 12, 2006 at 12:16 am

    #665384

    Hi

    As far as I know No. Unless you want to dump to text files first then import the files.

    Mike

  • October 12, 2006 at 1:38 am

    #665392

    Thanks Mike

    No i dont want to dump to text files.

    I will keep on searching

    New Developer

  • October 12, 2006 at 6:32 am

    #665447

    Why don't you do a linked server then write some select statements using openquery to get your data into sql.

  • October 12, 2006 at 6:50 am

    #665458

    Hi

    Correct me if I am wrong but as far as I know you will still need the AS400 driver on the server to add it as a linked server?

    Mike

  • October 12, 2006 at 7:24 am

    #665471

    All my reseach also points that the as400 driver must be on the SQL server.

     

    New Developer

  • October 12, 2006 at 7:30 am

    #665477

    Yes, you will need the AS400 driver on the SQL server. The way we do it is to install IBM Client Express (at least the base and data components), then we use the Iseries ODBC to extract data from the 400 to the SQL box..

     

     

  • October 12, 2006 at 7:32 am

    #665480

    Thanks

    Will chat to the DBA's and see if it can be installed.

    New Developer

  • October 12, 2006 at 10:54 am

    #665555

    When you isstall the iSeries Client software it has an option to choose the ODBC Driver to be installed. You need to have this installed wherever you are running your package either in the SQLServer machine or any other server / client workstation

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply