If I remove the 'InvoiceLineSeqNo' then it works fine. The odd part is that the statement works fine in VBDEMO. The error that is get is 'Driver Not Capable'. The statement worked fine until I upgraded to v7 of QODBC (v6 worked fine).

Any ideas? Thanks.

As you have already said, I can run:

SELECT TxnID, RefNumber, InvoiceLineSeqNo, InvoiceLineServiceDate,
InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineRate,
InvoiceLineAmount FROM InvoiceLine WHERE RefNumber IN ('10')

without a problem, so it's not the SQL statement. The only other "Driver not capable" error was caused using the REMOTE CONNECTOR with QODBC v7. The user changed their connection method to use the QODBC DCOMs instead and the error went away.

What happens if you call the QODBC Optimizer directly:-

daQODBC = New System.Data.Odbc.OdbcDataAdapter("SELECT TxnID, InvoiceLineSeqNo, InvoiceLineServiceDate, " & _
"InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineRate, InvoiceLineAmount " & _
"FROM InvoiceLine NOSYNC WHERE RefNumber IN ('2900')" , cnQODBC)

or if you get all the columns?:-

daQODBC = New System.Data.Odbc.OdbcDataAdapter("SELECT * FROM InvoiceLine NOSYNC WHERE RefNumber IN ('2900')" , cnQODBC)

Because you say you only have the problem when you use the InvoiceSeqNo, let's try typing it to an integer or try one of the other data types:

daQODBC = New System.Data.Odbc.OdbcDataAdapter("SELECT TxnID, {fn CONVERT(InvoiceLineSeqNo, SQL_INTEGER)} as LineNo, InvoiceLineServiceDate, " & _
"InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineRate, InvoiceLineAmount " & _
"FROM InvoiceLine NOSYNC WHERE RefNumber IN ('2900')" , cnQODBC)

CONVERT(value_exp, data_type) - The function returns the value specified by value_exp converted to the specified data_type, where data_type is one of the following keywords:

SQL_BIGINT, SQL_BINARY, SQL_BIT, SQL_CHAR, SQL_DATE, SQL_DECIMAL, SQL_DOUBLE, SQL_FLOAT, SQL_INTEGER, SQL_LONGVARBINARY, SQL_LONGVARCHAR, SQL_NUMERIC, SQL_REAL, SQL_SMALLINT, SQL_TIME, SQL_TIMESTAMP, SQL_TINYINT, SQL_TYPE_DATE, SQL_TYPE_TIME, SQL_TYPE_TIMESTAMP, SQL_VARBINARY, SQL_VARCHAR