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