Skip to main content
T
TransoniqHacker
Inspiring
August 31, 2009
Question

Problem with Webservice after upgrading to cf8

  • August 31, 2009
  • 1 reply
  • 808 views

I have a webservice created in ColdFusion 6.1 that worked just fine when being called from MS Access. I upgraded coldfusion to v8, and now the webservice isn't working. Nothing else was changed. The strange thing is I can call the webservice from a flex program, I have used SoapUI, and that worked, I can type the webservice name into IE and get the correct return, but not from MSAccess or Excel.

Anybody know why this would be? Is there some setting that I forgot to check in the upgrade that would cause this sort of problem.

One thing I noticed when looking at the packets that were sent back and forth is that when connecting to the webservice from MSAccess, it looks like ColdFusion is trying to log into the web service definition. By that I mean, in the packet that is returned, I can see the HTML of the page in ColdFusion where you log in to view the webservice definition.

Matt

    This topic has been closed for replies.

    1 reply

    U
    Adobe Employee
    Umal Kumar
    Adobe Employee
    August 31, 2009

    Please let me know the OS version on which the CF 8 is installed and is it a 32 bit or a 64 bit OS?

    T
    TransoniqHackerAuthor
    Inspiring
    August 31, 2009

    We are running windows 2000 server (I know, I know, old as mold, but we're a government agency, what do you expect?) 32 bit. Antoher piece of the pie...

    After looking at the response closer, it looks like and extra line is being placed in there. For example, here is the response I am getting currently:

    <?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Body>
      <ns1:GetProp8Response soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://xxxx.xxxx.xxx">
       <GetProp8Return xsi:type="xsd:string">22923</GetProp8Return>
      </ns1:GetProp8Response>
    </soapenv:Body>
    </soapenv:Envelope>

    previously, it was similar to this:

    <?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Body>
      <ns1:GetProp8Response soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://xxxxxx.xxxxx.xxx">22923</ns1:GetProp8Response>
    </soapenv:Body>
    </soapenv:Envelope>

    Thanks for taking a look...

    Matt

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices