Troubleshooting - Getting error A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

[QODBC-ALL] Troubleshooting - Getting error A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

Troubleshooting - Getting error A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. Problem Description: I am using QODBC to fetch QuickBooks Data in SQL Server. I have created Linked Server in SQL Server. We are receiving the following error when trying to fetch data. The SQL is: SELECT * FROM [QREMOTE].[QODBC]..[Company] The error is: Msg 7399, Level 16, State 1, Line 4 The OLE DB provider "MSDASQL" for linked server "QREMOTE" reported an error. The provider did not give any information about the error. Msg 7312, Level 16, State 1, Line 4 Invalid use of schema or catalog for OLE DB provider "MSDASQL" for linked server "QREMOTE". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. Solution: You have used wrong SQL statement. You need to use LinkedServerName & table name in the query. For Example: Select * from YourLinkedServerName...TableName SELECT * FROM [QREMOTE]...[Company]

(0 vote(s))  Helpful  Not helpful