Baystate Consulting Homepage
Forum Home Forum Home > FAQ - (Frequently Asked Questions ) > FAQ: Transaction Pro Importer for QuickBooks
  New Posts New Posts RSS Feed - Trouble connecting to the QuickBooks file
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedTrouble connecting to the QuickBooks file

 Post Reply Post Reply
Author
Message
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2710
Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Topic: Trouble connecting to the QuickBooks file
    Posted: 14 September 2006 at 11:06am
When Transaction Pro Importer/Exporter/Deleter attempts to connect to a QuickBooks company file you get one of the following error messages:

Error: "Please start QB and open your company file before continuing        
Error: “Automation error The object invoked has disconnected from its clients.” 

Error: “This application has not accessed this QuickBooks company data file before. The QuickBooks administrator must grant an application permission to access a QuickBooks company data file for the first time.”
 

Error: “QuickBooks found an error when parsing the provided XML text stream”
 
Please follow these steps to troubleshoot this issue:

1.   Ensure that you have QuickBooks installed, your company file is open, and we recommend that you login to QuickBooks as the Administrator.
2.   When prompted by QuickBooks give Transaction Pro permission to access the QuickBooks company file whenever it is open ("Yes, whenever this company file is open")
3.   Check that you meet the minimum systems requirements to use Transaction Pro Importer/Exporter System Requirements.
 
Error: "Please start QB and open your company file before continuing"

1. If you are using Microsoft Vista or 7, please ensure that you have User Account Control  (UAC) set to On or Always Notify, and check that Transaction Pro Importer/Exporter is logged into the QuickBooks file at the Admin permission level.
 
2. Ensure that both QuickBooks and Transaction Pro are not being started with the shortcut security tab option "Run as Administrator. The QBSDK requires non elevated Windows permissions for both products and this box must not be checked.
 
3. If you are using QuickBooks 2011/2012 be sure that the Quick Startup feature is disabled. Applications that use the QBSDK cannot be used when this feature is enabled. To disable this feature, in QuickBooks click Edit/Preferences, select the General Preferences tab and uncheck the box labeled Keep QuickBooks running for quick startups.
 
-- ONLY IF STEPS 1-3 HAVE FAILED SHOULD YOU CONTINUE WITH STEPS 4 & 5 BELOW ---
 
4. Run Reboot.bat to rebuild the QuickBooks Interface Files. Open Windows Explorer and navigate to c:\Program Files\Intuit\ (or c:\Program Files (x86)\Intuit\ if using a 64 bit machine) and then look for the version of QuickBooks are are running. Example the folder would be QuickBooks 2011 if you are running this version. Open the folder and locate the file Reboot.batRight click on the file and choose Run as Administrator. Reboot your machine, restart QuickBooks and Transaction Pro.
 
5. If still unable to connect, try reinstalling the QuickBooks interface files. Download, unzip and run the QuickBooks Interface Installer here. This installs the files required for 3rd party applications like Transaction Pro to communicate with QuickBooks. After installation, reboot your machine, restart QuickBooks and Transaction Pro. 
 
Error: “Automation error The object invoked has disconnected from its clients.”
 
You need to change your (Data Execution Prevention) DEP settings in Windows Server, Vista or 7.
1.      Go to System Properties
2.      Select Advanced Tab
3.      Click Performance Settings button
4.      Select the Data Execution Prevention tab 
5.      Select the first option “Turn on DEP for essential Windows programs and services only”.
Or Select the second option and adding the Transaction Pro Importer file by clicking Add then selecting the file C:\Program Files\01 Transaction Pro Importer 4.0\Transaction Pro Importer 4.0.exe
 
Error: “This application has not accessed this QuickBooks company data file before. The QuickBooks administrator must grant an application permission to access a QuickBooks company data file for the first time.”
 
You need to have the QuickBooks Admin user login to the company file. QuickBooks integrated applications (such as TPI) need the Admin user to grant permission to the company file the first time the utility is run. This allows the program to have the correct permissions to read and write transactional data to the QuickBooks data file.
 
1. Go to your QB file (logged in as the admin user in single user mode)
2. Click Edit/Preferences - Select Integrated Application
3. Click the Company Preferences tab
4. Remove the application named "Baystate Consulting" (if present)
5. Click OK
6. Restart Transaction Pro (be sure the QB admin is still logged into the company file as they need to give permission to the company before the user can subsequently login). A popup window will appear in QuickBooks asking to allow this application to access this company file. Make sure you choose "Yes, whenever this company file is open". If you are using QB in a multi-user environment, select the Admin user as the user that TPI uses to connect to QB.
 
Error: “QuickBooks found an error when parsing the provided XML text stream”
 
First make sure you meet the system requirements here. The first step is to reinstall the version of QuickBooks you are running. In most cases this resolves the issue. Note that if you are running US and non US versions of QuickBooks on the same machine this will also cause this issue. It is not possible to run both US and non US versions on the same machine. The same is true for attempting to run older versions of UK/CA/AU with current versions. If you continue to receive this error after reinstalling QuickBooks then you may have a damaged QBSDK on the machine. Follow these steps to repair this issue.
 
1.      Uninstall all QB versions from this machine.
2.      Delete the following folder: C:\program files\common files\Intuit\QuickBooks
   (Note you may need to first stop the process QBW32.exe and qbUpdate.exe and
   QBCFMonitorService.exe via Windows Task Manager)
2.      Reboot
3.      Re-install QuickBooks
4.      Re-install Transaction Pro
 
 
Determining if the issue is a corrupt QuickBooks interface or Transaction Pro
 
1. Download, install and run the SDK Diagnoses Tool to determine if the problem is QuickBooks or a Transaction Pro issue.

2. If you are unable to connect with the SDK Diagnosis Tool then it may be because your QuickBooks interface files may have been overwritten or corrupted. Please follow the instructions under Error: “QuickBooks found an error when parsing the provided XML text stream” clean up your installation.

Error:   Line: 123 An internal QuickBooks error occurred while trying to access the QuickBooks company data file

This means that Transaction Pro cannot access your QuickBooks company file.  Start at the very top of the article and work through each section until you are able to start Transaction Pro without error.  If you recently upgraded your QuickBooks version you can also try running a rebuild of the QuickBooks company file.

 
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10.16
Copyright ©2001-2013 Web Wiz Ltd.