Netsuite ODBC - Linked Server Error
Posted: Thu 25 May 2017 18:34
hello
I have followed the steps in the documentation and created the Linked Server with MSSQL. I was able to create the Linked Server but when i expand the tables i get the following error
----------------------------------------
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The OLE DB provider "MSDASQL" for linked server "NETSUITE" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "MSDASQL" for linked server "NETSUITE". (Microsoft SQL Server, Error: 7399)
I have followed the steps in the documentation and created the Linked Server with MSSQL. I was able to create the Linked Server but when i expand the tables i get the following error
----------------------------------------
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The OLE DB provider "MSDASQL" for linked server "NETSUITE" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "MSDASQL" for linked server "NETSUITE". (Microsoft SQL Server, Error: 7399)