Results 1 to 3 of 3

Thread: Access Webservice with T-SQL

  1. 07-05-2005, 04:28 AM #1
    TheLoneStar
    TheLoneStar is offline Registered User
    Join Date
    Mar 2005
    Location
    Germany
    Posts
    10

    Access Webservice with T-SQL

    Hi!

    Is there any possibility to gain access to a webservice with T-SQL? I'm searching for a solution to access a BizTalk Server 2004 Orchestration (finally a webservice) as soon as a row is inserted in a table of my MS-SQL Server 2000 database (not the BizTalk Server one!!). Is it just possible to access webservices with yukon? Or are there possibilities in MSSQL 2000, too?

    Thanks for any help!

    Regards,

    thelonestar
    Reply With Quote Reply With Quote
  2. 07-05-2005, 08:45 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What do you mean 'access to a webservice with T-SQL'? Find string in web page or something else?
    Reply With Quote Reply With Quote
  3. 07-06-2005, 02:03 AM #3
    TheLoneStar
    TheLoneStar is offline Registered User
    Join Date
    Mar 2005
    Location
    Germany
    Posts
    10
    No a webservice is a kind of interface. In general its described in wsdl and accessed with the SOAP protocol. Especially in my project I want to call a webservice of a BizTalk Server application and put some tabledate as parameter. I've heard that with Yukon (MS SQL Server 2005) there are possibilities to do this. But I need a solution for MS SQL Server 2000.

    I hope it's a little bit more clearly now.
    Last edited by TheLoneStar; 07-06-2005 at 05:58 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules