We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Quickbooks Database servers

Henry Starcher
on
Medium Priority
1,328 Views
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?
Comment
Watch Question

owner
CERTIFIED EXPERT
Commented:
Found the below comment on http://www.qodbc.com/qodbc.htm 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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
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.

Henry StarcherConsultant

Author

Commented:
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.