[Zope] Multiple ZODBC sources

Andrew Kenneth Milton akm@mail.theinternet.com.au
Thu, 23 Nov 2000 02:15:03 +1000


+-------[ Capesius, Alan ]----------------------
| I need to join tables from two ODBC sources, one MS Access one SQL. 
| 
| ZODBC DA seems to be limited to one data source at a time. Is there any way
| to join tables from two different sources?

Write a method to copy the results from Access into a temporary table of the 
other.

Then do your query and clean up.

-- 
Totally Holistic Enterprises Internet|  P:+61 7 3870 0066   | Andrew Milton
The Internet (Aust) Pty Ltd          |  F:+61 7 3870 4477   | 
ACN: 082 081 472 ABN: 83 082 081 472 |  M:+61 416 022 411   | Carpe Daemon
PO Box 837 Indooroopilly QLD 4068    |akm@theinternet.com.au|