Netsuite ODBC - Linked Server Error

Netsuite ODBC - Linked Server Error

Postby rajasaab » 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)
rajasaab
 
Posts: 1
Joined: Thu 25 May 2017 18:29

Re: Netsuite ODBC - Linked Server Error

Postby MaximG » Fri 26 May 2017 11:52

Please specify:

a) What account does the 'SQL Server' service run (LOCAL SERVICE, NETWORK_SERVICE, etc.) ?
b) What authentication type are you using: SQL Server : Windows Authentication or SQL Server Authentication?

In our test environment we use Linked Server when working with SQL Server Authentication, and the disabled "Allow inprocess" option : (from Microsoft SQL Server Management Studio, navigate to Linked Servers > Providers and Right click on MSDASQL). Please check whether this option is disabled in the provider settings of your server
MaximG
Devart Team
 
Posts: 745
Joined: Mon 06 Jul 2015 11:34


Return to ODBC Drivers