Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Question Unanswered: Linked server AS400/DB2 trouble again

    Hi !
    I'm trying to create Linked Server to AS400 DB2 on SQL Server 2000.
    Using IBMDA400 (IBM AS400 OLEDB Provider installed from Client Access).

    Got an error 7399: OLEDB Provider returned UNKNOWN error.


    exec SP_AddLinkedServer
    @Server=AS_SERVER,
    @SrvProduct='IBM AS400 OLEDB Provider',
    @Catalog='QGPL',
    @Location='AS_SERVER',
    @Provider=IBMDA400,
    @Datasrc=AS_SERVER,
    @Provstr='Provider=IBMDA400.1;Password="";User ID=AS_USER;Data Source=AS_SERVER;Transport Product=Client Access;SSL=DEFAULT;Libraries=QGPL;Connect Timeout=90;Host Code Page=037'

    Attempted different combinations of theese params...

    After that created remote login on AS400.

    Please help or correct my LinkedServerProperties...

    Regards,
    PV

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    Have you looked at this old posting:

    dbForums - BD2OLEDB
    MCDBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •