Passing XML DoubleQuotes to Sproc

[Lauren Quantrell]

I can pass the XML below to a sproc from within a vb.net application
but it doesn't work to the same sproc from an Access application.

I've tried massaging the double quotes without success. Any help is
appreciated.

lq

XML text:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<geonames style="FULL">
<totalResultsCo unt>3</totalResultsCou nt>
<geoname>
<name>South Pasadena</name>
<lat>34.1161196 </lat>
<lng>-118.1503488</lng>
<geonameId>5397 717</geonameId>
<countryCode>US </countryCode>
<countryName>Un ited States</countryName>
<fcl>P</fcl>
<fcode>PPL</fcode>
<fclName>city , village,...</fclName>
<fcodeName>popu lated place</fcodeName>
<population>249 94</population>
<alternateNam es/>
<elevation>20 1</elevation>
<adminCode1>C A</adminCode1>
<adminName1>Cal ifornia</adminName1>
<adminCode2>037 </adminCode2>
<adminName2>L os Angeles County</adminName2>
<timezone dstOffset="-7.0" gmtOffset="-8.0">America/Los_Angeles</
timezone>
</geoname>
</geonames>

[lyle]

On Jan 7, 5:42 pm, Lauren Quantrell <laurenquantr.. [e-mail]>
wrote:

I can pass the XML below to a sproc from within a vb.net application
but it doesn't work to the same sproc from an Access application.

I've tried massaging the double quotes without success. Any help is
appreciated.

lq

XML text:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<geonames style="FULL">
<totalResultsCo unt>3</totalResultsCou nt>
<geoname>
<name>South Pasadena</name>
<lat>34.1161196 </lat>
<lng>-118.1503488</lng>
<geonameId>5397 717</geonameId>
<countryCode>US </countryCode>
<countryName>Un ited States</countryName>
<fcl>P</fcl>
<fcode>PPL</fcode>
<fclName>city , village,...</fclName>
<fcodeName>popu lated place</fcodeName>
<population>249 94</population>
<alternateNam es/>
<elevation>20 1</elevation>
<adminCode1>C A</adminCode1>
<adminName1>Cal ifornia</adminName1>
<adminCode2>037 </adminCode2>
<adminName2>L os Angeles County</adminName2>
<timezone dstOffset="-7.0" gmtOffset="-8.0">America/Los_Angeles</
timezone>
</geoname>
</geonames>

Are you using a variable pointing to the string?
Are you using an ado command object and a parameter?
I believe that you will be successful if you do.

eg

With m
.ActiveConnecti on = CurrentProject. Connection
.CommandType = adCmdStoredProc
.CommandText = "StoredProcedur e2"
Set p = .CreateParamete r("@SomeString" , adVarChar, adParamInput,
2000, msXml.ResponseT ext)
.Parameters.App end p
End With

In this case, msXml.ResponseT ext points to the string.

[Lauren Quantrell]

On Jan 7, 9:14*pm, lyle <lyle.fairfi... @gmail.comwrote :

On Jan 7, 5:42 pm, Lauren Quantrell <laurenquantr.. [e-mail]>
wrote:

I can pass the XML below to a sproc from within a vb.net application
but it doesn't work to the same sproc from an Access application.

I've tried massaging the double quotes without success. Any help is
appreciated.

lq

XML text:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<geonames style="FULL">
<totalResultsCo unt>3</totalResultsCou nt>
<geoname>
<name>South Pasadena</name>
<lat>34.1161196 </lat>
<lng>-118.1503488</lng>
<geonameId>5397 717</geonameId>
<countryCode>US </countryCode>
<countryName>Un ited States</countryName>
<fcl>P</fcl>
<fcode>PPL</fcode>
<fclName>city , village,...</fclName>
<fcodeName>popu lated place</fcodeName>
<population>249 94</population>
<alternateNam es/>
<elevation>20 1</elevation>
<adminCode1>C A</adminCode1>
<adminName1>Cal ifornia</adminName1>
<adminCode2>037 </adminCode2>
<adminName2>L os Angeles County</adminName2>
<timezone dstOffset="-7.0" gmtOffset="-8.0">America/Los_Angeles</
timezone>
</geoname>
</geonames>

Are you using a variable pointing to the string?
Are you using an ado command object and a parameter?
I believe that you will be successful if you do.

eg

With m
* * .ActiveConnecti on = CurrentProject. Connection
* * .CommandType = adCmdStoredProc
* * .CommandText = "StoredProcedur e2"
* * Set p = .CreateParamete r("@SomeString" , adVarChar, adParamInput,
2000, msXml.ResponseT ext)
* * .Parameters.App end p
End With

In this case, msXml.ResponseT ext points to the string.- Hide quoted text -

- Show quoted text -

I see now. I was trying it with a declared string value:

Dim myWebServiceRet urn as string
Dim RS As Recordset
Dim mySprocName as string

myWebServiceRet urn =
FunctionNameTha tCallsWebServic eAsXMLString(pa rams)

Set RS = CurrentProject. Connection.Exec ute("EXEC " & mySprocName & "
'" & myWebServiceRet urn & "'")
Me.ComboBox.Row Source = RS.Source