August 16, 2002 at 5:36 pm
Sorry if this has been hashed out before, but I've been asked to provide possible solutions to transfer encripted data from our SQL box, to a extranet www server via ADO.
MS SOAP, or convert box to W2k/SQL2k and use .Net tools?
Thanks for any input
August 16, 2002 at 7:37 pm
SQL Server 7 has the multiprotocol for encrypting the datastream. Books Online should have the information about setting up both the SQL Server and client to use this netlib.
ADO doesn't care much about the network library, that's handled at a lower level, so if you can get the boxes talking via multiprotocol, you shouldn't need to alter any code.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
August 22, 2002 at 10:04 am
multiprotocol is the easiest. Could use IPSec, PPTP, or others if you want.
Steve Jones
August 22, 2002 at 10:18 am
Thanks guys, it does look like Mulitprotocol will work well for our current needs.
Great forum!
-Don-
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply