Knowledgebase
[QODBC-Desktop] How to trace the XML in QODBC
Posted by Rajendra Dewani (QODBC Support) on 14 April 2014 03:54 PM

Problem Description:

How can I trace the XML sent to/from QuickBooks by QODBC?

Solution:

You can trace XML by the below steps:

1) Turn on Detail Trace from: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source

Go To the "System DSN" Tab, Select "QuickBooks Data" DSN & click "Configure."

Navigate to the "Message" Tab & enable the "Detail Tracing (Slow)" option.

2) Switch to the "Advanced" tab & Select "Add XML to Detail Trace Log."

3) Apply the changes. Close all the applications. ( If any of the application is already connected, QODBC will not start logging )  Connect again after Querying, close the connection and refer to the logs. 

Troubleshooting:

I am trying to add a new Line in ODBCINST.ini file TracewithXML=Yes. It is giving me the message "Access is denied."

To resolve this issue, copy the "ODBCINST.ini" file to another place and then add a new line you want to add. Restore the "ini" file in the same place.

You cannot edit any file under the Windows folder.

I am also using your link "How to Locate Log Files of QODBC for Troubleshooting," but it is still showing me this message when I click on the Review QODBC Messages button it is giving me this message QODBCLOG.txt is Empty.

QODBCLOG.TXT is Empty, as your application is running perfectly. It doesn't contain any errors.

Still, if you want to check again, restart your connected applications and QuickBooks company file.

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