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
@Server=IBMTL400,
@SrvProduct='IBM AS400 OLEDB Provider',
@Catalog='mylibrary',
@Provider=IBMDA400,
@Datasrc=PRODCL400,
@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.

FCIB

I have added a linked logon but the error still persists.