Re: back-sql

["Lukman W. Kusuma" <lukman@commverge.com>]

Dear Dmitry,

I have tried once OpenLDAP to Oracle8i with OpenLink ODBC driver. I knew it almost
work because my Oracle listener log the connection from LDAP, but I can't resolve
one issue. The OpenLink driver couldn't get the result set from Oracle.

Till now, I am still stuck there. Even with OpenLink support. I gave up.
Any other ODBC driver that I can use?  There should be something else I can try to
make this work.

I am using COL eServer 2.3 , OpenLDAP 1.2.11 & Oracle 8.1.5 for Linux.

Please advice me.

Thanks

Lukman

Dmitry Kovalev wrote:

> Just a cc to openldap-software to close the issue...
>
> Peter Duffy wrote:
>
> > Hi Dmitry,
> >
> > Thanks for getting back to me. As you suggested, I tried iodbc 2.50.3
> > and
> > it worked: the make completed successfully.
> >
> > Thanks for the tip about this: I will try to trace what's gone on
> > between the two releases of iodbc that cause it to trip up with the
> > other one. (I'm still a bit baffled that 2.50.22a is earlier than
> > 2.50.3: they must have a very strange version-naming convention.)
> >
> > Thanks again for your help: much appreciated.
> >
> > Regards,
> > Peter
> >
> > Dmitry Kovalev wrote:
> > >
> > > Peter Duffy wrote:
> > >
> > > > Hi Dmitry,
> > > >
> > > > I posted a note about this problem to the openldap-software list last
> > > > week, but so far haven't had any feedback about it, so I decided to
> > > > e-mail you direct: sorry if it's an FAQ or something trivial that I've
> > > > missed.
> > >
> > > Sorry for long delay, but I've been out for 10 days, and had no access to
> > > the net...
> > > I will review your issue ASAP, and post an answer there, meanwhile I have
> > > some suggestions on the following:
> > >
> > > >
> > > >
> > > > I've been trying to build OpenLDAP 2.0-gamma with the back-sql backend:
> > > > I keep hitting a problem where the files sql.h and sqlext.h (included
> > > > from /servers/slapd/back-sql/sql-types.h) can't be found.
> > > >
> > > > I'm building on redhat 6.2 with kernel 2.2.14-5.0, and the database is
> > > > mysql 3.22.32 and iodbc 2.50.22a. I've hunted through all the source
> > > > trees and can't locate sql.h and sqlext.h anywhere (I ***have*** found
> > > > isql.h and isqlext.h in the iodbc source.)
> > >
> > > I think the problem is with your old version of iODBC... I personally used
> > > 2.50.3 and 3.0.2 to test, and I recall that
> > > I saw something about renaming isql to sql in their changelog... If it is
> > > the problem, then post a followup to your ITS, and we will close it, if
> > > not - we'll proceed ;)
> > >
> > > >
> > > >
> > > > I'd be really grateful for any assistance.
> > > >
> > > > Regards,
> > > > Peter
> > >
> > > Sorry again for long delay,
> > >
> > > WBW, Dmitry