Problems Powerhouse WEB and CONNX

[VAN DE MEERSSCHE Marc]

>Hi, 
>
>Since we made an upgrade from ODBC CONNX 6.5 to CONNX 9, we encountered
>problems with SELECT's containing generic characters. 
>
>Our application is written in Cognos POWERHOUSE 8.23 and rurns with
>PowerHouse Web 2.21 on a IIS server. 
>An ODBC-connection to an ALPHA OpenVMS 6.2.1.H.3 is made with CONNX9.
>
>Unfortunatly, on a search containing a wildcard character (ex: SELECT NAME
>FROM TABLENAME WHERE NAME like "CONNX%"), we got all the lines where the
>name begins with CONNX, but not the lines where the names are exactly equal
>to CONNX.
>
>After the attempts which we carried out: 
>- in CONNX 6.5 and PHWeb: the problem does not occur.
>- in CONNX 9 and PHWeb: the problem occurs. 
>- IN CONNX 9 with CONNX Infonaut: the problem does not occur.
>
>Does anyone has already the same problem ?
>
>Regards,
>Marc Van de Meerssche
>Nationale Suisse Insurances, Belgium
>
>PS: We have verified if the problem also occurs with PowerHouse 8.41, and
>the problem is identical with the old version. 
>
>  
>