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