[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: Back-SQL / Oracle problem - Bind variables?
Hi,
OK, it's obviously a problem with the Easysoft driver in that
environment. Using the (according to the website incomplete) driver from
http://fndapl.fnal.gov/~dbox/oracle/odbc/ it works.
One more hint on using Oracle as a backend: at least in our environment
UID is a reserved word inside Oracle. So it has to be put in '"'.
Regards,
Daniel
On Tue, May 20, 2003 at 10:28:34AM +0200, Daniel Riek wrote:
> 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
>
>
--
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