Re: [Iodbc-applications] Problem Iodbc

[Tim H. <th...@op...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

INF. Sec. Ingeniería (Rodolfo Farias Munoz) wrote:

| I have a big problem, because I can't to do work Openldap with backend
| postgresql.
|
| I'm actually working with freebsd 5.2.1, OpenLdap 2,  PostgreSQL 7.2 and
| iODBC
|
| when start Ldap the log writed this:
|
| backsql_open_db_conn: SQLConnect() to database "test" as user "test" failed:
| Return code: -1
|    Native error code: 201
|    SQL engine state:  IM002
|    Message:           Missing server name, port, or database name in call to
| CC_connect.
| backsql_get_db_conn(): could not get connection handle -- returning NULL
| backsql_db_open(): connection failed, exiting
| backend_startup: bi_db_open failed! (1)
[]

Hi,

As previously requested on the list, could you state what version of iODBC
you're using?

I think what's happening is that the postgresql ODBC driver is looking in
~/.odbc.ini or ./.odbc.ini for its parameters, and failing to find the file
- - it does not respect the ODBCINI environment variable. Hence, it's not
finding the file, nor the DSN, and so all the servername / database / port
parameters are getting lost. From an inspection of the source, it looks at
the last field in /etc/passwd to get the home directory.

As such, could you create a ~/.odbc.ini file in the home-directory of the
user as which slapd is running?

It would also be a useful test if you could su -  to that user and confirm
whether iodbctest (or iodbc-odbctest if using FreeBSD's packages) will
connection; then we'll know if there's a problem with iodbc in general or
just ldap and beyond.

HTH,

~Tim
- --
Tim Haynes
Product Development Consultant
OpenLink Software
<http://www.openlinksw.com/>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (Darwin)

iD8DBQFBpKRo+gVZmutkHqERAlRpAKCtgAnx8HPw0KEv2CdNK22b/jN8CwCgh0hm
HP3jEfzTHzJbVwRzSEundv4=
=/1VA
-----END PGP SIGNATURE-----