Re: Assertion: SQL Server 2000 can't issue a SOAP call

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 11:01:53 +0100

It might be worth mentioning that calling CLR code from SQL Server is not
supported.

Reference:
http://support.microsoft.com/default.aspx?scid=kb;en-us;322884

(I don't know how plausible it is that you end up with using CLR code when
doing these things, but better safe than sorry... :-) .) 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:uIo3mkLEEHA.3372@TK2MSFTNGP10.phx.gbl...
> Hi Rob.
>
> There's nothing in the core t-sql language that provides in-built access
to
> SOAP, but I'm puzzled as to why you'd say this: <snip> I'd love to do this
> from a stored procedure, or from an extended stored procedure, but I don't
> think that it can be done AT ALL </snip>.
>
> There's nothing you can't get done via an extended stored proc as the
whole
> world of programming is right there at your fingertips! Best languages for
> xp_'s are C++ or Delphi, but you could also implement something via COM as
> well using TSQL's sp_OACreate & related system stored procs. Using COM is
> very flexible as you're free to choose from a wider choice of languages
> although it's vulnerable to clean up problems, given TSQL's inherent error
> handling weaknesses. If you chose to go the COM route, you might find
> rolling the whole solution into a stored proc or User Defined Function
might
> help, perhaps returning a handle to a SQL XML doc for example. Another
whole
> option might be to create a DTS package... So there are a few ways..
>
> Does any of that make sense?
>
> Regards,
> Greg Linwood
> SQL Server MVP
>
> "Rob Hindman" <robhindman@hotmail.com> wrote in message
> news:d4199cf5.0403222205.211db103@posting.google.com...
> > (I originally posted this on comp.databases.ms-sqlserver, but I have
> > been asked to re-post to this group... Thanks!)
> >
> > I really hope I'm wrong about this - I can't find any way to issue a
> > SOAP call from SQL Server 2000. I've looked at the BOL, Google, MSDN,
> > and the SQLXML documentation and samples...
> >
> > There is quite a bit of discussion about how to EXPOSE SQL Server 2000
> > as a SOAP service, or even exposing stored procedures as web service
> > calls.
> >
> > But I can find absolutely NO mention of calling a separate SOAP
> > service from SQL Server 2000, and therefore I would like to assert to
> > this group that it can't be done - with the hope of finding out with
> > certainty...
> >
> > For example, I have the following wsdl target:
> > http://mssoapinterop.org/stk/Interop.wsdl, and I would like to call
> > the Interop/SoapPort/echoString method. (It takes any string for the
> > inputString parameter, and just echoes it back.)
> >
> > I'd love to do this from a stored procedure, or from an extended
> > stored procedure, but I don't think that it can be done AT ALL - which
> > makes me curious - if SQL Server 2000 with SQLXML can expose
> > functionality as SOAP methods, surely it would be possible to issue a
> > SOAP call as well?
> >
> > Many Thanks to anyone who can confim this assertion or show it to be
> > false.
> > -Rob.
> >
> > PS - Also, I have called MSDN support, and I will let both groups know
> > if there is a solution or work-around.
> > -R.
>
>

Relevant Pages

  • RE: Non initialized Cmd Parameter Collection via ASP vs SQL Server
    ... component to access database and execute some stored procedure. ... error when change the database from SQL server 2000 to SQL Server 2005, ... Microsoft MSDN Online Support Lead ... Delighting our customers is our #1 priority. ...
    (microsoft.public.data.ado)
  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • RE: Non initialized Cmd Parameter Collection via ASP vs SQL Server 200
    ... component to access database and execute some stored procedure. ... error when change the database from SQL server 2000 to SQL Server 2005, ... Microsoft MSDN Online Support Lead ... Delighting our customers is our #1 priority. ...
    (microsoft.public.data.ado)
  • Re: Assertion: SQL Server 2000 cant issue a SOAP call
    ... SOAP, but I'm puzzled as to why you'd say this: I'd love to do this ... from a stored procedure, or from an extended stored procedure, but I don't ... very flexible as you're free to choose from a wider choice of languages ... > SOAP call from SQL Server 2000. ...
    (microsoft.public.sqlserver.programming)
  • RE: Visual Basic 2005.Net TableAdapters
    ... TableAdapter doesn't work in the same manner as a SQL Server Stored ... A stored procedure consists of several SQL statements and compiled on the ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.languages.vb)
Loading