(SQL Server) ConnectFailReason

See more FTP Examples

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @ftp int
    -- Use "Chilkat_9_5_0.Ftp2" for versions of Chilkat < 10.0.0
    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', 'login'
    EXEC sp_OASetProperty @ftp, 'Password', 'password'

    -- Connect and login to the FTP server.
    DECLARE @success int
    EXEC sp_OAMethod @ftp, 'Connect', @success OUT
    IF @success <> 1
      BEGIN

        -- The possible failure reasons are:
        -- 0 = success
        -- 
        -- Normal (non-TLS) sockets:
        -- 1 = empty hostname
        -- 2 = DNS lookup failed
        -- 3 = DNS timeout
        -- 4 = Aborted by application.
        -- 5 = Internal failure.
        -- 6 = Connect Timed Out
        -- 7 = Connect Rejected (or failed for some other reason)
        -- 
        -- SSL/TLS:
        -- 100 = TLS internal error.
        -- 101 = Failed to send client hello.
        -- 102 = Unexpected handshake message.
        -- 103 = Failed to read server hello.
        -- 104 = No server certificate.
        -- 105 = Unexpected TLS protocol version.
        -- 106 = Server certificate verify failed (the server certificate is expired or the cert's signature verification failed).
        -- 107 = Unacceptable TLS protocol version.
        -- 109 = Failed to read handshake messages.
        -- 110 = Failed to send client certificate handshake message.
        -- 111 = Failed to send client key exchange handshake message.
        -- 112 = Client certificate's private key not accessible.
        -- 113 = Failed to send client cert verify handshake message.
        -- 114 = Failed to send change cipher spec handshake message.
        -- 115 = Failed to send finished handshake message.
        -- 116 = Server's Finished message is invalid.
        -- 
        -- FTP:
        -- 200 = Connected, but failed to receive greeting from FTP server.
        -- 201 = Failed to do AUTH TLS or AUTH SSL.
        -- Protocol/Component:
        -- 300 = asynch op in progress
        -- 301 = login failure.

        DECLARE @failReason int
        EXEC sp_OAGetProperty @ftp, 'ConnectFailReason', @failReason OUT


        PRINT 'connect fail reason = ' + @failReason

        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @ftp
        RETURN
      END

    -- ..

    EXEC @hr = sp_OADestroy @ftp


END
GO