(SQL Server) Accept Connection on Socket

Demonstrates how to create a TCP/IP socket, listen on a port, accept an incoming connection, and send a "Hello World" message to the client.

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
    DECLARE @iTmp0 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 @listenSocket int
    -- Use "Chilkat_9_5_0.Socket" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Socket', @listenSocket OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- Bind to a port and listen for incoming connections:
    -- This example will listen at port 5555 and allows for a backlog
    -- of 25 pending connection requests.
    DECLARE @success int
    EXEC sp_OAMethod @listenSocket, 'BindAndListen', @success OUT, 5555, 25
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @listenSocket, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @listenSocket
        RETURN
      END

    -- Get the next incoming connection
    -- Wait a maximum of 20 seconds (20000 millisec)
    DECLARE @connectedSocket int

    EXEC sp_OAMethod @listenSocket, 'AcceptNextConnection', @connectedSocket OUT, 20000
    EXEC sp_OAGetProperty @listenSocket, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @listenSocket, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @listenSocket
        RETURN
      END

    -- Set maximum timeouts for reading an writing (in millisec)
    EXEC sp_OASetProperty @connectedSocket, 'MaxReadIdleMs', 10000
    EXEC sp_OASetProperty @connectedSocket, 'MaxSendIdleMs', 10000

    -- Send a "Hello World!" message to the client:
    EXEC sp_OAMethod @connectedSocket, 'SendString', @success OUT, 'Hello World!'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @connectedSocket, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @connectedSocket

        EXEC @hr = sp_OADestroy @listenSocket
        RETURN
      END

    -- Close the connection with the client.
    -- Wait a max of 20 seconds (20000 millsec)
    EXEC sp_OAMethod @connectedSocket, 'Close', @success OUT, 20000


    PRINT 'success!'

    EXEC @hr = sp_OADestroy @listenSocket


END
GO