Knowledgebase: Setup
[QODBC-Desktop] Troubleshooting - How to access QuickBooks Data using FileMaker
Posted by Jack - QODBC Support on 16 December 2014 10:00 AM

Troubleshooting - How to access QuickBooks Data using FileMaker

Problem Description:

I downloaded the trial version of your driver this morning and am excited about the prospects. I've installed it and can get the fields and tables to appear in QODBC Test Tool, but I cannot connect using Filemaker Pro. 

Solutions:

Please follow the below-mentioned steps for FileMaker connectivity using QODBC.

1) Open FileMaker Pro & click on the Browse button.

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

2) Please select the ODBC data source.

 http://support.flexquarters.com/esupport/newimages/FileMaker/step3.png

3) Please select the ODBC data source "QuickBooks Data" & click on the "Continue" button.

http://support.flexquarters.com/esupport/newimages/FileMaker/step3.png

For FileMaker 64-Bit, please select "QuickBooks Data 64-Bit QRemote."


4) Please enter the username & password for the ODBC data source. If you have not defined any username & password, then click on the "OK" button.  

 http://support.flexquarters.com/esupport/newimages/FileMaker/step4.png

5) Select tables & columns that you want to use, then please click on the "Insert into SQL Query" & "Execute" buttons.

http://support.flexquarters.com/esupport/newimages/FileMaker/step5.png


6) Save results & you can see results.


http://support.flexquarters.com/esupport/newimages/FileMaker/step6.png

http://support.flexquarters.com/esupport/newimages/FileMaker/step7.png

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