Knowledgebase: Tutorials
[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.

Solutions:

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. 

http://support.flexquarters.com/esupport/newimages/MultipleTables/step1.png

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. 

http://support.flexquarters.com/esupport/newimages/MultipleTables/step2.png

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

 
(0 vote(s))
Helpful
Not helpful

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