Re: ODBC and OLEDB with PAM support?

Hi, to my knowledge PAM is not supported with OLEDB. (Whereas ODBC should be possible.) But as I'm not an expert in the fields of ODBC and OLEDB, I'm not sure what possible workarounds there are (like using the password mode rather than the challenge mode might be OK for the OLEDB clients??). Sorry, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland GmbH Chairman of the Supervisory Board: Hans Ulrich Märki Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael Diemer Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart, HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940 informix-list-bounces@iiug.org wrote on 23.01.2008 16:36:32: > 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

Martin Fuerderer <MARTINFU@de.ibm.com> schrieb: >I'm not sure what possible workarounds there are (like >using the password mode rather than the challenge mode >might be OK for the OLEDB clients??). Right, I'm using the password mode, so no callback function is necessary. That's why I hope to be lucky even with OLEDB. Further research has revealed that the "general error" I am seeing is a known defect in CSDK 2.90.TC4 (APAR IC49711) and is fixed in CSDK 2.90.TC6R1. However, all my attempts to download this from the IBM website have failed so far. Where can I download this version (or even a newer version) of the CSDK (and I-Connect) for Windows XP? Regards, Richard

Richard Spitz wrote: > Martin Fuerderer <MARTINFU@de.ibm.com> schrieb: > > >> I'm not sure what possible workarounds there are (like >> using the password mode rather than the challenge mode >> might be OK for the OLEDB clients??). >> > > Right, I'm using the password mode, so no callback function is necessary. > That's why I hope to be lucky even with OLEDB. > > Further research has revealed that the "general error" I am seeing is > a known defect in CSDK 2.90.TC4 (APAR IC49711) and is fixed in > CSDK 2.90.TC6R1. However, all my attempts to download this from the > IBM website have failed so far. > > The current release of the CSDK is 3.00. You should be able to download it from the IBM eval site as well as from PA. Art S. Kagel Oninit > Where can I download this version (or even a newer version) of the CSDK > (and I-Connect) for Windows XP? > > Regards, Richard > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > =========================================================================================== > Please access the attached hyperlink for an important electronic communications disclaimer: > > http://www.oninit.com/home/disclaimer.php > > =========================================================================================== > > =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================

Art S. Kagel (Oninit LLC) wrote: > Richard Spitz wrote: >> Martin Fuerderer <MARTINFU@de.ibm.com> schrieb: >> >> >>> I'm not sure what possible workarounds there are (like >>> using the password mode rather than the challenge mode >>> might be OK for the OLEDB clients??). >>> >> >> Right, I'm using the password mode, so no callback function is necessary. >> That's why I hope to be lucky even with OLEDB. >> >> Further research has revealed that the "general error" I am seeing is >> a known defect in CSDK 2.90.TC4 (APAR IC49711) and is fixed in CSDK >> 2.90.TC6R1. However, all my attempts to download this from the >> IBM website have failed so far. >> >> > > The current release of the CSDK is 3.00. You should be able to download > it from the IBM eval site as well as from PA. > > Art S. Kagel > Oninit > >> Where can I download this version (or even a newer version) of the CSDK >> (and I-Connect) for Windows XP? >> >> Regards, Richard Anyway... If you configure the system to use PAM and use Informix traditional configuration it should work... By analogy, you didn't have IDS configured for NIS...