IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

problem with method DoQuery (TaminoX) on Tamino v.4.4.1 db

  • 1.  problem with method DoQuery (TaminoX) on Tamino v.4.4.1 db

    Posted Wed January 17, 2007 04:43 PM

    Hi all!
    My VB6 application works fine with TaminoX.ocx on Tamino v.4.2.1 database but this is not true on Tamino v.4.4.1 db.

    This code for example:

    [size=“9”][color=“darkblue”][i]Public Function getCountByQuery(query As String) As Integer

    tobj.csDatabaseURL = mvarURLBase + mvarXMLColl

    Dim queryret As IXMLDOMDocument
    Set queryret = tobj.DoQuery(“count(” + query + “)”)

    getCountCollByQuery = queryret.getElementsByTagName(“xql:result”).item(0).nodeTypedValue

    End Function[/i][/color][/size]

    goes in run time error if database version is 4.4.1

    If I put this command:

    [size=“9”][color=“darkblue”][i]Public Function getCountByQuery(query As String) As Integer

    tobj.csDatabaseURL = mvarURLBase + mvarXMLColl

    Dim queryret As IXMLDOMDocument
    Set queryret = tobj.DoQuery(“count(” + query + “)”)

    MsgBox queryret.xml

    …[/i][/color][/size]

    then the message is:

    <?xml version="1.0" encoding="UTF-8"?>
    <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
    <ino:message ino:returnvalue=“8552”>
    <ino:messagetext ino:code=“INOXME8552”>Not a valid request</ino:messagetext>
    ino:messagelineThe command _xql(1,5) is not supported.</ino:messageline>
    </ino:message>
    </ino:response>

    On Tamino v.4.2.1 db,the function works fine and the message is displayed in the attach.

    Can you help me?
    Every help is appreciated, thanks in advance!

    Pam
    msgbox.bmp (210 KB)


    #webMethods
    #webMethods-Tamino-XML-Server-APIs
    #API-Management


  • 2.  RE: problem with method DoQuery (TaminoX) on Tamino v.4.4.1 db

    Posted Wed January 17, 2007 05:00 PM

    Which TaminoX.ocx are using?

    I suspect that if you are using the Tamino 4.2 OCX against a Tamino 4.4 DB you may get this error. Hopefully you will not get the error if you use the Tamino 4.4 OCX. I think that the Tamino 4.4 OCX should work correctly for both Tamino 4.2 + 4.4.


    #webMethods-Tamino-XML-Server-APIs
    #webMethods
    #API-Management


  • 3.  RE: problem with method DoQuery (TaminoX) on Tamino v.4.4.1 db

    Posted Wed January 17, 2007 05:18 PM

    TaminoX 4.4 ocx!!!

    Unfortunately such version seems to work exactly like the precedent.
    Have you any suggest?
    Thanks in advance,

    Pam


    #API-Management
    #webMethods-Tamino-XML-Server-APIs
    #webMethods


  • 4.  RE: problem with method DoQuery (TaminoX) on Tamino v.4.4.1 db

    Posted Thu January 18, 2007 11:05 AM

    Please check that HKEY_CLASSES_ROOT/CLSID/{E723849E-6B4D-11D3-8AC6-00500466D86F}/InprocServer
    points to the latest TaminoX.ocx.

    Looking at the code indicates that the old cursoring style should only be used for queries that are against a Tamino prior to 4.3 or in a 4.2 OCX.


    #webMethods-Tamino-XML-Server-APIs
    #API-Management
    #webMethods


  • 5.  RE: problem with method DoQuery (TaminoX) on Tamino v.4.4.1 db

    Posted Thu January 18, 2007 11:36 AM

    Hi Mark,
    You are right: the VB6 application was still aiming to the old ocx!

    Now I have stored the new one and it works very fine on db 421 and on db 441.

    Thank you very much for your precious help!!!

    Pam


    #webMethods
    #webMethods-Tamino-XML-Server-APIs
    #API-Management