Re: Linked server error

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

Does the user your using have access to the table etc.

On Wed, Mar 2, 2011 at 3:04 PM, <Dean.Eshleman@xxxxxxxxxxxx> wrote:

> 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.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.