SQL Server

FTP Enable/Disable TLS 1.3

See more FTP Examples

Chilkat started supporting TLS 1.3 in version 9.5.0.82. For versions 9.5.0.82 and 9.5.0.83, TLS 1.3 was not enabled by default. A program could enable TLS 1.3 by including the "EnableTls13" keyword in the UncommonOptions property.

In Chilkat v9.5.0.84 and later, TLS 1.3 is enabled by default. TLS 1.3 can be disabled by including the "DisableTls13" keyword in UncommonOptions. This will cause TLS 1.2 to be used instead.

SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @ftp int
    EXEC @hr = sp_OACreate 'Chilkat.Ftp2', @ftp OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- In Chilkat v9.5.0.82 and .83, TLS 1.3 is not enabled by default. 
    -- To enable TLS 1.3, add the keyword "EnableTls13" to the UncommonOptions property.
    EXEC sp_OASetProperty @ftp, 'UncommonOptions', 'EnableTls13'

    -- In Chilkat v9.5.0.84 and later, TLS 1.3 is enabled by default.
    -- If disabling TLS 1.3 is needed (for some unanticipated reason), then add the keyword
    -- "DisableTls13" to UncommonOptions
    EXEC sp_OASetProperty @ftp, 'UncommonOptions', 'DisableTls13'

    EXEC @hr = sp_OADestroy @ftp


END
GO