Re: Linked server error

[Dean.Eshleman@xxxxxxxxxxxx]

Yes, the user has access to some of the tables.  The problem is we don't 
see any tables listed.  I would expect it to list any tables that the user 
has access to.  We did specify some libraries as part of the Provider 
string in the Linked server setup.

Dean

On Wed, 2 Mar 2011 15:10:13 -0500, in midrange.midrange-l you wrote:

> 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.

______________________________________________________________________
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.