SQL Server Requires Chilkat v11.0.0+

Accept Connection on Socket

See more Socket/SSL/TLS Examples

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. SQL Server

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

    --  This example requires the Chilkat API to have been previously unlocked.
    --  See Global Unlock Sample for sample code.

    DECLARE @listenSocket int
    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.
    EXEC sp_OAMethod @listenSocket, 'BindAndListen', @success OUT, 5555, 25
    IF @success = 0
      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 @hr = sp_OACreate 'Chilkat.Socket', @connectedSocket OUT

    EXEC sp_OAMethod @listenSocket, 'AcceptNext', @success OUT, 20000, @connectedSocket
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @listenSocket, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @listenSocket
        EXEC @hr = sp_OADestroy @connectedSocket
        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 @listenSocket
        EXEC @hr = sp_OADestroy @connectedSocket
        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
    EXEC @hr = sp_OADestroy @connectedSocket


END
GO