Getting column names from a cursor using ODBC module?

John Machin sjmachin at lexicon.net
Sat Jun 21 10:19:38 EDT 2008


On Jun 21, 11:58 pm, dana... at yahoo.com wrote:
> Is there any way to retrieve column names from a cursor using the ODBC
> module? Or must I, in advance, create a dictionary of column position
> and column names for a particular table before I can access column
> values by column names? I'd prefer sticking with the ODBC module for
> now because it comes standard in Python.
>
> I'm using Python 2.4 at the moment.
>

Do you mean the odbc module? If so, it doesn't come standard in
Python; it's part of the win32 package.

I haven't used it for years -- my preference on Windows these days
would be mxODBC if the client would pay the licence fee, otherwise
pyodbc. Sorry I'm not answering your question ... perhaps you should
be asking a different question :)

Cheers,
John



More information about the Python-list mailing list