One thing to add to Alex's reply. Can you put a web server behind the firewall to handle web services? If not, then ADO is the way to go.
>Thanks Craig
>
>I think I am going to have to go for a light weight sollution as the SQL Server box has been moved to the other end of a very low bandwidth line and behind some tight firewalls.
>
>Would you recommend Web Services over ADO/OLEDB under these circumstances ?, and if so
>could you point me to any relevant How-To articles on the Web Services subject.
>
>Thanks again
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer