How to connect through a proxy to an external SQL Server

brace · Post by **brace** » Tue 07 Feb 2012 08:58

How to setup MS Connection so that it connects to an external server thorugh a proxy?

One customer can connect to the internet only through a proxy and he needs to connect to a server located at a particular external IP and port.

How to achieve this with TMSConnection?

AndreyZ · Post by **AndreyZ** » Tue 07 Feb 2012 10:02

Hello,

To use non-standard port for connection, you should specify this port in the TMSConnection.Server property separated by a comma. Here is an example:

Code: Select all

MSConnection.Server := 'IP,Port';

To make possible connecting to SQL Server for your customer that can connect to the internet only through a proxy server, your customer has to set up the correct proxy network settings. These settings depend on particular used proxy server. This question can be solved only by network administrators. For more information, please refer to http://social.msdn.microsoft.com/Forums ... 4b4d207219

brace · Post by **brace** » Tue 07 Feb 2012 10:12

Thanks a lot, I will convey this info to the network administrator.

The original request they did was "your app should support our company proxy"

AndreyZ · Post by **AndreyZ** » Tue 07 Feb 2012 13:41

If any other questions come up, please contact us.