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

, ,
1

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)

2

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.

3

TaminoX 4.4 ocx!!!

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

Pam

4

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.

5

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