[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