|
|
 |
 |
 |
|
QODBC Server Edition & Setup
Instructions
It's important for you to know first off that QODBC is not a
system that can talk directly to the QuickBooks data file like other ODBC
drivers. QuickBooks accounting rules must be respected in order to keep the
financial system in balance, so our driver communicates with the copy of the
QuickBooks program running on your machine (or via the remote connector) using the Intuit
qbXML SDK interface, which
is fully supported by Intuit and Quicken here in Australia.
QuickBooks must be running
with the company file opened on the
system console. The QODBC Server Edition includes DCOM servers required
to allow QODBC running as a system service to find the instance of
QuickBooks running on the server console.
There isn't much required to view live QuickBooks Data within your
Browser or through a Windows Service. You have two choices in setting up
QODBC. The first is
using the QODBC DCOM Servers. The second is using the Remote Connector
Option.
The DCOM Servers require QuickBooks to be running on the Server
Console, not a Terminal Services session. They are more secure and
require no extra overhead but are more rigid on how it is setup and it
can be difficult to configure the security of the DCOM servers.
The Remote Connector option allows the window that is running
QuickBooks to be anywhere that is accessible via TCP/IP. That means
QuickBooks can be run in a Terminal Sessions window, on another
computer on your LAN or anywhere on the WEB. If your data will be
transmitted over the internet we recommend you upgrading the Remote
Connector to the SSL secure version. The instructions on setting up
the Remote Connector version are found in
Using QODBC Remote.
Our Server Edition of QODBC will allow you to use any web tool you wish to
use (ASP, ADO, ColdFusion) or Windows Service to access data live from QuickBooks without
conversion.
The Server Edition is a separate product from the normal desktop editions
of QODBC. The reason for this is twofold:-
 |
