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.

I created a logon but it still does not work.