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 "Server Edition" tab page. 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.

	A supported version of QuickBooks 2006/07, 2005/06, 2004 and 2003 installed with your company file open (set the company file to Multiuser Mode)
	The QODBC Driver for QuickBooks installed and running in Server Edition mode (either as a 30 Day Server Evaluation or as a fully registered copy).
	You must create a system DSN, by default the DSN "QuickBooks Data" is created for you when QODBC is installed, but you can use any system DSN created for QODBC.
	If running ASPNET, make sure the .NET framework is loaded and patched to the current release level. Also verify that MDAC 2.6 or greater is installed.
	Give read and write rights to the QuickBooks application folder (normally C:\Program Files\QODBC Driver for QuickBooks\) to the Anonymous web user IUSR_, ASPNET user and INTERACTIVE. This allows for creation and update of QODBC trace and message logs and allows access to the DCOM server executables. To get access to the security tab (assuming you have an NTFS partition) do the following:- In Windows Explorer go to "Tools | Folder Options..." Select the "View" tab In the list with "Advanced Settings", de-select "Use simple file sharing (Recommended)" Select "Ok" Now you can give IUSR_ all rights to the C:\Program Files\QODBC Driver for QuickBooks\ using the Security tab.

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:- IIS users download: TestDCOM.ASP PHP users download: TestDCOM.PHP Cold Fusion users download: TestDCOM.CFM

Setting up "Auto-Login" Unattended Mode
Locate the "QODBC Driver for QuickBooks" program group on your desktop. Click on the "QODBC Setup Screen" icon to launch the setup program supplied with QODBC.

The following general setup screen will become available. Check the Locate a company file: option. This allows you to setup the full path to where your QuickBooks data file resides. For example: “C:\Program Files\Intuit\QuickBooks Pro\Myapp.qbw”.

The [Browse] button will let you choose your QuickBooks company file from the folder it is in.

To use the QODBC auto-login unattended mode you must specifiy the full path of the QuickBooks company file you wish to connect to.

The Advanced tab in QODBC Setup v6 Build 148 and later now has new defaults for Integrated Application Defaults Authorization popup settings. These settings are only available to USA QuickBooks 2005 and USA QuickBooks 2006 users, otherwise they are greyed out. Use these settings to allow "auto-login" with or without a visible QuickBooks User Interface.

You will also have to authorize QODBC to login to QuickBooks automatically. To do this you must start QuickBooks as the Administrator. Go to the "Edit-Preferences" menu item in QuickBooks. Then select the "Integrated Applications" icon from the left side.

Sample File: qbcust.asp
Now you're ready to try using QODBC within your browser, but first you will need a webpage to test! Download the following example by clicking here: qbcust.zip. Open the zip file and extract qbcust.asp. Save the file on your Local Disk in the \Inetpub\wwwroot folder as shown here:

Launch your browser (making sure QuickBooks is currently running on your computer with your company file open) and run the example by entering the following URL in your browser :-

http://localhost/qbcust.asp

The following should be displayed on your browser (with your data) :-

Further examples of how to create invoices, purchase orders, payments, credits etc. can by found directly on our QODBC Sample SQL Scripts webpage.

QODBC also supports the printing of all the QuickBooks Reports through the ODBC Interface, see our webpage on Data Schema REPORT DETAILS for all the sp_reports (stored procedure reports) that may be accessed including information about the columns and the parameters for each report. Read more

According to the article below there are two methods of getting qb data to show in an internet explorer window. The first method is to use the DCOM Server method and the second is to use the remote connector.

According to your pricing the DCOM Server license costs US$499. If I need to use the remote connector to get data to the websever then I need an additional US$499 just to show QB Data on a web page. Thats too much cost for a software product.

What are my other purchasing options? Can I purchase a read/write license for both computers at US$199 each and use the remote connector? I have turned off the DCOM Server check box in the qodbc settings and my remote web server still works fine using only the qodbc remote connector.

Finally, what are my options for OEM packaging. I read on your web site that you can offer discounted prices if the driver is only going to be used in a single application or packaged software. This is the case for my company. We will only redistribute qodbc for use with our web application.

As already stated, you have two choices in setting up a Web Server. The first is using the QODBC DCOM Servers (QODBC Server Edition). The second is using the Remote Connector Option (QODBC Desktop Edition). If you choose to use the Remote Connector Option, you don't require the Server Edtion, just a DeskTop Edition. Users who have compared both options have however reported that performance is slower using the Remote Connector.

For sales questions, please call the Sales office for your region directly:
USA: FLEXquarters.com LLC on: 800-932-6448 or +1 248-360-7842
Asia Pacific: Data Access Worldwide on: (03) 9761 3644 or +61 3 9761 3644
UK: Architectronic Ltd on: 0845 638 3730 or +44 (0)845 638 3730

A web application runs queries as multiple treads, and the QODBC optimizer is single user only. So you need to setup a different optimizer file for web applications to use than the other disktop applications. To do this, set up a seperate System DSN (see: How do I create or configure a QODBC DSN? ) and specify a fixed location of the optimizer database folder for IIS (Internet Information Server) to use (like: C:\Program Files\QODBC Driver for QuickBooks) instead of the default %UserProfile% method.

If your web application writes information into QuickBooks, you will need to use a different DSN/optimizer location for each instance of the web application or turn off the QODBC optimizer.