Connecting to SQL Server from behind proxy with VB.NET
Posted on 2009-02-13
I've created a winforms application using programmers, but the project is over, the programmers are gone, and I must now solve this myself - hopefully with your help.
The client application is programmed in VB.NET. It connects to SQL Server 2005, which is on a hosted server. From most customer locations, this is no problem - but two customers use proxy servers for their internet connections, and they cannot connect. I don't have access to their proxy server or proxy details.
I have seen in some internet applications, that you can specify your proxy details. In other applications, I've seen that you can choose "use Internet Explorer proxy settings". So my question is this:
Is it possible to add some smart codelines to the login form of my application, that will load the internet explorer proxysettings from my customer's computer, and use this to connect to the SQL server? Or are there perhaps other ways to solve this?`
Thanks a lot!