Back-SQL / Oracle problem - Bind variables?

[Daniel Riek <riek@de.alcove.com>]

Hi,

I could not find anything about this...

I am trying to install a OpenLDAP 2.0.27 on a Red Hat 7.2 as a frontend
to a Oracle 8.1.7 using unixODBC and the proprietary Easysoft driver.

Now there seems to be a problem with the bind variables used in the
subtree select.

When I set the configruation to 

subtree_cond "UPPER(ldap_entries.dn) LIKE CONCAT('%',UPPER('ou=applvl,dc=domain'))"

I get the entries, while with the correct

subtree_cond    "UPPER(ldap_entries.dn) LIKE CONCAT('%',UPPER(?))"

I do not get anything.

The debugging information from OpenLDAP as well as a database trace on
the Oracle server suggest, that the variables are transmitted correctly.

The RCs of the SQLprepare, the execute and the BindRowsAsStrings calls
are SUCCESS. Only the Fetch returns a 100 (no data).

I am now a bit lost. It seems not to be a configuration error or an
OpenLDAP-Problem, but I am not sure. In a similar configuration with
MySQL I had no problems and a test with the OpenLDAP test database shows
the same behaviour..

Anyone ever seen that problem? Any hints?

Thanks in advance and best regards.

Daniel


-- 
Daniel Riek <riek@de.alcove.com>   -    http://www.alcove.com/de/
* Technical Manager                -    Tel.:   +49 (0)2 28 / 9 08 69 85
* ALCOVE Deutschland GmbH          -    Fax:    +49 (0)2 28 / 9 08 69 84
* Liberating Software              -    Mobil:  +49 (0)1 71 / 2 80 08 79

-- 
Daniel Riek <riek@de.alcove.com>   -    http://www.alcove.com/de/
* Technical Manager                -    Tel.:   +49 (0)2 28 / 9 08 69 85
* ALCOVE Deutschland GmbH          -    Fax:    +49 (0)2 28 / 9 08 69 84
* Liberating Software              -    Mobil:  +49 (0)1 71 / 2 80 08 79