Linked server error

[Dean.Eshleman@xxxxxxxxxxxx]

Hi,

I'm trying to setup a linked server in SQL Server to access my System i. I 
created the linked server and the test connection option is successful. 
The error occurs when I try to expand the "Tables" folder underneath the 
linked server.  The error I receive is:

Failed to retrieve data for this request. 
(Microsoft.SqlServer.Management.Sdk.Sfc)

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

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object 
connectionInfo, Request request)
   at 
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList`1 
nodes, INodeInformation source, INavigableItem sourceItem, String 
urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
   at 
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList`1 
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider 
filter)
   at 
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(IList`1 
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider 
filter)
   at 
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren(IGetChildrenRequest 
request)
   at 
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle 
quitEvent)

===================================

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

------------------------------
Program Location:

   at 
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String 
sqlCommand)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String 
query)
   at 
Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql 
execSql, String query)
   at 
Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection 
query, Object con, StatementBuilder sb, RetriveMode rm)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType 
resultType, StringCollection sql, Object connectionInfo, StatementBuilder 
sb)
   at 
Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult 
sqlresult, ResultType resultType)
   at 
Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult 
result)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult 
erParent)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
   at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request 
req, Object ci)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object 
connectionInfo, Request request)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object 
connectionInfo, Request request)

===================================

The OLE DB provider "SQL Server" for linked server "(null)" reported an 
error. The provider did not give any information about the error.
Cannot fetch a row from OLE DB provider "SQL Server" for linked server 
"(null)". (.Net SqlClient Data Provider)

******************************End of error message 
****************************************************************************************************

The other thing I noticed is that it isn't picking up the Relational 
Database Directory Entry as the "Catalog" name.  It shows "default".

MyLinkedServer
   Catalogs
      System catalogs
      default    <--- I would expect this to be the RDDE entry
         Tables

We are using the IBM DB2 UDB for iSeries IBMDA400 OLE DB provider.  The 
version of iSeries Access for Windows is V6R1 and SQL Server 2008.

Dean Eshleman,
Everence Financial

______________________________________________________________________
Please note my e-mail address has changed

Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information.  If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.