none
Liking netezza to SQL server RRS feed

  • Question

  • I am trying to link a IBM Netezza server to a Microsoft SQL server I have installed the OLE DB driver.

    I am getting the following error can someone help

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

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

    For help, click:

    ------------------------------
    ADDITIONAL INFORMATION:

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

    ------------------------------

    The OLE DB provider "NZOLEDB" for linked server "NETEZZA16" reported an error. Access denied.
    Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "NZOLEDB" for linked server "NETEZZA16". (Microsoft SQL Server, Error: 7399)

    Tuesday, November 26, 2019 8:17 PM