SQL-SELECT against View via ODBC?

[Steve Holden]

The generic odbc driver (I presume you mean the one from the Windows
extensions) is known to be in need of maitnenance, and I understand from a
recent posting that Mark Hammond expects to release a slightly updated copy
(may even have done so by now).

I checked views out using mxODBC (see www.egenix.com, follow the links at
the foot of the page) and everything was fine. Using the generic odbc driver
I couldn't even access my ODBC source, since I don't use trusted
connections!

If this isn't a commercial project you might want to consider using mxODBC.
It's my ODBC driver of choice.

regards
 Steve
--
http://www.holdenweb.com/


"Bill Seitz" <fluxent at yahoo.com> wrote in message
news:e2491a75.0106251209.c19d5e at posting.google.com...
> I'm writing ASP page that uses the generic Python ODBC driver to query
> MsSql2K. Have some generic Python that grabs both an array of the
> resultSet (cursor FetchAll), 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
>
> Is there a problem getting cursor descriptions via ODBC?