Creating a linked server to DB2 within SQL Server Management Studi

Hi,

I've successfully created a Linked server within SQL Server 2005 Management
Studio to a DB2 database (DB2 is hosted on Windows Server 2003). If I right
click the linked server and select 'Test Connection' and get a message 'The
test connection to linked server succeeded'.

However, when I try to expand Catalog node I receive the following error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

The OLE DB provider "SQL Server" for linked server "(null)" reported an
error. One or more arguments were reported invalid by the provider.
Cannot obtain the schema rowset "DBSCHEMA_CATALOGS" for OLE DB provider "SQL
Server" for linked server "(null)". The provider supports the interface, but
returns a failure code when it is used. (Microsoft SQL Server, Error: 7399)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3050&EvtSrc=MSSQLServer&EvtID=7399&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


At the time of posting this question, if I follow the link in the error
message, there was no information on the error.

Any help much appreciated.

Thanks in advance,
Samad Khan

.

Loading