Re: back-sql - SQLConnect() failed

[Pierangelo Masarati <ando@sys-net.it>]

Your problem should be with iODBC configuration;
you should check the documentation of that package
to find out what's wrong exactly.

Pierangelo.

Alex G Robertson wrote:
> Hi all,
>
> I'm trying to use ldap + mysql , but i've got some errors ...
>
> slpad -d 1
> ....
> backsql_open_db_conn: SQLConnect() to database 'scientia' as user 'root'
> failed:
> Return code: -1
> Native error code: 0
> SQL engine state: IM002
> Message: [iODBC][Driver Manager]Data source name not found and no
> default driver specified. Driver could not be loaded
> backsql_get_db_conn(): could not get connection handle -- returning NULL
> backsql_db_open(): connection failed, exiting
> backend_startup: bi_db_open(0) failed! (1)
> slapd shutdown: initiated
> ==>backsql_db_close()
> ....
>
> My slapd.conf .....
> ....
> #######################################################################
> # sql database definitions
> #######################################################################
>
> database        sql
> suffix          "o=scientia"
> rootdn          "cn=manager,o=scientia"
> rootpw          secret
> dbname          scientia
> dbuser          root
> dbpasswd        mypass
> subtree_cond    "ldap_entries.dn LIKE CONCAT('%',?)"
> insentry_query  "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval)
> VALUES (?,?,?,?)"
>
> what can i do to stop this error?
>
>
> Thanks in advance.
>
> Alex Robertson
> NOC - Microlink



--
Dr. Pierangelo Masarati         mailto:pierangelo.masarati@sys-net.it
LDAP Architect, SysNet s.n.c.   http://www.sys-net.it

+-----------------------------------------------------------------------------+
|The receiver  of this message is required to check if  he/she has received it|
|erroneously.  If  so,  the  receiver  is  requested to immediately inform the|
|sender and - in consideration of the responsibilities  arising from undue use|
|and/or disclosure of the message  and/or  the information contained therein -|
|destroy the original message and any copy or printout thereof.               |
+-----------------------------------------------------------------------------+