SQL Server

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

-- 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)
    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