QuickBooks integration help

Posted on 2009-12-19
Last Modified: 2012-05-08
I am using a Filemaker plugin called FileBooks to integrate an FM6 database with QuickBooks. After the latest QuickBooks payroll upgrade, the application stopped working. When I try to open the QuickBooks company file via a plugin call, I receive an error 21 message. This might not be related, but if I attempt to open the QuickBooks company file from Windows Explorer, I get the following error message:
"Unexpected Internal Error "80040154"
This even happens with the QuickBooks sample company. The file opens normaly if opened from within QuickBooks.
I have tried re installing QuickBooks. I even tried a fresh installation of Quickbooks on a new computer. The same error occured :(
Question by:JohnFra
    LVL 89

    Expert Comment

    by:John Hurst
    The latest QuickBooks Payroll upgrade changed the QB file format. I got that message on every ledger that I upgraded. So there is probably something incompatible with the new format and your plugin. You probably need to contact Filemaker about this as they will have to update their application. ... Thinkpads_User
    LVL 9

    Expert Comment

    New version is available at The company was purchased by Productive computing in 2008

    Author Comment

    Unfortunately, FMBooks connector doesn't work with Filemaker version 6. The installation has Filemaker server with 10 users. It would be a very expensive upgrade to go to version 10.  
    LVL 9

    Expert Comment

    The current versions of Quickbooks are based on Sybase SQL and the ENterprise Version is on MSSQL. There are ODBC drivers from intersolv for sybase and MS Sql will connect directly to Filemaker.

    Maybe you are better off upgrading to Enterprise, but I don't know your situation.

    Through the Sybase ODBC connection you should be able to do anything you are doing with a plugin but it will probably require rewriting of the routines. I don't have any experience with the plugin but I have some with the Sybase ODBC driver.
    LVL 9

    Expert Comment

    Datadirect is the current developer for Sybase drivers for Filemaker

    Accepted Solution

    The file association was wrong. Files with a QBW file were opening as a QuickBooks library file. Changing the association to the QuickBooks program file fixed the problem.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Automate File Copy Tasks 8 72
    VCD to mp4 11 87
    FileType E9869 ? 6 36
    Recommend software for remote assistance 21 75
    Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
    Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
    Viewers will learn how to use the Hootsuite Dashboard.
    The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now