I am testing the limits of QuickBooks, QODBC, & ColdFusion, so I am doing some bulk imports to see what (if anything) breaks or has poor performance.
In this particular case, I am trying to add 100000 customers to the database
<cfloop index=”i” from=”1″ to=”100000″>
<cfquery datasource=”qbs” name=”ds” >
INSERT INTO Customer ( Name)
VALUES (’#CreateUUID()#’)
</cfquery>
</cfloop>
When running the script, it [...]

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 [...]