Sunday, March 11, 2012

Connection to SQL server dilema

Hello,
I have a winform which use's a connection string to connect to a hosted SQL server offsite.
I have a friend who is trying to use my application but is behind a firewall and the connection does not work and opening ports is not an option.
So I thought I would try using a web service. The webservice connection works for me, but not for my friend, looking at the error my friend recieves, it would appear the firewall is stripping out the SOAP headers.
So to my question, is there another connection type or dot net connection solution that will allow me to communicate to a sql server when user is behind firewall.
I thought of using a web control embedded within the winform but I am unsure of how to interact data between web control and winform.
Anyone with any thoughts/suggestions on this?
Thanks
Peter
If a Web Service is being disabled in some way by a firewall, in theory if the user can access a normal Web page, you could create a normal Web page that will return the data in a relatively convenient format and then have the Winforms application essentially "Screen Scrape", parsing the data on the Web page. This is not efficient, and has many security issues, but it may well work in a pinch.
Better would be to investigate with the admin of the firewall what is happening with the Web service.

No comments:

Post a Comment