Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: SQL to AS/400 using IBMDa400

    I am trying to create a linked server to the AS/400. I use the following and it is added successfully or so I believe.

    EXEC sp_addlinkedserver
    @SrvProduct='IBM AS400 OLEDB Provider',
    @Provstr='Provider=IBMDA400.DataSource.1;Password= userpass;Persist Security Info=True;User ID=user;Data Source=PRODCL400;Catalog Library List=Mylibrary'

    However when I attemt to execute a query on this server I get - cannot create an instance.

    select * from OPENQUERY(IBMTL400,'SELECT * FROM tablename ')

    Server: Msg 7302, Level 16, State 1, Line 1
    Could not create an instance of OLE DB provider 'IBMDA400'.

    I looked up this error and reregistered the msdaps.dll however the error still persists.

    Do I need to create a logon before I can execute the query.


  2. #2
    Join Date
    Sep 2003
    I have added a linked logon but the error still persists.

Posting Permissions

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