[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
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:
You have not configured the MSDASQL property for the linked server.
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.