How to connect through a proxy to an external SQL Server

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
brace
Posts: 213
Joined: Wed 14 Feb 2007 08:26

How to connect through a proxy to an external SQL Server

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
Posts: 213
Joined: Wed 14 Feb 2007 08:26

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.

Post Reply