I have to set up a linked server between SQL Server 2000 and DB2 AS/400. I
have installed a DB2 client (version 7) on the sql server, then I set up the
linked server as following:
provider name = IBM OLE DB provider for DB2
production name = IBMDADB2
datane source = USCAGS03
provider string = UID=xxxx;PWD=xxxxx
Then I ran this query in SQL Server:
FROM OPENQUERY(TEST1, 'SELECT * FROM CLOCFILESK.MPUMFG05_PEOPLE')
and I got errors:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'SELECT * FROM CLOCFILESK.MPUMFG05_PEOPLE'. The OLE
DB provider 'IBMDADB2' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process
object, since the object has no columnsProviderName='IBMDADB2', Query=SELECT
* FROM CLOCFILESK.MPUMFG05_PEOPLE'].