Anyone had success with VB 2005 and ExecuteSql

[mackersaffiniti]

Hi All,

I have been playing around connecting to CM 5.1 and doing SQL queries via SOAP with VB 2005.

In a sniffer trace I can see that my envelope gets send to the CM at :

http:<ip address>/axl

but not matter what I do not get a response. I have a functions that acepts all certificates but still no joy. The CCM logs do not show anything so my code could be wrong. Just wondered if any one else had had sucess do this ?

Also all of Cisco docs say the schema is loacate at /axl/axlsoap.xsd is that right as I can never browser it.

,Mackers

[jmlacoste]

Hello,

you can find xsd definition from AXLDOC_504.ZIP located in http://www.cisco.com/cgi-bin/dev_support/access_level/product_support

Cisco Unified CallManager AXL-SOAP API Documentation - v5.0(4)

We do use VB but with C# we discovered that AXL SOAP request worked only in http 1.0 protocol version.

Rgds,

JML

[mackersaffiniti]

Hi JML,

Thanks for the advice I already had the schema from the SOAPTOOlkit but I just wondered why the soap envlope references it yet you can't actually reach.

Thanks for the pointer with the HTTP 1.0 (I have been using the MSXML2.HTTP60 call) I will give that a try tomorrow and let you know if it works.

Mackers,

[XmlEquals]

Hm... I've used .NET (C# though--but not like it should matter) to use executeSQLQuery and executeSQLUpdate just fine. I don't know what else is wrong...

[mackersaffiniti]

Hi All,

Ok I got around the pain in the rear end of issue if using HTTP 1.0 and I have defined a class that accepts all certificates, but as soon as I post the server terminates the socket which I see in the .Net traces:

Receive - An existing connection was forcibly closed by the remote host

I have treid keepalive no keepalive, proxy, no porxy ans still the result is the same.

I am using httpwebrequest woudl anybody be so kind to share some c# or Vb .net code with me, if you can send it to macker_s(at)hotmail(dot)com

Many thanks,

Mackers

[mackersaffiniti]

Hi All,

Still getting the same problem with the CM 5.1 terminating the socket, so for fun I thought why not try this against 4.2(x) and it works fine proving my program ans SOAP packet construction is fine.

Al I changed was

CallManager 5.1 - Not working

Dim HostAddress As New Uri(String.Format("http://" & TextBoxServer.Text & ":8443/axl"))

CallManager 4.2 - Works fine

Dim HostAddress As New Uri(String.Format("http://" & TextBoxServer.Text & "/CCMApi/AXL/V1/soapisapi.dll"))

So while I look into this has anyone else managed to make it work with Callmanager 5.1

Mackers,

[jmlacoste]

Hello,

in the 5.1 URL, It should be https ? Isn'it ?

Rgds,

JMLacoste

[mackersaffiniti]

Hi All,

Finally got it work for both !!!

Reason was I had defined

Dim objWebRequest As HttpWebRequest = httpWebRequest.Create(HostAddress)

When I changed this to

Dim objWebRequest As HttpWebRequest = WebRequest.Create(HostAddress)

It then worked fine which is odd because they both are meant to do the samething.

As for the URL in 5.1 it has to be

https://ServerAddress/axl/

Nothing else seems to work even using http and appending :8443 at the end.

As pointed out in the documenation now you also need to use HTTP 1.0 in the post.

Once I have added a little more polish (as in polish)to it I will post back to the form so you can all have a play and report any (bound to be issue)

Lesson learnt:

Current documentation sucks

,Mackers

[XmlEquals]

Just have to ask--is the AXL service running?

[mackersaffiniti]

Hi,

As I stated before it is all working now after I changed from HttpWebRequest to Webrequest.

:-) Yes the AXL service was running as when putting the URL in a browser it stated it was running and ready for a POST.

Just as an add on the combination of Network trcaing in .Net, Sniffer traces and the CLI sniffer capture on 5.1 is very useful fro tracking down such problems.

,Mackers

[XmlEquals]

Doh! Sorry, I missed that last post entirely...

[dseabury001]

I'm trying to develop an ASP.Net C# application to send a text message to a 7920. If I had a hard-coded example with variables for the message and the phone IP, I would be all set. I've tried working with the SDK and many searches on the Internet and have only managed to produce the directory listing of phones thus far. Also, need to know if there is any configuration required on CM 4.2 to allow my application to interact with it?

Thanx...