ODBC Driver for QuickBooks

Using in Microsoft SQL Server Management Studio (SSMS)



Requirements

In order to avoid incorrect integration with MS SSMS, the working environment must meet the following conditions:

Retrieving Data From QuickBooks

Disable the Allow inprocess option of MSDASQL OLE DB Provider for ODBC Drivers. For this, find the MSDASQL provider in the list of Linked Servers and double-click on it

msdasql

In the appeared Provider Options window, clear the Allow inprocess checkbox

allowinprocess

Create a new Linked Server

newlinkedserver

Make sure to select Microsoft OLE DB Provider for ODBC Drivers and specify the following parameters

provideroptions

The QuickBooks tables are already available to be fetched. To get the Account table data, click on the New Query button at the pivot

newquery

Edit the SQL query for your needs

accounttable

As a result, you can see the contents of the selected table retrieved directly from the QuickBooks account you are connected to.

Attention

If the Linked Server was created with the Allow inprocess option enabled, then you should delete this Linked Server and create it again with the Allow inprocess option disabled.

See also

© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback