I'm trying to connect to a DB2 database on an AS400, by adding a linked server to SQL 2000 using an ODBC and OLEDB data source, but when i try to access the tables i get this error message:
"Error 7399: OLE DB Provider MSDASQL reported an error. Authentication Failed. Data Truncated] Client unable to establish connection] OLE DB error trace [OLE/DB Provider 'MSDASQL' IDNInitialize returned 0x80040e4d: Authentication failed.]."
No error message appears when you create the linked server, just when you try to see the tables.