[Zope] ZODBC and dictionaties

[Oliver Marx]

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.