Re: ODBC and OLEDB with PAM support?

Informix OLEDB doesn't support PAM (there is no callback mechanism). ODBC does support by registering your callback function using SQLSetConnectAttr() call. The problem you are facing seems to be CQ idsdb00036624 which has been addressed. You can ask your Tech support to get the patch OR use the CSDK 3.00 mentioned below. For more information on PAM support in ODBC please refer the ODBC Programmer's Manual. You can download the CSDK 3.00 from the below link. You will see "Informix CSDK Downloads" listed on right bottom corner. http://www-306.ibm.com/software/data/informix/tools/csdk/ -Shesh Richard Spitz <Richard.Spitz@med.uni-muenchen.de> Sent by: informix-list-bounces@iiug.org 23/01/2008 21:06 To informix-list@iiug.org cc Subject ODBC and OLEDB with PAM support? 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 _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list