QODBC and SharePoint

Environment Description

     QuickBooks Enterprise 2017

     Microsoft SharePoint 2006 / SharePoint 2016 / SharePoint Foundation / SharePoint Office 365

Instructions

     The use of SharePoint Services requires the full QODBC Server Edition. The bundled QODBC Enterprise Edition cannot be used with Windows Services. We don't provide direct support for Microsoft SharePoint 2006 / SharePoint 2016 / SharePoint Foundation / SharePoint Office 365 because it's a Microsoft product. For further information, please see the link below:

Add a database as a data source

     SharePoint 2006 / SharePoint 2016 / SharePoint Foundation / SharePoint Office 365 seems to support ODBC, try this QRemote connection string:

"Driver={QRemote for QuickBooks};OLE DB Services=-2;IPAddress=127.0.0.1;Port=4500;RemoteDSN=QuickBooks Data;"

Note: You will need to set up the  QRemote / QODBC DCOMs and unattended mode access. 

If you want to use Dcom, please use the connection string below.

"Driver={QODBC Driver for QuickBooks};DFQ=C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions 14.0\sample_service-based business.qbw;OpenMode=M;OLE DB Services=-2;"

Note: DCom component is deprecated. As an alternative to DCom, you can use QRemote.

See also:

Using QuickBooks data remotely via QODBC

How to setup QODBC DCOM Server

How to setup QODBC for Auto-login into QuickBooks