Sounds similar ... I think the application ( purpose ) is probably a bit
different...

Indicentally -- you can use SSL to encrypt a SQL Server 2000 connection ...
we want the actual data encrypted in the db tho...

> I think we are looking for the same thing, I just started
> a thread encrypting cfquery, then I saw this thread (get
> to many emails!!).  We want to take the data being passed
> back and forth from the sql box and have it go accross
> encrypted.

>>>> [EMAIL PROTECTED] 09/20/02 07:06PM >>>
> Yea, Java's probably not viable in this particular
> environment... the flat
> file is for NACH to go to the bank via modem ( not over an
> internet
> connection ), then gets deleted.

>> Encrypted in the DB but not encrypted in the flat file?
>> Do you ever need to
>> decrypt the encrypted data?

>> I'm not much of a COM guy but Java has internal
>> encryption
>> classes (dunno if
>> that's an option for you).

>> --
>> Mosh Teitelbaum
>> evoch, LLC
>> Tel: (301) 625-9191
>> Fax: (301) 933-3651
>> Email: [EMAIL PROTECTED]
>> WWW: http://www.evoch.com/


>>> -----Original Message-----
>>> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
>>> Sent: Friday, September 20, 2002 1:37 PM
>>> To: CF-Talk
>>> Subject: encryption - CF & SQL Server
>>>
>>>
>>> The story is this:
>>>
>>> We have an app that will need to generate a flat text
>>> file from
>>> SQL Server (
>>> without the aid of ColdFusion ) and there is a
>>> requirement that
>>> some of the
>>> data be encrypted in the db, but we don't want the data
>>> to be
>>> passed in the
>>> form unencrypted ( disclusing SSL -- we will SSL encrypt
>>> the
>>> directory, but
>>> they want another layer of security ).
>>>
>>> So I've been tasked with finding "reasonably
>>> inexpensive"
>>> encryption
>>> software for COM which can be used as both a CFX tag in
>>> ColdFusion and by
>>> SQL Server either internally or from the command-line on
>>> the SQL Server
>>> machine using the master..xp_cmdshell stored procedure.
>>> Both CF Server and
>>> SQL Server are Windows 2000 Servers ( was that obvious?
>>> :) Any suggestions
>>> or advice would be greatly appreciated, thanks,
>>>
>>>
>>> S. Isaac Dealey
>>> Certified Advanced ColdFusion 5 Developer
>>>
>>> New Epoch
>>> www.turnkey.to
>>> 954-776-0046
>>>
>> _________________________________________________________
>> _
>> ____________
>> Get the mailserver that powers this list at
>> http://www.coolfusion.com
>> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
>> Archives:
>> http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> Unsubscribe:
>> http://www.houseoffusion.com/index.cfm?sidebar=lists


> Isaac
> Certified Advanced ColdFusion 5 Developer

> www.turnkey.to
> 954-776-0046


> __________________________________________________________
> ____________
> This list and all House of Fusion resources hosted by
> CFHosting.com. The place for dependable ColdFusion
> Hosting.
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives:
> http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to