I am trying to build a cube in sql server 2005 analysis services using
underlying tables from DB2 on AS400.

I have downloaded and installed the Microsoft OLEDB Provider for DB2.

In Visual studio I create an analysis services project and try to add a new
datasource. When testing the connection I receive the following message:

Test Connection failed because of an error in initializing provider.
Unspecified error DB_E_ERRORSINCOMMAND(0x80040E14)

I then tried to use the data access tool that was installed with the
provider. When I try to test the connection in here i receive the following
error message

Could not connect to data source. The host resource could not be found.
Check that the Initial Catalog value matchets the host resource name.
SQLSTATE: HY000,SQLCODE:-360

I would appreciate if anybody could offer some suggestions as to when is
wrong with my setup.

I am using visual studio 2005 and SQL Server 2005 developer edition. I have
created several connections to my DB2 database using different providers in
visual studio but as i understand it, to build a cube in SQL AS, I must use
the Microsoft OLE DB Provider for DB2. If I use a different provider, i can
create the data source but run into different problems further down the line.