Chilkat HOME Android™ Classic ASP C C++ C# Mono C# .NET Core C# C# UWP/WinRT DataFlex Delphi ActiveX Delphi DLL Visual FoxPro Java Lianja MFC Objective-C Perl PHP ActiveX PHP Extension PowerBuilder PowerShell PureBasic CkPython Chilkat2-Python Ruby SQL Server Swift 2 Swift 3/4 Tcl Unicode C Unicode C++ Visual Basic 6.0 VB.NET VB.NET UWP/WinRT VBScript Xojo Plugin Node.js Excel Go
(SQL Server) SFTP using HTTP ProxyDemonstrates how to connect to an SFTP/SSH server through an HTTP proxy.
CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @sTmp0 nvarchar(4000) -- Important: It is helpful to send the contents of the -- sftp.LastErrorText property when requesting support. DECLARE @sftp int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.SFtp', @sftp OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END -- Any string automatically begins a fully-functional 30-day trial. DECLARE @success int EXEC sp_OAMethod @sftp, 'UnlockComponent', @success OUT, 'Anything for 30-day trial' IF @success <> 1 BEGIN EXEC sp_OAGetProperty @sftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @sftp RETURN END -- To connect through an HTTP proxy, set the HttpProxyHostname -- and HttpProxyPort properties to the hostname (or IP address) -- and port of the HTTP proxy. Typical port numbers used by -- HTTP proxy servers are 3128 and 8080. EXEC sp_OASetProperty @sftp, 'HttpProxyHostname', 'www.my-http-proxy.com' EXEC sp_OASetProperty @sftp, 'HttpProxyPort', 3128 -- Important: Your HTTP proxy server must allow non-HTTP -- traffic to pass. Otherwise this does not work. -- Connect to the SSH server through the HTTP proxy. -- The standard SSH port = 22 -- The hostname may be a hostname or IP address. DECLARE @port int DECLARE @hostname nvarchar(4000) SELECT @hostname = 'www.my-ssh-server.com' SELECT @port = 22 EXEC sp_OAMethod @sftp, 'Connect', @success OUT, @hostname, @port IF @success <> 1 BEGIN EXEC sp_OAGetProperty @sftp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @sftp RETURN END -- Your application is now connected to an SFTP/SSH server -- through an HTTP proxy. -- ... EXEC @hr = sp_OADestroy @sftp END GO |
© 2000-2016 Chilkat Software, Inc. All Rights Reserved.