[QODBC-Desktop] Troubleshooting - Multiple tables exist error in the Linked Server
Posted by Jack - QODBC Support on 16 December 2014 10:24 AM

Troubleshooting - Multiple tables exist error in the Linked Server

Problem Description:

I am trying to run a query using an SQL Server database link to QuickBooks using QRemote. I can set up the linked server fine in SQL Server, and the connection has been tested to work. However, I try to run the query:

SELECT * FROM QRemote...InvoiceLine

The response is:

The OLE DB provider "MSDASQL" for linked server "QRemote" contains multiple tables that match the name "InvoiceLine."

I tried the select through QODBC Test Tool, which does not use the linked database. Please help as to where the issue might be.


You have not configured the MSDASQL property for the linked server.

The OLE DB provider options for managing linked queries can be set in SQL Server Management Studio.

In Object Explorer, right-click the provider name and select Properties for MSDASQL. The first six properties should be enabled. Please enable the first six properties.

For Multiple tables existing error, the "Level zero only" property should be set.   

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).