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