[Zope] Microsoft Access database

[Chris Gray]

Just one point of clarification added below since the original poster
seemed confused on this point. 

Chris


On Thu, 23 Nov 2000, Diny van Gool wrote:

> At 23:07 22-11-00 -0500, John Cappelletti wrote:
> >[...]
> >What is the process for connecting to a MS Access database? Can it be
> >done?
> 
> Yes, it can. I'm running Zope 2.2.0 on Windows98 with Access97. You'll have
> to use the ZODBCDA product.
> 
> In Windows98:
> 
> - Use the Control Panel - ODBC connection - Add a system DNS
> - Select the MS Access driver
> - Fill in an alias name and select the database you want to use

When you "Select" the database in the "ODBC Microsoft Access Setup" dialog
box you can point it to an .mdb file anywhere on your system.  It doesn't
have to be in your Zope directory.

> In Zope:
> 
> - Add a Z ODBC database connection
> - Select the alias you defined above and Add
> 
> Diny