Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

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:
Click Here

Forum : Does QODBC work with Coldfusion?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Frequently Asked Questions

 New Topic 
 
 Post Reply 
[1]  
 Does QODBC work with Coldfusion? 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-02-22 10:17:42

Using ColdFusion, whether it's an internal Intranet or on the World Wide Web, requires the Server Edition of QODBC. 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.
 
You have two choices in setting up ColdFusion. 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.

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. Note: You may need to check the "Run 2.1 ODBC Compatibility" checkbox - Certain applications require ODBC 2.1 Compatibility to use QODBC. For example, anything that uses the Java ODBC library, like ColdFusion, requires this option turned on or recordsets will be returned with no rowsets or only 1 rowset.

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 :-

bullet Microsoft Internet Information Server (IIS5 or later)
bullet Uncheck the "Allow IIS to control password" setting for Anonymous access in IIS as shown here and set your own password.

bullet 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)
bullet 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).
bullet 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.
bullet 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.
bullet 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:-
bullet In Windows Explorer go to "Tools | Folder Options..."
bullet Select the "View" tab
bullet In the list with "Advanced Settings", de-select "Use simple file sharing (Recommended)"

bullet Select "Ok"
bullet 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:-

bullet Dcpinst.exe is an installation setup for the automated DCOM configuration object. This needs to be run first and only once.
bullet 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.
bullet The new settings will not take affect until the DCOM servers (qbXMLRPeInteractive.exe and qbXMLRP2eInteractive.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.
bullet Test your DCOM setup using one of the following:-
bullet IIS users download: TestDCOM.ASP
bullet PHP users download: TestDCOM.PHP
bullet Cold Fusion users download: TestDCOM.CFM

ColdFusion Data Source Setup Instructions
Run the ColdFusion Administrator. Under DATA & SERVICES choose Data Sources. Use "QBs" as the Data Source name if you want to match the DisplaySQL.cfm sample script below. The Driver is ODBC Socket. Press the Add button.

Under ODBC DSN choose a QuickBooks DSN. QuickBooks Data is a DSN that is created by the QODBC installation. Username should be set to Admin. You can put any notes you want in the description field.

Next Press the Show Advanced Settings Button.

Make sure the Limit Connections and Maintain Connections are unchecked. You can remove the check boxes on Create, Drop, Alter, Grant and Revoke. Add check boxes for Select, Insert, Update, Delete and Stored Procedures.

Press Submit and your QODBC Data Source should show on the list of Data Sources.

You can test your QODBC DCOM Setup by downloading: TestDCOM.CFM and also test QODBC with your new Macromedia ColdFusion ODBC Socket connection using the following sample script: DisplaySQL.CFM.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-01-23 09:43:44
DisplaySQL.cfm uses dataSource="QBs" which is the QuickBooks Data DSN. In order for this to work you must also configure the "QuickBooks Data" data source to auto-login to your company file as shown in: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running?  

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to