[Zope] setup for an odbc connection!

Jim Sanford jsanford@atinucleus.com
Mon, 15 Nov 1999 13:07:07 -0600


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