[Zope] setup for an odbc connection!

[Jim Sanford]

Not difficult to make login only site.

Give anonymous users no access rights (uncheck all checkboxes under
Anonymous under Security Tab at your top level.)

Put users in acl_users folder at root of your site.

Create a new role (MEMBER for example) and give all the users at least that
role.

Give MEMBER appropriate access rights (view, use database methods ...)

All users will now have to login.

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: Jim Sanford <jsanford@atinucleus.com>
Sent: Monday, November 15, 1999 1:57 PM
Subject: Re: [Zope] setup for an odbc connection!


> Hello Jim,
>
> Thank you very much. I do that, and now this is working very well! 8-)
> sorry by my ignorance!
> is complicate make a site where the user must log-in (with a valid user
name
> and password) to see some informations. (like in a bank site?)
>
> Thank you for the attention!
>
> Rod Za
>
>
> ----- Original Message -----
> From: Jim Sanford <jsanford@atinucleus.com>
> To: Rod Za <rodza@bhnet.com.br>; <zope@zope.org>
> Sent: Monday, November 15, 1999 5:07 PM
> Subject: Re: [Zope] setup for an odbc connection!
>
>
> > 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 )
> > >
> > >
> >
> >
> > _______________________________________________
> > 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 )
> >
>
>