hoganmerideth (AT) russellcorp (DOT) com had previously posted this message (ID:
58d9d350.0207170548.a8fa932 (AT) pos...OT) google.com) on 2002-07-17:

-----
We are receiving the following error in our SQL Server 7.0 DTS
Package.

Error: -2147217900 (80040E14); Provider Error: 7303 (1C87)
Error string: Could not initialize data source object of OLE DB
provider 'DB2OLEDB'. Error source: Microsoft OLE DB Provider
for SQL Server Help file: Help context: 0 Error:
-2147217900 (80040E14); Provider Error: 7312 (1C90) Error
string: [OLE/DB provider returned message: User does not have the
authority to access the host resource. SQLSTATE: HY000, SQLCODE: -257]
Error source: Microsoft OLE DB Provider for SQL Server

In the dts we call a stored procedure that uses openquery to pull back
DB2 tables. This was working in the past, but we had to reformat our
server last night and we are now having problems. You can use oledb
in the dts to pull back information,but it will not work in query
analyzer or using openquery.

We are running Windows Nt 4.0 and installed SNA 4.0 Service Pack 4,
but this has not fixed this problem.

Does anybody have any ideas or suggestions?
-----

I work with Hogan and ran across the same problem again this past
month. Figured I'd post the solution JIC anyone else needed it (and so
we'd have it documented). We had the SNA 4.0 SP2 client installed on
the SQL Server box to load the the DB2OLEDB driver. The problem was
solved by upgrading this client to SNA 4.0 SP4. SP4 evidently contains
an updated version of the DB2OLEDB driver that resolved this issue.

-Ed