Firstly, as a licensing issue, we must
allow for use by potentially hundreds of logins to the machine
remotely using the web. |
|
Secondly, QuickBooks does not run as a
system service (background task) which is what IIS Web Server Software
runs as, so we have developed special software to allow us to
communicate with QuickBooks running on the desktop. |
You cannot upgrade to the Server Edition from
the Desktop Edition, so it's important to determine your requirements
before purchasing the QODBC Desktop Edition. QODBC supports Australian, New Zealand and Singapore editions of QuickBooks
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003 Pro, Premier, Accountant and Enterprise.
QODBC doesn't work with QuickBooks EasyStart, Accounting
(formally known as Lite), Plus or Small Business Editions.
When you install QODBC it automatically
activates a
FREE 30 Day QODBC Server Edition Evaluation... so there's nothing to
stop you from putting QODBC to work today!
After 30 Days you will need to purchase a
Desktop or Server
Edition CD Key.
See our link on "How
to Install QODBC?" for step by step details on how to
download and setup QODBC.
QODBC Basic Setup For Using the DCOM Servers
Method
You must turn on use of the DCOM servers. You do this by running the
QODBC Setup Screen and selecting the "Advanced" tabpage. Check the
checkbox for "Use DCOM Servers".
If you're working with the QuickBooks sample company
file, this option is available to check even if you do not have a Server
Edition license and will be ignored if you open a standard company file
and do not have a QODBC Server Edition or evaluation.
Internet Information Server (IIS) Basic Setup
Ensure the following are
installed and registered on your web server or even your notebook running
Windows XP Pro :-
| Microsoft Internet Information
Server (IIS5 or later) |
| Uncheck the "Allow IIS to control password"
setting for Anonymous access in IIS as shown here and set your own
password. |
Automatic DCOM Configuration
Click here:
qodbcSetDCOM.zip to download the
following automated tools:-
| Dcpinst.exe is an installation setup for the
automated DCOM configuration object. This needs to be run first and
only once. |
| QODBCSetDCOM.VBS is a VB script that uses
the installed configuration object to setup the DCOM Servers. It will
reset and automatically add all necessary security each time it is
run. The script can be edited if you need to change the Accounts it is
configuring. |
| The new settings will not take affect until the
DCOM servers (qbXMLRPeQODBCInteractive.exe and
qbXMLRP2eQODBCInteractive.exe) are removed from memory. Rebooting is
the simplest way to accomplish this, but running the Windows Task
Manager and Ending Process on any running copies will also work. |
| Test your DCOM
setup using one of the following:-
|
Sample Scripts
You can use the built-in "QuickBooks
Data" System DSN which points to the currently open QuickBooks company
file (.). The QuickBooks application can only access one file at a
time, so your web application will be limited to the single open
company file.
| Copy the sample ASP script (below)
or similar ASP page to your Web Site Directory. |
| Start QuickBooks on the console
desktop and open the QuickBooks Company file you wish to use.
|
| Access the Website using a browser.
Point to the Sample Customer ASP script on your server. You should get
a customer list.
|
Trouble Shooting
If you get a timeout error, or error 5
when trying to test the connection, follow these steps to narrow down
the problem:
|
Test the above "Basic ASP Test" first
and see if ASP scripting is allowed by your web server. If it does not
run, your security rights on your web server are preventing it. Make
sure the IUSR_<machine_name> user and ASPNET user have full rights to
read and run scripts in the folder where your test ASP scripts are
located. |
|
If everything appears correct but you
continue to get Create DCOM Instance Error 80070005 (probably due to
permission errors) you can reset the DCOM security registry
information. This is done by running the following commands at the
Start/Run menu:
"C:\Program Files\QODBC Driver for
QuickBooks\QBXMLRP2EQODBCInteractive.exe" /UnRegServer
"C:\Program Files\QODBC Driver for QuickBooks\QBXMLRPEQODBCInteractive.exe"
/UnRegServer
"C:\Program Files\QODBC Driver for
QuickBooks\QBXMLRP2EQODBCInteractive.exe" /RegServer
"C:\Program Files\QODBC Driver for QuickBooks\QBXMLRPEQODBCInteractive.exe"
/RegServer
Then follow the steps above to add rights to the DCOM servers using
DCOMCnfg. |
| Make sure you setup a System DSN, not a file or
user DSN for this configuration. |
| Test the above "QODBC Driver basic table list test"
first, this ASP script only verifies that IIS can talk to QODBC and
that the installation and security is proper. If this one works, test
the "QuickBooks Customer List" script. |
| Check the security on the ASP scripts by right
clicking them and choosing the security tab, allow inherited
permissions from parent. |
| If you get stuck, try rebooting the server or
stopping and starting the web site, then load QuickBooks, then test
web page. |
| Give read and execute rights to IUSR_<machine_name>
and ASPNET to the following files c\winnt\system32\fqqbc32.exe, c\winnt\system32\fqqb32.dll,
c\winnt\odbc.ini, and c\winnt\odbcinst.ini |
| Try assigning Administrator rights to the IUSR_<machine_name>
and ASPNET user. If this fixes the problem, there is definitely a
problem with security rights and you know it can work, simply keep
adding security rights until it works. Do not leave the IUSR_<machine_name>
and ASPNET accounts as Administrator. That is very dangerous.
|
| If you are getting the message: "This version not
registered as a Internet Edition version - contact sales" or similar,
you either do not have an Server Edition of QODBC registration, or
you have an outdated version of QODBC. |
| Check the Application Event log for any messages if
you are having trouble with QODBC on the web, all error messages which
would normally create a message box on the desktop are sent to the
event log in the Server edition. |
| Turn on Detail Tracking (Slow) by running the
‘QODBC Setup Screen’ and pressing the Messages button and checking the
checkbox for ‘Detail Tracing (Slow)’. Run an ASP page in the browser
and return to ‘QODBC Setup Screen’ and press the ‘Review Trace Log’
button. |
| If simple programs like VBDEMO refuse to run, you
may have DLL's which are not registered. After starting QuickBooks and
testing and getting errors, check the file qbsdklog.txt (found in the
QuickBooks installation folder) for details on any errors and how to
resolve them. |
| If you are running QB2003 and are getting begin
session errors you can try switching to the QB2004 style requestor.
It’s installer can be downloaded at:
http://www.qodbc.com/docs/support/QBXMLRP2Installer.zip
|
So isn't it time
you unleashed the full power of QODBC Server Edition?
Like our FREE QODBC Basic Edition, you
can also try our OBLIGATION FREE 30 Day QODBC
Server Edition Evaluation to
see and write to QuickBooks Transaction Tables from a Web Server! Here are just some of
the exciting features of using QODBC Server Edition:-
| Access the Transaction Core of
QuickBooks Accounting Data such as Invoices, Bills, Purchase Orders,
Checks, Credit Memos, Estimates, Payments, Sales, Employee Time
Tracking. Over 80 tables in all!* |
| Generate Powerful QuickBooks Reports
in your own applications such as Details on AR & AP, Aging Reports,
Balance Sheet, Collections, Transaction Detail, 1099 Detail, Customer
Balance Detail, Estimates, Expenses, General Ledger, Income Detail,
Tax Detail, Inventory Detail, Item Profitability, Inventory Status &
Valuation, Job Profitability, Open Invoices, Profit and Loss, Open
PO's Sales by Customer, Sales Tax, Time by Job Trial Balance, Vendor
Balance Detail & Summary. Over 75 reports total!*
Read more  |
| Get 30 days of telephone
installation support. |
| Get Discounts on future upgrades to
QODBC and our other exciting products. |
| Generate your own income by creating
Web applications using the QODBC Server Edition!
|
To activate the
OBLIGATION FREE
30 Day QODBC Server Edition Evaluation you need to have
downloaded and installed QODBC and clicked on the "QODBC Setup Screen"
shortcut in the "QODBC Driver for QuickBooks" program group on your destop.
QODBC supports Australian, New Zealand and Singapore
editions of QuickBooks
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003 Pro, Premier, Accountant and
Enterprise. QODBC doesn't work with QuickBooks EasyStart, Accounting
(formally known as Lite), Plus or Small Business Editions.
 Because of the
