Linked Server

Posted in 2015

JOHN KRUPA — Mon, 06 Jul 2015 14:13:45 — source: IIUG Forums & Mailing Lists

I am trying to link my Informix db server to a SQL Server instance. The connection tests successfully but I receive the error below when opening the folders beneath the server entry. All help is appreciated. Thanks John Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "Ifxoledbc" for linked server "STRATIX_PRODUCTION". The provider supports the interface, but returns a failure code when it is used. (Microsoft SQL Server, Error: 7311)

↪ replying to JOHN KRUPA

Paul Watson — Mon, 06 Jul 2015 15:33:47 — source: IIUG Forums & Mailing Lists

Did you run the OLE setup sql/script on the server ? Cheers PAul Paul Watson Oninit www.oninit.com +1 913 387 7529 Oninit® is a Registered Trademark of Oninit LLC > On Jul 6, 2015, at 09:13, JOHN KRUPA <jkrupa@turretsteel.com> wrote: > > I am trying to link my Informix db server to a SQL Server instance. The > connection tests successfully but I receive the error below when opening the > folders beneath the server entry. All help is appreciated. > > Thanks > John > > Failed to retrieve data for this request. > (Microsoft.SqlServer.Management.Sdk.Sfc) > > An exception occurred while executing a Transact-SQL statement or batch. > (Microsoft.SqlServer.ConnectionInfo) > > Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider > "Ifxoledbc" for linked server "STRATIX_PRODUCTION". The provider supports the > interface, but returns a failure code when it is used. (Microsoft SQL Server, > Error: 7311) > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.