you should be able to access the dbf file with the Microsoft dBase ODBC driver. you would need to set up a system DSN for it: Start-Settings-Control Panel Select ODBC Select System DSN Click Add Select Microsoft dBase Driver(*.dbf) Click Finish Give it a Data Source Name Enter a Description if you wish Select version (III, IV 5.0) Select a Directory (c:\dbfs) Select Indexes Create a ZODBCDA connection to the system DSN (it should appear in the dropdown in the ZODBCDA create screen) You would refer to the file in your SQL statement in a ZSQL method: SELECT * FROM cass WHERE mailer_id = 'MetroMail' Jim Sanford Databases Engineer 334-661-5770 jsanford@atinucleus.com http://www.atinucleus.com Accelerated Technology, Inc. 720 Oak Circle Drive East Mobile, AL 36609 **Source Code, No Royalties, Any CPU ... It just makes sense. ----- Original Message ----- From: Rod Za <rodza@bhnet.com.br> To: <zope@zope.org> Sent: Monday, November 15, 1999 12:38 PM Subject: [Zope] setup for an odbc connection!

Hello all, Maybe someone can help me. I have a dbf file that i need to consult with Zope. This is a simple file (named cass.dbf). Ok. I have installed the ZODBC and like to know how to use this. I have try various resources to make this but i can't. First of all. need i configure the windows odbc manager to locate my cass.dbf file? (this is in c:\dbfs\)

Thank you very much.

Rod Za

_______________________________________________ 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 )