03/23/2004 04:42:35 PM
Hello,
I am experiencing problems retreiving an XML result set via Microsoft's XMLA web service. I believe the problem is with coldfusion because of the nature of the error:
First the error:
Cannot convert from COM VT 16387 to Java type: class java.lang.String
Here is CFM page:
<HTML>
<CFOBJECT action = "CREATE" class = "SoapXML.clsXmlDataAccess" NAME = "g_XmlDataAccess" TYPE ="COM">
<cfset g_XMLDataAccess.URL = "
<CFSET g_xmlDataAccess.catalog = "NCA">
<CFSET m_strCurrentURL = #g_XMLDataAccess.URL#>
<CFSET g_xmlDataAccess.dataSourceInfo = "Local Analysis Server">
<CFSET strResults = #g_xmlDataAccess.executequery("select {[Measures].members} on 0 from sales",1)#>
</HTML>
The error occurs at the very last line (above the </HTML> tag).
I successfully ran the equivilant code in Visual Basic so I feel confident that the Com object is working per spec. The return string is about 13,000 characters long, so it should "fit" into a standard string variable in coldfusion I beleive. Also, when I change the "select" clause in the executeQuery method to something that is invalid, a different error raises which is a good sign that the COM object is returning something to coldfusion.
Any help would be greatly appreciated.
Thanks
Hello,
I am experiencing problems retreiving an XML result set via Microsoft's XMLA web service. I believe the problem is with coldfusion because of the nature of the error:
First the error:
Cannot convert from COM VT 16387 to Java type: class java.lang.String
Here is CFM page:
<HTML>
<CFOBJECT action = "CREATE" class = "SoapXML.clsXmlDataAccess" NAME = "g_XmlDataAccess" TYPE ="COM">
<cfset g_XMLDataAccess.URL = "
<CFSET g_xmlDataAccess.catalog = "NCA">
<CFSET m_strCurrentURL = #g_XMLDataAccess.URL#>
<CFSET g_xmlDataAccess.dataSourceInfo = "Local Analysis Server">
<CFSET strResults = #g_xmlDataAccess.executequery("select {[Measures].members} on 0 from sales",1)#>
</HTML>
The error occurs at the very last line (above the </HTML> tag).
I successfully ran the equivilant code in Visual Basic so I feel confident that the Com object is working per spec. The return string is about 13,000 characters long, so it should "fit" into a standard string variable in coldfusion I beleive. Also, when I change the "select" clause in the executeQuery method to something that is invalid, a different error raises which is a good sign that the COM object is returning something to coldfusion.
Any help would be greatly appreciated.
Thanks