locked
Listen to Data from TCP/IP Port and send to SQL Server 2008 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Can a SQL Server listen to Data from a TCP/IP Port?If So then how can we do this and transfer the data to a Database?

    The data format will be {Pole Number(8 digits),Load1R(integer),Load1Y(integer),Load1B(integer)}

    I am a complete noob will be grateful if u give me a detailed instruction for the same.

    i am using Microsoft SQL Server 2008 R2

    Thursday, May 24, 2012 10:14 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Amit,

    Q: Can SQL Server listen on a TCP/IP port for Data?

    A: Endpoints can be created, but not for specific data types like you want. SQL Server only listens for the following types of data on TCP/IP endpoints: TDS (TSQL), Service Broker, and Database Mirroring.

    What you may want to do is look into creating an application that makes use of Service Broker as it seems you're trying to do some type of loading or picking.

    http://msdn.microsoft.com/en-US/library/ms345108(v=SQL.90).aspx

    -Sean

    Sean Gallardy, MCC | Blog

    • Proposed as answer by Peja Tao Friday, May 25, 2012 1:56 AM
    • Marked as answer by Peja Tao Wednesday, May 30, 2012 5:09 AM
    Thursday, May 24, 2012 12:21 PM