Saturday, January 5, 2019

Invalid Use of Schema Error on 32 Bit Microsoft SQL Server on 32 Bit Machine


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