SQL Server

Disconnect from an FTP Server

Demonstrates the Chilkat Ftp2.Disconnect method, which ends the FTP session and closes the control connection. It takes no arguments. When connected, Chilkat sends QUIT and then closes the socket.

Background: Sending QUIT before closing is the polite shutdown — it lets the server finalize the session cleanly rather than seeing an abrupt socket drop. The method is idempotent, so calling it when nothing is connected, or a second time after the session is already closed, still succeeds; that makes it safe to put in cleanup paths without guarding it.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Demonstrates the Ftp2.Disconnect method, which ends the FTP session and closes the control
    --  connection.  It takes no arguments.  When connected, Chilkat sends QUIT and then closes the
    --  socket.

    DECLARE @ftp int
    EXEC @hr = sp_OACreate 'Chilkat.Ftp2', @ftp OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @ftp, 'Hostname', 'ftp.example.com'
    EXEC sp_OASetProperty @ftp, 'Username', 'myFtpLogin'

    --  Normally you would not hard-code the password in source.  You should instead obtain it
    --  from an interactive prompt, environment variable, or a secrets vault.
    EXEC sp_OASetProperty @ftp, 'Password', 'myPassword'

    --  Connect and log in (Connect performs both).
    EXEC sp_OAMethod @ftp, 'Connect', @success OUT
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @ftp
        RETURN
      END

    --  ... perform FTP operations ...

    --  Disconnect is idempotent: calling it when no connection exists, or calling it again after the
    --  session is already closed, still succeeds.
    EXEC sp_OAMethod @ftp, 'Disconnect', @success OUT
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @ftp
        RETURN
      END

    PRINT 'Disconnected.'

    EXEC @hr = sp_OADestroy @ftp


END
GO