Results 1 to 8 of 8
  1. #1
    Join Date
    May 2003
    Posts
    4

    Unanswered: Requires experts help

    Hello,

    In my application I need to call a HTTP address from the SQL server.Can I call the HTTP address within a stored procedure?
    Are there any ways to call HTTP address using SQL server?

    Awaiting for the reply.

    Regards

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Requires experts help

    Originally posted by SPathak
    Hello,

    In my application I need to call a HTTP address from the SQL server.Can I call the HTTP address within a stored procedure?
    Are there any ways to call HTTP address using SQL server?

    Awaiting for the reply.

    Regards
    what do u want to do exactly after calling the http address?
    do u want to access any data on the page or something?
    please clarify a bit more

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to books online for Executing SQL Statements Using HTTP topic.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    May 2003
    Posts
    4
    I need to call the ISAPI dll in the IIS virtual directory from stored procedure.Can it be possible?

  5. #5
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Originally posted by SPathak
    I need to call the ISAPI dll in the IIS virtual directory from stored procedure.Can it be possible?
    it is quite possible ,use sp_oacreate,
    for details refer to BOL.

  6. #6
    Join Date
    May 2003
    Posts
    4
    As I am new to this Can you explain me in detail how to create the http object using this procedure.

  7. #7
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    As its been suggested twice already..

    READ Books On Line for more information.
    There have been many posts made throughout the world.
    This was one of them.

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Well, for this reason I always suggest to refer to books online for any information. Hope few times you may not get much insight about the issue but it helps you to asses.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •