Quickbooks Database servers

Posted on 2009-02-15
Last Modified: 2012-05-06
My accountant has a Windows SBS 2003 R2 server with Quickbooks Database running QB17, QB18, QB19 in Services. On all (8) workstations they are running Quickbooks 2002 thru 2009
Do I need all of the QB DB running or can I uninstall two of the three running or are the DB version specific?
Question by:warsawtech
    LVL 8

    Accepted Solution

    Found the below comment on which is an application the that supplies an ODBC driver for reading and writing QuickBooks  2009-2002 accounting data files by using standard SQL queries

    based on the comment below, it appears that Quickbooks has changed field names between various versions, so I am guessing that the answer is that you will need all those servers.

    The obvious thing to try is: during some off hours kill the services and see if the various versions still run.

    With only 8 workstations, I am guessing the server is not overloaded, and the multiple services are not a production/response time issue.

    Just a suggestion: If it ain't broke, don't fix it.

    Unified Naming Support
    Field names between different versions of QuickBooks across all different regions has been optimized in QODBC 9.0 so you can use common names across all versions and flavors of QuickBooks.

    Open in new window

    LVL 5

    Assisted Solution

    I am not sure it matters, try disabling one of the services and see if you can still access the data file for that year.

    LVL 2

    Author Closing Comment

    Thanks for the info. I did disable the QB17 and QB18 and left the QB19 running and they haven't seemed to have any problem opening all versions of QB. I asked this question because of issues with server being slow and unresponsive as the day progresses. I wanted to eliminate this as a possible issue before proceeding on to other areas.\ to look for problems Such as Drake Software. Going to open a new thread elsewhere.

    Thanks for the input

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
    I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video discusses moving either the default database or any database to a new volume.

    754 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

    19 Experts available now in Live!

    Get 1:1 Help Now