Knowledgebase: QODBC
[QODBC-Desktop] How to use QODBC with Layer2 Cloud Connector Solution
Posted by Jack - QODBC Support on 07 March 2017 07:06 AM

How to use QODBC with Layer2 Cloud Connector Solution

This article shows how you can easily integrate the QODBC driver for QuickBooks into Layer2 Cloud Connector Solution.

1. Open Connection Manager by clicking on "Start Connection Manager".

 

Connection Manager opened.

 

2. Add new connection by right-click on "Connection Manager" & click on "Create New Connection".

 

3. Enter Connection Name & click on "Save Changes".

 

4. To connect to QuickBooks, the data entity must be configured as follows in the Layer2 Cloud Connector Connection Manager. Select "Odbc Data Provider" as a Data Provider & insert DSN=QuickBooks Data QRemote;OLE DB Services=-2; as a Connection String and click on "Verify Connection String".

 

Connection Verified.

 

Please Note: If you have a 64-bit application, then you need to use QRemote 64-bit DSN "QuickBooks Data 64-bit QRemote" as below screenshot.
Please refer: How to configure QRemote

5. Enter SQL Statement and click on "Verify Select Statement".

 

Select Statement Verified.

 

6. Enter Primary Key and click on "Verify Primary Key".

 

Primary Key Verified. Click on "Save Changes" to save connection property.

 

(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).