limitations of the SDK release used in the Australian/New
Zealand/Singapore edition of QuickBooks, QODBC cannot be used under the
Microsoft Vista operating system unless you are using QuickBooks 2008/09.
QODBC Pricing:
|
Description |
Price |
|
QODBC Desktop Edition for QuickBooks
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003
Australian Edition Read Only |
A$328.90 |
|
QODBC Desktop Edition for QuickBooks
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003
Australian Edition Read Write |
A$438.90 |
|
QODBC Server Edition for QuickBooks
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003
Australian Edition Read
Write |
A$1,098.90 |
|
QODBC
Desktop Edition for QuickBooks
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003
New Zealand,
Singapore or
SE Asia Edition Read Only |
A$299.00 |
|
QODBC
Desktop Edition for QuickBooks
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003
New Zealand,
Singapore or
SE Asia Edition Read Write |
A$399.00 |
|
QODBC
Server Edition for QuickBooks
2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003
New Zealand,
Singapore or
SE Asia Edition
Read Write |
A$999.00 |
Data Access
Worldwide Support Solutions
We offer a variety of
technical support solutions in order to give our customers a wide range
of choices to determine how we may best help them meet their support
needs.
Our FREE QDeveloper Forum
Our FREE forum is dedicated to the professional exchange of information
where QODBC & FlexODBC users can post support queries, report product
bugs, search the FAQs and much more. To visit the forum click
here.
Buy Support Incidents
If you can't find your answer in the FREE Public QDeveloper Forum,
require URGENT Priority Support, or you need to send us private or
confidential information, purchase one of our Support Incidents by
clicking
here.
Callback Support
If you live in the USA, UK, Canada, Australia or New Zealand, you can
leave us your contact details with your question and request us to call
you back and discuss them with you personally (charges apply).
Pre-Paid Phone Support
Pre-Paid Phone Support time must be purchased from our website prior to
placing a support call. Telephone support is the fastest way to speed up
problem diagnoses and resolution or simply receive an experienced
perspective on your particular issue. Telephone support is billed at the
rate of A$33.00 per 20 minutes for one question or issue ("incident").
After you have purchased support time, you will be advised of the
priority support number to call to speak to a technical support person
or to make an appointment. While there are times the technical support
team will be available for immediate help, they may have other calls to
handle before scheduling your time. We will attempt to close all calls
the day of your call.
Q:
What is ODBC?
A: ODBC (Open DataBase Connectivity)
is a specification designed by Microsoft to allow Windows applications
to access multiple database systems through a single method with no
regard for various file formats. SQL (Structured Query Language) is used
as the method for accessing data through ODBC. Vendors of ODBC drivers
(like this one) follow the specifications for ODBC so that any ODBC
compliant application can access the data available through the driver.
Q: What is QODBC?
A: QODBC is an ODBC driver (DLL) for
QuickBooks Accounting format files. QuickBooks Accounting stores it's
data in it's own proprietary DBMS file format. This driver allows users
of any ODBC compliant front-end application to read and write data
contained in QuickBooks Accounting format files similarly to any other
ODBC enabled database.
Q: What can I do with QODBC?
A: QODBC opens up the QuickBooks
Accounting files created by thousands of custom programs to the new
world of database connectivity. Microsoft Access or Visual Basic can be
used to merge QuickBooks Accounting data with other data sources to
produce complex reports, or to run mass file updates based on multiple
criteria.
Q: What kind of learning curve is there for
QODBC?
A: After quick installation of the
driver, no training is required! This driver is transparent, requires no
learning curve and works in exactly the same fashion of other ODBC
drivers. Users of ODBC compliant front-end applications do not
necessarily need to learn SQL language to access the QuickBooks database
files. Many of these ODBC compliant applications simply present wizards
enabling the user to create queries against the database.
|
|
|
Telephone Support |
|
One-to-One support issues will be subject to a A$33.00 per incident fee. Make sure you have the Serial Number of your purchased product and call 03 9761 3644 or +61 3 9761 3644 during our normal office business hours between 9am to 5pm week days Australian EST (with the exception of Public Holidays). |
|
 |
|
Support Incidents |
|
Evaluation and non-installation support issues are subject to a A$33.00 per incident fee. Payments for Support Incidents may be made by clicking here |
|
|
|
 |
Copyright ©
2008
Data Access Worldwide ABN: 86 544 223 459
All rights reserved |
|
|
|
|
