We recently migrated from ASE 11 (HP-UX) to ASE 12 (NT). My legacy
application uses VB with many data controls bound to queries. Ordinarily I
would not pester this group with a problem that appears to be related to a
VB data control, but this case seems to involve the execution of the query,
not the construction of the query (its valid) or any of the client side
code. I am getting a "function sequence error" when I set the recordsource
of the control to a simple "select * from wk_classif_rationale_desc "

If I set the recordsource to select from a different table it works ok
(indicating that my connection at that point is still valid)...but any
queries against wk_classif_rationale_desc cause a function sequence error
when I refresh the data control.

The database admin tells me that there are no errors on his end and that the
table is fine.

I guess my primary question is .... what the heck is a function sequence
error?

I've appended an ODBC trace to the end of this msg, I hope that isn't
overkill.

Regards,

Gary H.

=================================================================
SQLColumns(hstmt9C9F0000, "(null)", -3, "(null)", 0,
"wk\_classif\_rationale\_desc", -3, "(null)", -3);
SQLColumns(hstmt9C9F0000, "(null)", -3, "(null)", 0,
"wk\_classif\_rationale\_desc", -3, "(null)", -3);
SQLNumResultCols(hstmt9C9F0000, pccol);
SQLFetch(hstmt9C9F0000);
SQLGetData(hstmt9C9F0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 4, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9C9F0000, 5, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 7, 99, rgbValue, 4, pcbValue);
SQLGetData(hstmt9C9F0000, 9, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 11, 99, rgbValue, 2, pcbValue);
SQLFetch(hstmt9C9F0000);
SQLGetData(hstmt9C9F0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 4, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9C9F0000, 5, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 7, 99, rgbValue, 4, pcbValue);
SQLGetData(hstmt9C9F0000, 9, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 11, 99, rgbValue, 2, pcbValue);
SQLFetch(hstmt9C9F0000);
SQLGetData(hstmt9C9F0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 4, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9C9F0000, 5, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 7, 99, rgbValue, 4, pcbValue);
SQLGetData(hstmt9C9F0000, 9, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 11, 99, rgbValue, 2, pcbValue);
SQLFetch(hstmt9C9F0000);
SQLGetData(hstmt9C9F0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 4, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9C9F0000, 5, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 7, 99, rgbValue, 4, pcbValue);
SQLGetData(hstmt9C9F0000, 9, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 11, 99, rgbValue, 2, pcbValue);
SQLFetch(hstmt9C9F0000);
SQLGetData(hstmt9C9F0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 4, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9C9F0000, 5, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 7, 99, rgbValue, 4, pcbValue);
SQLGetData(hstmt9C9F0000, 9, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 11, 99, rgbValue, 2, pcbValue);
SQLFetch(hstmt9C9F0000);
SQLGetData(hstmt9C9F0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 4, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9C9F0000, 5, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 7, 99, rgbValue, 4, pcbValue);
SQLGetData(hstmt9C9F0000, 9, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 11, 99, rgbValue, 2, pcbValue);
SQLFetch(hstmt9C9F0000);
SQLGetData(hstmt9C9F0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 4, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9C9F0000, 5, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 7, 99, rgbValue, 4, pcbValue);
SQLGetData(hstmt9C9F0000, 9, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 11, 99, rgbValue, 2, pcbValue);
SQLFetch(hstmt9C9F0000);
SQLGetData(hstmt9C9F0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9C9F0000, 4, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9C9F0000, 5, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 7, 99, rgbValue, 4, pcbValue);
SQLGetData(hstmt9C9F0000, 9, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9C9F0000, 11, 99, rgbValue, 2, pcbValue);
SQLFetch(hstmt9C9F0000);
SQLFreeStmt(hstmt9C9F0000, 0);
SQLFreeStmt(hstmt9C9F0000, 1);
SQLGetInfo(hdbcAEAF0000, 50, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 49, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 52, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 51, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 48, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 65, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 61, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 60, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 58, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 67, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 70, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 38, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 27, rgbInfoValue, 8, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 22, rgbInfoValue, 2, pcbInfoValue);
SQLAllocStmt(hdbcAEAF0000, phstmt9BEF0000);
SQLGetStmtOption(hstmt9BEF0000, 0, pvParam);
SQLSetStmtOption(hstmt9BEF0000, 0, 0000003C);
SQLGetStmtOption(hstmt9BEF0000, 4, pvParam);
SQLSetStmtOption(hstmt9BEF0000, 4, 00000001);
SQLGetTypeInfo(hstmt9BEF0000, 1);
SQLGetTypeInfo(hstmt9BEF0000, 1);
SQLFetch(hstmt9BEF0000);
SQLNumResultCols(hstmt9BEF0000, pccol);
SQLGetData(hstmt9BEF0000, 9, 99, rgbValue, 2, pcbValue);
SQLFreeStmt(hstmt9BEF0000, 0);
SQLGetTypeInfo(hstmt9BEF0000, 12);
SQLGetTypeInfo(hstmt9BEF0000, 12);
SQLFetch(hstmt9BEF0000);
SQLNumResultCols(hstmt9BEF0000, pccol);
SQLGetData(hstmt9BEF0000, 9, 99, rgbValue, 2, pcbValue);
SQLFreeStmt(hstmt9BEF0000, 0);
SQLGetTypeInfo(hstmt9BEF0000, -1);
SQLGetTypeInfo(hstmt9BEF0000, -1);
SQLFetch(hstmt9BEF0000);
SQLNumResultCols(hstmt9BEF0000, pccol);
SQLGetData(hstmt9BEF0000, 9, 99, rgbValue, 2, pcbValue);
SQLFreeStmt(hstmt9BEF0000, 0);
SQLFreeStmt(hstmt9BEF0000, 1);
SQLGetInfo(hdbcAEAF0000, 17, rgbInfoValue, 100, pcbInfoValue);
SQLGetInfo(hdbcAEAF0000, 18, rgbInfoValue, 30, pcbInfoValue);
SQLAllocStmt(hdbcAEAF0000, phstmt9BEF0000);
SQLGetStmtOption(hstmt9BEF0000, 0, pvParam);
SQLSetStmtOption(hstmt9BEF0000, 0, 0000003C);
SQLGetStmtOption(hstmt9BEF0000, 3, pvParam);
SQLSetStmtOption(hstmt9BEF0000, 3, 7FFFFFFE);
SQLGetStmtOption(hstmt9BEF0000, 4, pvParam);
SQLSetStmtOption(hstmt9BEF0000, 4, 00000001);
SQLStatistics(hstmt9BEF0000, "(null)", -3, "dbo.wk_classif_rationale_desc",
3, "wk_classif_rationale_desc", -3, 1, 0);
SQLStatistics(hstmt9BEF0000, "(null)", -3, "dbo.wk_classif_rationale_desc",
3, "wk_classif_rationale_desc", -3, 1, 0);
SQLNumResultCols(hstmt9BEF0000, pccol);
SQLFetch(hstmt9BEF0000);
SQLGetData(hstmt9BEF0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9BEF0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9BEF0000, 4, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9BEF0000, 5, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9BEF0000, 6, 99, rgbValue, 254, pcbValue);
SQLGetData(hstmt9BEF0000, 7, 99, rgbValue, 2, pcbValue);
SQLGetData(hstmt9BEF0000, 11, 99, rgbValue, 4, pcbValue);
SQLGetData(hstmt9BEF0000, 12, 99, rgbValue, 4, pcbValue);
SQLFetch(hstmt9BEF0000);
SQLGetData(hstmt9BEF0000, 2, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9BEF0000, 3, 99, rgbValue, 63, pcbValue);
SQLGetData(hstmt9BEF0000, 4, 99, rgbValue, 2, pcbValue);
SQLError(henv99B70000, hdbcAEAF0000, hstmt9BEF0000, szSqlState,
pfNativeError, szErrorMsg, 8192, pcbErrorMsg);
SQLError(henv99B70000, hdbcAEAF0000, hstmt9BEF0000, szSqlState,
pfNativeError, szErrorMsg, 8138, pcbErrorMsg);