Post reply

HTTP Post via SP

  • October 29, 2009 at 4:17 am

    #212730

    Hi,

    I need help to send a HTTP Post via SQL Server SP something like the below :

    usp_http_post 'http://1.2.3.4/cmd/system/api/sendsms.cgi?tar_num=12345678&tar_msg=how+are+you+?&label=modem1&tar_mode=text'

    I had looked at some scripts from this site but I've still no idea on how to work out the SP.

    The SMS gateway (1.2.3.4) does not have any asp page. It merely receives input via the http post.

    Thanks !!!

  • October 29, 2009 at 4:20 am

    #1072325

    Hi

    My advice would be, don't do this within SQL Server if possible. HTTP-Posts/-Requests usually should be done by a process.

    If you really need to do this with SQL Server, use a CLR procedure.

    Greets

    Flo

  • October 29, 2009 at 8:21 pm

    #1072927

    I've tried but have very little clues to CLR. I had explored C# but I'm not sure whether System.Net will work in SQL Server. Also very handicapped about the C# codes.

    So far I had seen many using OLE automation to achieve this.

    TIA !

  • October 30, 2009 at 12:13 am

    #1072953

    Hi

    Here you can find several links posted by Paul White depending on .NET and with Web-Services:

    http://www.sqlservercentral.com/Forums/Topic805754-386-1.aspx

    And here you can find a little blog which shows how to generally work with .NET and HTTP requests:

    http://florianreischl.blogspot.com/search/label/web%20service

    Hope this helps

    Flo

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply