IBM iSeries linked server

[unclerico]

SQL Server 2000 SP4
Windows 2003 Sp1

I have tried and tried and tried to set up a linked server for the IBM iSeries in SQL but I cannot get it to work...has anyone successfully registered an iSeries linked server??

Here is what I have done:

EXEC sp_addlinkedserver
  @server='Sys21',
  @provider='IBMDA400',
  @srvproduct='Microsoft OLE DB Provider for DB2',
  @datasrc='servername',
  @provstr='Provider=IBMDA400.DataSource.1;User ID=userid;Password=password;Data Source=xxx.xxx.xxx.xxx;Connect Timeout=30;SSL=DEFAULT;Transport Product=Client Access',
  @catalog='catalogname'

Any time I try to execute a query SQL Server comes back with:

Server: Msg 7303, Level 16, State 2, Line 1
Could not initialize data source object of OLE DB provider 'IBMDA400'.
OLE DB error trace [OLE/DB Provider 'IBMDA400' IDBInitialize::Initialize returned 0x80040e21].

I know my credentials are correct because I can make a connection to the iSeries via Reporting Services but nothing else...thanks for help ahead of time.

 

[unclerico]

bump...

 

[unclerico]

I figured it out, I just created an ODBC connection to the AS400 and used the MSDASQL provider