ODBC and OLEDB with PAM support?
Posted in 2008
Hi Informixers,
I'm just implementing our new database server running IDS 10.00.UC6 under
Linux (SLES 10 SP1). On our old system, we used NIS for user administration,
which worked just fine without any special configuration for Informix. The NIS
server is running on Windows domain controllers, and our domain admins
are urging me to get rid of NIS and use PAM with LDAP instead. I've been
successful configuring the OS login to use this method and can also connect
to the PAM-configured IDS instance using dbaccess locally and over the network
from Linux machines, but cannot get it to work from Windows machines with the
ODBC driver from Client SDK 2.90.TC4.
When I try to configure and verify a data source pointing to the pam_enabled
IDS instance, I get the following error message:
ERROR: -11060 : 37000 : [Informix][Informix ODBC Driver]General error.
Any ideas on how to get ODBC connections to work?
My next problem will be OLEDB which according to several sources does NOT
support PAM. I have a several apps written in VB6 that connect to IDS using
OLEDB. What can I do about them? Are there newer OLEDB versions available
that support PAM?
Regards, Richard