For users who are using 32bit Microsoft SQL Server 2008 on a 32 bit machine, this error message might be encountered when executing an SQL command: Invalid use of schema or catalog for OLE DB provider "MSDASQL" for the linked server "NetSuite". (NetSuite being the user defined linked server)
As an alternate solution, do not indicate the company name and default role. Instead of using
SELECT * FROM NetSuite.[Company E].Administrator.Accounts
use
SELECT * FROM NetSuite...Accounts
No comments:
Post a Comment