I'm writing ASP page that uses a generic ODBC driver to query MsSql2K.
Have some generic code that grabs both an array of the resultSet, plus
an array of fieldNames (cursor Description).

When I run this code against a view (which just does a pretty simple
join: have queried the view fine in MsSqlQueryAnalyzer), I get an error
message about

SQL select Failed - "select * from timechargesAsHours" -
[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index in FETCH

In stepping through the code interactively, I find the problem occurs at
the cursor.fetchall() call.

Is there a problem getting cursor descriptions via ODBC? Or is there an
inherent problem in using a cursor against a view? Does a cursor require
a unique key, which a view lacks?
_______________________________________________
ActivePython mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activepython

Reply via email to