Re: Linked server error

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

Does the user have access to the library/schema though.

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

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