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

Troubleshooting - Multiple tables exist error in 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, we 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 try the select through VB Demo and it works fine not using the linked database. Please help as to where the issue might be.

Solutions:

You have not configured MSDASQL property for 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. First six properties should be enabled, please enable first six properties. 

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

For Multiple tables exist error, "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).