(Sorry for the cross-post - I put this on the regular XML list by
accident.)
There there anyway to get this to work:
http://mydomain.com/some.xml&xsl=mother.xslt
where some.xml is
<root xmlns:sql='urn:schemas-microsoft-com:xml-sql'>
<sql:header sql:nullvalue="IsNULL">
</sql:header>
<sql:query >
SELECT * FROM sometable
FOR xml path('somenode'), root('nodes')
</sql:query>
</root>
and mother.xslt has
<xsl:variable name="employees" select="document('http://mydomain.com/
someother.xml')"/>
Note that we use windows authentication.
Based on these, it appears not to be possible:
http://msdn2.microsoft.com/en-us/library/ms763800.aspx
http://msdn2.microsoft.com/en-us/library/ms256465.aspx
Check out this article:
Communicate with a SQL Database During an XSL Transform
http://www.braintrove.com/article/30
Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )
|||On Apr 26, 11:34 am, "Greg Collins [Microsoft MVP]"
<gcollins_AT_msn_DOT_com> wrote:
> Check out this article:
> Communicate with a SQL Database During an XSL Transformhttp://www.braintrove.com/article/30
> --
> Greg Collins [Microsoft MVP]
> Visit Braintrove (http://www.braintrove.com)
This a good article, Greg. However, I'm trying to accomplish this
strictly with SQLXML via 1 URL. I pass the master xml doc along with
an xslt doc which itself creates a variable via another SQLXML URL.
Any more ideas about this?
Thanks!
Showing posts with label sqlxml. Show all posts
Showing posts with label sqlxml. Show all posts
Tuesday, March 27, 2012
Calling SQLXML From XSLT
(Sorry for the cross-post - I put this on the regular XML list by
accident.)
There there anyway to get this to work:
http://mydomain.com/some.xml&xsl=mother.xslt
where some.xml is
<root xmlns:sql='urn:schemas-microsoft-com:xml-sql'>
<sql:header sql:nullvalue="IsNULL">
</sql:header>
<sql:query >
SELECT * FROM sometable
FOR xml path('somenode'), root('nodes')
</sql:query>
</root>
and mother.xslt has
<xsl:variable name="employees" select="document('http://mydomain.com/
someother.xml')"/>
Note that we use windows authentication.
Based on these, it appears not to be possible:
http://msdn2.microsoft.com/en-us/library/ms763800.aspx
http://msdn2.microsoft.com/en-us/library/ms256465.aspxCheck out this article:
Communicate with a SQL Database During an XSL Transform
http://www.braintrove.com/article/30
--=20
Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )|||On Apr 26, 11:34 am, "Greg Collins [Microsoft MVP]"
<gcollins_AT_msn_DOT_com> wrote:
> Check out this article:
> Communicate with a SQL Database During an XSL Transformhttp://www.braintro
ve.com/article/30
> --
> Greg Collins [Microsoft MVP]
> Visit Braintrove (http://www.braintrove.com)
This a good article, Greg. However, I'm trying to accomplish this
strictly with SQLXML via 1 URL. I pass the master xml doc along with
an xslt doc which itself creates a variable via another SQLXML URL.
Any more ideas about this?
Thanks!
accident.)
There there anyway to get this to work:
http://mydomain.com/some.xml&xsl=mother.xslt
where some.xml is
<root xmlns:sql='urn:schemas-microsoft-com:xml-sql'>
<sql:header sql:nullvalue="IsNULL">
</sql:header>
<sql:query >
SELECT * FROM sometable
FOR xml path('somenode'), root('nodes')
</sql:query>
</root>
and mother.xslt has
<xsl:variable name="employees" select="document('http://mydomain.com/
someother.xml')"/>
Note that we use windows authentication.
Based on these, it appears not to be possible:
http://msdn2.microsoft.com/en-us/library/ms763800.aspx
http://msdn2.microsoft.com/en-us/library/ms256465.aspxCheck out this article:
Communicate with a SQL Database During an XSL Transform
http://www.braintrove.com/article/30
--=20
Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )|||On Apr 26, 11:34 am, "Greg Collins [Microsoft MVP]"
<gcollins_AT_msn_DOT_com> wrote:
> Check out this article:
> Communicate with a SQL Database During an XSL Transformhttp://www.braintro
ve.com/article/30
> --
> Greg Collins [Microsoft MVP]
> Visit Braintrove (http://www.braintrove.com)
This a good article, Greg. However, I'm trying to accomplish this
strictly with SQLXML via 1 URL. I pass the master xml doc along with
an xslt doc which itself creates a variable via another SQLXML URL.
Any more ideas about this?
Thanks!
Wednesday, March 7, 2012
Call Soap SqlXML soap webservice
I setup a soap webservice using sqlxml 3.0 on our IIS server, I can
consume the webservice via "dotNET" but I am having a heck of a time
trying to make a call out of a vba project. Currently I do not have
the time to develope a new interface all in dotNET, thus the my need to
try and post to the soap object from Access2003... another idea is to
shell out to the vb.net app where I have the webservice working ... :|
Dim http As Object
Set http = CreateObject("Microsoft.XMLHTTP")
http.Open "POST", "http://localhost/ws/report", False
Call http.send("<SR =TEST /> ")
Debug.Print http.responseText
Set http = Nothing
my response for this is:
xmlns:xsd='http://www.w3.org/2001/XMLSchema'
xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'
xmlns:sqltypes='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types'
xmlns:sqlmessage='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/
SqlMessage'
xmlns:sqlresultstream='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/t
ypes/SqlResultStream'>
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
<faultcode>SOAP-ENV:Client</faultcode>
<faultstring>Incorrectly formatted SOAP request</faultstring>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>SOAP is a message protocol in XML form that you can send over HTTP. Below
you tried to send an XML only over HTTP (which you can do if your server
knows what to do with it). So if you want to avoid developing a new
interface, the easiest would probably be to create the SOAP message that you
want to send in your VB code (look at the message that is sent from the
VB.Net app or the SOAP 1.0 spec for details on what the SOAP message format
needs to look like).
Best regards
Michael
<fhtapia@.gmail.com> wrote in message
news:1130949535.378275.277320@.f14g2000cwb.googlegroups.com...
>I setup a soap webservice using sqlxml 3.0 on our IIS server, I can
> consume the webservice via "dotNET" but I am having a heck of a time
> trying to make a call out of a vba project. Currently I do not have
> the time to develope a new interface all in dotNET, thus the my need to
> try and post to the soap object from Access2003... another idea is to
> shell out to the vb.net app where I have the webservice working ... :|
> Dim http As Object
> Set http = CreateObject("Microsoft.XMLHTTP")
> http.Open "POST", "http://localhost/ws/report", False
> Call http.send("<SR =TEST /> ")
> Debug.Print http.responseText
> Set http = Nothing
> my response for this is:
> xmlns:xsd='http://www.w3.org/2001/XMLSchema'
> xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
> xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'
> xmlns:sqltypes='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types'
> xmlns:sqlmessage='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/type
s/SqlMessage'
> xmlns:sqlresultstream='http://schemas.microsoft.com/SQLServer/2001/12/SOAP
/types/SqlResultStream'>
> <SOAP-ENV:Body>
> <SOAP-ENV:Fault>
> <faultcode>SOAP-ENV:Client</faultcode>
> <faultstring>Incorrectly formatted SOAP request</faultstring>
> </SOAP-ENV:Fault>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>|||Michael,
Thanks for your help on this, so what I need is a soap envelope... I
wish I could have ran into this documentation earlier on, I also
downloaded the "soap sdk" and utilized the trace utility in order to
capture my call and get the correct soap envelop as used by dotNet here
is my variation
request = "<?xml version='1.0' encoding='UTF-8' standalone='no'?>" &
_
"<SOAP-ENV:Envelope
xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>" & _
" <SOAP-ENV:Body>" & _
" <SR xmlns='http://Localhost/ws/Report'>" & _
" <XmlReport>'" & strXML & "'</XmlReport>" & _
" </SR>" & _
" </SOAP-ENV:Body>" & _
"</SOAP-ENV:Envelope>"|||Glad to be of help.
Michael
"seeCoolGuy" <fhtapia@.gmail.com> wrote in message
news:1131046410.373083.163320@.g47g2000cwa.googlegroups.com...
> Michael,
> Thanks for your help on this, so what I need is a soap envelope... I
> wish I could have ran into this documentation earlier on, I also
> downloaded the "soap sdk" and utilized the trace utility in order to
> capture my call and get the correct soap envelop as used by dotNet here
> is my variation
> request = "<?xml version='1.0' encoding='UTF-8' standalone='no'?>" &
> _
> "<SOAP-ENV:Envelope
> xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>" & _
> " <SOAP-ENV:Body>" & _
> " <SR xmlns='http://Localhost/ws/Report'>" & _
> " <XmlReport>'" & strXML & "'</XmlReport>" & _
> " </SR>" & _
> " </SOAP-ENV:Body>" & _
> "</SOAP-ENV:Envelope>"
>
consume the webservice via "dotNET" but I am having a heck of a time
trying to make a call out of a vba project. Currently I do not have
the time to develope a new interface all in dotNET, thus the my need to
try and post to the soap object from Access2003... another idea is to
shell out to the vb.net app where I have the webservice working ... :|
Dim http As Object
Set http = CreateObject("Microsoft.XMLHTTP")
http.Open "POST", "http://localhost/ws/report", False
Call http.send("<SR =TEST /> ")
Debug.Print http.responseText
Set http = Nothing
my response for this is:
xmlns:xsd='http://www.w3.org/2001/XMLSchema'
xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'
xmlns:sqltypes='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types'
xmlns:sqlmessage='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/
SqlMessage'
xmlns:sqlresultstream='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/t
ypes/SqlResultStream'>
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
<faultcode>SOAP-ENV:Client</faultcode>
<faultstring>Incorrectly formatted SOAP request</faultstring>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>SOAP is a message protocol in XML form that you can send over HTTP. Below
you tried to send an XML only over HTTP (which you can do if your server
knows what to do with it). So if you want to avoid developing a new
interface, the easiest would probably be to create the SOAP message that you
want to send in your VB code (look at the message that is sent from the
VB.Net app or the SOAP 1.0 spec for details on what the SOAP message format
needs to look like).
Best regards
Michael
<fhtapia@.gmail.com> wrote in message
news:1130949535.378275.277320@.f14g2000cwb.googlegroups.com...
>I setup a soap webservice using sqlxml 3.0 on our IIS server, I can
> consume the webservice via "dotNET" but I am having a heck of a time
> trying to make a call out of a vba project. Currently I do not have
> the time to develope a new interface all in dotNET, thus the my need to
> try and post to the soap object from Access2003... another idea is to
> shell out to the vb.net app where I have the webservice working ... :|
> Dim http As Object
> Set http = CreateObject("Microsoft.XMLHTTP")
> http.Open "POST", "http://localhost/ws/report", False
> Call http.send("<SR =TEST /> ")
> Debug.Print http.responseText
> Set http = Nothing
> my response for this is:
> xmlns:xsd='http://www.w3.org/2001/XMLSchema'
> xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
> xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'
> xmlns:sqltypes='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types'
> xmlns:sqlmessage='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/type
s/SqlMessage'
> xmlns:sqlresultstream='http://schemas.microsoft.com/SQLServer/2001/12/SOAP
/types/SqlResultStream'>
> <SOAP-ENV:Body>
> <SOAP-ENV:Fault>
> <faultcode>SOAP-ENV:Client</faultcode>
> <faultstring>Incorrectly formatted SOAP request</faultstring>
> </SOAP-ENV:Fault>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>|||Michael,
Thanks for your help on this, so what I need is a soap envelope... I
wish I could have ran into this documentation earlier on, I also
downloaded the "soap sdk" and utilized the trace utility in order to
capture my call and get the correct soap envelop as used by dotNet here
is my variation
request = "<?xml version='1.0' encoding='UTF-8' standalone='no'?>" &
_
"<SOAP-ENV:Envelope
xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>" & _
" <SOAP-ENV:Body>" & _
" <SR xmlns='http://Localhost/ws/Report'>" & _
" <XmlReport>'" & strXML & "'</XmlReport>" & _
" </SR>" & _
" </SOAP-ENV:Body>" & _
"</SOAP-ENV:Envelope>"|||Glad to be of help.
Michael
"seeCoolGuy" <fhtapia@.gmail.com> wrote in message
news:1131046410.373083.163320@.g47g2000cwa.googlegroups.com...
> Michael,
> Thanks for your help on this, so what I need is a soap envelope... I
> wish I could have ran into this documentation earlier on, I also
> downloaded the "soap sdk" and utilized the trace utility in order to
> capture my call and get the correct soap envelop as used by dotNet here
> is my variation
> request = "<?xml version='1.0' encoding='UTF-8' standalone='no'?>" &
> _
> "<SOAP-ENV:Envelope
> xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>" & _
> " <SOAP-ENV:Body>" & _
> " <SR xmlns='http://Localhost/ws/Report'>" & _
> " <XmlReport>'" & strXML & "'</XmlReport>" & _
> " </SR>" & _
> " </SOAP-ENV:Body>" & _
> "</SOAP-ENV:Envelope>"
>
Call Soap SqlXML soap webservice
I setup a soap webservice using sqlxml 3.0 on our IIS server, I can
consume the webservice via "dotNET" but I am having a heck of a time
trying to make a call out of a vba project. Currently I do not have
the time to develope a new interface all in dotNET, thus the my need to
try and post to the soap object from Access2003... another idea is to
shell out to the vb.net app where I have the webservice working ... :|
Dim http As Object
Set http = CreateObject("Microsoft.XMLHTTP")
http.Open "POST", "http://localhost/ws/report", False
Call http.send("<SR =TEST /> ")
Debug.Print http.responseText
Set http = Nothing
my response for this is:
xmlns:xsd='http://www.w3.org/2001/XMLSchema'
xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'
xmlns:sqltypes='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types'
xmlns:sqlmessage='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/SqlMessage'
xmlns:sqlresultstream='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/SqlResultStream'>
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
<faultcode>SOAP-ENV:Client</faultcode>
<faultstring>Incorrectly formatted SOAP request</faultstring>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
SOAP is a message protocol in XML form that you can send over HTTP. Below
you tried to send an XML only over HTTP (which you can do if your server
knows what to do with it). So if you want to avoid developing a new
interface, the easiest would probably be to create the SOAP message that you
want to send in your VB code (look at the message that is sent from the
VB.Net app or the SOAP 1.0 spec for details on what the SOAP message format
needs to look like).
Best regards
Michael
<fhtapia@.gmail.com> wrote in message
news:1130949535.378275.277320@.f14g2000cwb.googlegr oups.com...
>I setup a soap webservice using sqlxml 3.0 on our IIS server, I can
> consume the webservice via "dotNET" but I am having a heck of a time
> trying to make a call out of a vba project. Currently I do not have
> the time to develope a new interface all in dotNET, thus the my need to
> try and post to the soap object from Access2003... another idea is to
> shell out to the vb.net app where I have the webservice working ... :|
> Dim http As Object
> Set http = CreateObject("Microsoft.XMLHTTP")
> http.Open "POST", "http://localhost/ws/report", False
> Call http.send("<SR =TEST /> ")
> Debug.Print http.responseText
> Set http = Nothing
> my response for this is:
> xmlns:xsd='http://www.w3.org/2001/XMLSchema'
> xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
> xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'
> xmlns:sqltypes='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types'
> xmlns:sqlmessage='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/SqlMessage'
> xmlns:sqlresultstream='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/SqlResultStream'>
> <SOAP-ENV:Body>
> <SOAP-ENV:Fault>
> <faultcode>SOAP-ENV:Client</faultcode>
> <faultstring>Incorrectly formatted SOAP request</faultstring>
> </SOAP-ENV:Fault>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
|||Michael,
Thanks for your help on this, so what I need is a soap envelope... I
wish I could have ran into this documentation earlier on, I also
downloaded the "soap sdk" and utilized the trace utility in order to
capture my call and get the correct soap envelop as used by dotNet here
is my variation
request = "<?xml version='1.0' encoding='UTF-8' standalone='no'?>" &
_
"<SOAP-ENV:Envelope
xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>" & _
" <SOAP-ENV:Body>" & _
" <SR xmlns='http://Localhost/ws/Report'>" & _
" <XmlReport>'" & strXML & "'</XmlReport>" & _
" </SR>" & _
" </SOAP-ENV:Body>" & _
"</SOAP-ENV:Envelope>"
|||Glad to be of help.
Michael
"seeCoolGuy" <fhtapia@.gmail.com> wrote in message
news:1131046410.373083.163320@.g47g2000cwa.googlegr oups.com...
> Michael,
> Thanks for your help on this, so what I need is a soap envelope... I
> wish I could have ran into this documentation earlier on, I also
> downloaded the "soap sdk" and utilized the trace utility in order to
> capture my call and get the correct soap envelop as used by dotNet here
> is my variation
> request = "<?xml version='1.0' encoding='UTF-8' standalone='no'?>" &
> _
> "<SOAP-ENV:Envelope
> xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>" & _
> " <SOAP-ENV:Body>" & _
> " <SR xmlns='http://Localhost/ws/Report'>" & _
> " <XmlReport>'" & strXML & "'</XmlReport>" & _
> " </SR>" & _
> " </SOAP-ENV:Body>" & _
> "</SOAP-ENV:Envelope>"
>
consume the webservice via "dotNET" but I am having a heck of a time
trying to make a call out of a vba project. Currently I do not have
the time to develope a new interface all in dotNET, thus the my need to
try and post to the soap object from Access2003... another idea is to
shell out to the vb.net app where I have the webservice working ... :|
Dim http As Object
Set http = CreateObject("Microsoft.XMLHTTP")
http.Open "POST", "http://localhost/ws/report", False
Call http.send("<SR =TEST /> ")
Debug.Print http.responseText
Set http = Nothing
my response for this is:
xmlns:xsd='http://www.w3.org/2001/XMLSchema'
xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'
xmlns:sqltypes='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types'
xmlns:sqlmessage='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/SqlMessage'
xmlns:sqlresultstream='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/SqlResultStream'>
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
<faultcode>SOAP-ENV:Client</faultcode>
<faultstring>Incorrectly formatted SOAP request</faultstring>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
SOAP is a message protocol in XML form that you can send over HTTP. Below
you tried to send an XML only over HTTP (which you can do if your server
knows what to do with it). So if you want to avoid developing a new
interface, the easiest would probably be to create the SOAP message that you
want to send in your VB code (look at the message that is sent from the
VB.Net app or the SOAP 1.0 spec for details on what the SOAP message format
needs to look like).
Best regards
Michael
<fhtapia@.gmail.com> wrote in message
news:1130949535.378275.277320@.f14g2000cwb.googlegr oups.com...
>I setup a soap webservice using sqlxml 3.0 on our IIS server, I can
> consume the webservice via "dotNET" but I am having a heck of a time
> trying to make a call out of a vba project. Currently I do not have
> the time to develope a new interface all in dotNET, thus the my need to
> try and post to the soap object from Access2003... another idea is to
> shell out to the vb.net app where I have the webservice working ... :|
> Dim http As Object
> Set http = CreateObject("Microsoft.XMLHTTP")
> http.Open "POST", "http://localhost/ws/report", False
> Call http.send("<SR =TEST /> ")
> Debug.Print http.responseText
> Set http = Nothing
> my response for this is:
> xmlns:xsd='http://www.w3.org/2001/XMLSchema'
> xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
> xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'
> xmlns:sqltypes='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types'
> xmlns:sqlmessage='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/SqlMessage'
> xmlns:sqlresultstream='http://schemas.microsoft.com/SQLServer/2001/12/SOAP/types/SqlResultStream'>
> <SOAP-ENV:Body>
> <SOAP-ENV:Fault>
> <faultcode>SOAP-ENV:Client</faultcode>
> <faultstring>Incorrectly formatted SOAP request</faultstring>
> </SOAP-ENV:Fault>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
|||Michael,
Thanks for your help on this, so what I need is a soap envelope... I
wish I could have ran into this documentation earlier on, I also
downloaded the "soap sdk" and utilized the trace utility in order to
capture my call and get the correct soap envelop as used by dotNet here
is my variation
request = "<?xml version='1.0' encoding='UTF-8' standalone='no'?>" &
_
"<SOAP-ENV:Envelope
xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>" & _
" <SOAP-ENV:Body>" & _
" <SR xmlns='http://Localhost/ws/Report'>" & _
" <XmlReport>'" & strXML & "'</XmlReport>" & _
" </SR>" & _
" </SOAP-ENV:Body>" & _
"</SOAP-ENV:Envelope>"
|||Glad to be of help.
Michael
"seeCoolGuy" <fhtapia@.gmail.com> wrote in message
news:1131046410.373083.163320@.g47g2000cwa.googlegr oups.com...
> Michael,
> Thanks for your help on this, so what I need is a soap envelope... I
> wish I could have ran into this documentation earlier on, I also
> downloaded the "soap sdk" and utilized the trace utility in order to
> capture my call and get the correct soap envelop as used by dotNet here
> is my variation
> request = "<?xml version='1.0' encoding='UTF-8' standalone='no'?>" &
> _
> "<SOAP-ENV:Envelope
> xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>" & _
> " <SOAP-ENV:Body>" & _
> " <SR xmlns='http://Localhost/ws/Report'>" & _
> " <XmlReport>'" & strXML & "'</XmlReport>" & _
> " </SR>" & _
> " </SOAP-ENV:Body>" & _
> "</SOAP-ENV:Envelope>"
>
Subscribe to:
Posts (Atom)