I'm trying to link AS400 server to SQL Svr from the SQL Server.
I can see the AS400 in the servers list from SQL Server 2k5.
However, when I tried to run a SELECT stmt, I got this error:
OLE DB provider "IBMDA400" for linked server "as400" returned message "CWBCO1004 - Remote address could not be resolved ".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "IBMDA400" for linked server "as400".
Desparately need help