var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
@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.
I have added a linked logon but the error still persists.