Dear All,
I would like to remind that Turbo power is now open sourced. Their
original commerical encryption tools are available at sourceforge.net
It provides support for Blowfish, RSA, MD5, SHA-1, DES, triple- DES,
Rijndael, & digital signing of messages.

(URL http://sourceforge.net/projects/tplockbox)

it now comes with full set of documents. Don't miss it.

Rgds,
Eric Leung

Alan McDonald wrote:

> it obviously depends on what encryption method you are going to use
>
> Alan
>
> -----Original Message-----
> From: Olafur Gu?mundsson [mailto:og@...]
> Sent: Wednesday, 26 February 2003 11:58 PM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Encryption of data
>
>
> Yes, that's a good point.
>
> Regards
> Olafur
> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: 26. februar 2003 12:51
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Encryption of data
>
>
> i think also - you should think about the character set used on the server
> fields, just so the encryption matches and that data is not character set
> encrypted as well - I only get this feeling from looking at the wat IB/FB
> passwords are encrypted and looking at the password field character set on
> the security database
>
> Alan
>
> -----Original Message-----
> From: Olafur Gu?mundsson [mailto:og@...]
> Sent: Wednesday, 26 February 2003 11:05 PM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Encryption of data
>
>
> Thank you, this is one way of doing it, I thought where would be a easier
> way.
>
> Do you mean that the decryption should be done in the OnCalculateField?
>
> Regards
> Olafur
> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: 26. februar 2003 11:07
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Encryption of data
>
>
> At 10:53 AM 26/02/2003 +0000, you wrote:
> >Hi Helen, do you have a suggestion on this?
> >
> >I'm going to implement encryption of my data so that it will not be
> readable
> >to the sysdba on database level.
> >
> >I'm using TIB_Transaction, TIB_Datasource, TIB_Query and a TIB_RichEdit
> >control.
> >
> >I would like to do the encryp. in my app so it will be sent encry. to
> the
> >server.
> >
> >Where / in what event do I encrypt the data and where do I decrypt back
> the
> >data before it will show in the RichEdit control ?
> >
> >Can you help me with that?
>
> From own experience? no. I haven't done it.
>
> But I assume you will need to do something along these lines: map
> calculated fields for each of your encrypted data fields and hide the
> data
> fields. AFAIK, the encryption routine should take place in the
> OnCalculateField event (which needs to refer to the Row object);
> duplicate
> the decrypted data into non-data-aware fields for editing; provide
> parameterised xxxxSQL statements for all DML operations, calling SPs to
> perform the ops; and perform the encryption in BeforePost by encrypting
> the values from the non-data-aware controls into the params of stored
> procedures.
>
> Helen
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
>
>
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
>
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
>
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>