Not exactly sure why this is the case, but I was receiving a 10004 error whenever I had more than one QODBC query during a page request.

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][QODBC] Error
SQLSTATE 42S00
SQL SELECT * FROM Customer
VENDORERRORCODE 10004
DATASOURCE qbs
Resources:

The ColdFusion Data Source Setup Instructions for configuring QODBC with ColdFusion states to “Make sure the Limit Connections and Maintain Connections are unchecked.”

Not sure if this will cause a problems down the line but I checked “Maintain Connections” option, and everything works just fine.

Current Setup
ColdFusion 8,0,0,171647 (Scorpio RC1)
QuickBooks Enterprise Version 7
QODBC Version 7.0.0.214 (Trial Version)

This entry was posted on Tuesday, July 17th, 2007 at 11:11 am and is filed under ColdFusion, QODBC, QuickBooks. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.