Hey, I'm trying to run an UPDATE query on ItemInventory table, but even if I only try to update the Name, it throws this error...

Data source QBs verification failed.

The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][QODBC] Driver not capable

The Query:
<cfquery name="UpdateItem" datasource="QBs">
   UPDATE ItemInventory
   SET Name = "TestName"
   WHERE      ListID = '172-blahblah-000'
</cfquery>

I'm using:
ColdFusion MX 7
QODBC 7.0.00.199 Web Server Edition (not trial)
QuickBooks Enterprise 6.0

Thanks,
Marty

What is the actual error in the Review QODBC Messages log at the bottom of the QODBCLOG.TXT file in the QODBC Setup Screen?

See also: Does QODBC work with Coldfusion? 

Hello, thanks for the quick response,

MY SOLUTION: I restarted Quickbooks and this "Driver not capable" error went away.

NOTES: I cannot read the log file.  I get this message every time... File: QODBCLOG.TXT is empty

Thanks - Marty

That's good news. Since your last post I found a bug when doing UPDATEs using QODBC v7.00.00.194, so please update to v7.00.00.199 if you haven't already done so.

The log file only contains errors from SQL statements and it looks like you didn't get that far because the connection failed.

Hello,

SYMPTOM: Data source QBs verification failed.  The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][QODBC] Driver not capable.

I thought that by restarting QuickBooks and/or the QODBC Remote Connector had fixed this issue, but yesterday's temporary fix was just a fluke.

This error occurs any time I try to use an UPDATE statement using the QODBC Remote Connector with ColdFusion MX 7.  SELECT and INSERT INTO statements work just fine.  Also, using the VB Demo, ALL statements work just fine (UPDATE, SELECT, and INSERT INTO), so I know it's just when trying to UPDATE through the Remote Connector.

I have tried uninstalling and reinstalling the QODBC driver, but that didn't work either.  I've noticed this "Driver not capable" error on other forums with regards to connecting to Oracle and Sybase databases and other ODBC database connections - thought this might help when troubleshooting this issue.

Thanks,
Marty

It turns out that simple INSERT INTO statements do not work either.  Running the following query produced the same error...

<cfquery name="insertMainCategory" datasource="QBs">
       INSERT INTO Account ( Name, AccountType )
       VALUES ( 'TEST', 'Income' )
</cfquery>

However, this INSERT INTO statement worked just fine using the VB Demo program...

INSERT INTO Account ( Name, AccountType )
VALUES ( 'TEST', 'Income' )

Thanks,
Marty

The error, "Driver not capable" is not a QODBC Error. You will need to contact the Macromedia - ColdFusion Support Center directly at: http://www.adobe.com/support/coldfusion/ for further clarification.

It seems to suggest the error can also be caused by specifying a password when you don't need one or using an incorrect password.

Ya, that seems right. 

To narrow it down for everyone reading, we have an error-reporting issue with using ColdFusion MX 7 and the QODBC Remote Connector -- Data source QBs verification failed.  The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][QODBC] Driver not capable. --

At this point, we have moved over to the DCOM Server way of connecting ColdFusion to QuickBooks using the QODBC Driver Web Server Edition.  The DCOM approach is working flawlessly without errors popping up for INSERT INTO and UPDATE queries.  This is a workaround for now until we can find out why ColdFusion has issues with the QODBC Remote Connector (IBiz Integrator for QuickBooks, a program by nsoftware, is more precisely what the issue is with between ColdFusion).  We'll get ColdFusion MX 7 working with QuickBooks using the QODBC Remote Connector and report our findings here.

Thanks,
Marty