I am running Zope on a Win 98 system and would like to establish a connection to a MS Access database. The ZSQL Methods User Guide identifies several databases with which Zope is compatible--Access is not among them. However, ODBC is. I attempted to setup ODBC, experimenting with File DSN and placing the database file in the var/gadfly directory (admittedly, I don't have a working knowledge of how to setup ODBC). Following the normal Zope database connection procedure, Zope appears to connect to the database but a test query does not work (table/object not found). What is the process for connecting to a MS Access database? Can it be done? Thanks in advance for your help. John Cappelletti AverStar, Inc. 1593 Spring Hill Road, Suite 700 Vienna, VA 22182-2249 Tel: (703) 827-2606 x 4291 (also, 301 443-7509) Fax: (703) 827-5560
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 In Zope: - Add a Z ODBC database connection - Select the alias you defined above and Add Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl
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
I've gone through the catalog aware example in the Zope book but there was one small problem. The vocabulary was not being updated until I went in and clicked the update catalog button. Is this a known bug or should I retrace my steps to figure out where I messed up? Chris
Did you un-comment re-index in add? Hitting update catalog is not necessary. Chris Gray wrote:
I've gone through the catalog aware example in the Zope book but there was one small problem. The vocabulary was not being updated until I went in and clicked the update catalog button. Is this a known bug or should I retrace my steps to figure out where I messed up?
Chris
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (4)
-
Chalu Kim -
Chris Gray -
Diny van Gool -
John Cappelletti