Jeff Sacksteder wrote:
If you want to access the results of ZSQL queries from an ODBC connection, you will have to access them positionally.
if your results are in a variable called result_set you can do something like this to list the contents of the first three columns for each row.
for row in result_set: print row[0],row[1],row[2]
An ugly workaround, but it works. Additionally, the odbc module is single threaded, so if you have a large query that takes two minutes to run, everyone else is blocked until it completes.
What!?? - You must be joking. I am very troubled by the whole DA situation. ZMySQLDA - seems to work but I haven't *really* tested it. ZOracleDA - I Don't use Oracle so I don't know if it works. ZODBCDA - seems to be very buggy. Zpsycopg - Buggy but improving day by day. Installation stinks, but this is mostly due to lack of features in Python. Installation of a DA should IMHO be as simple as installing ZODBCDA. \Oliver - which is going to write a DA for MSSQL as soon as possible.