ODBC and OLEDB with PAM support?
Richard Spitz
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
Martin Fuerderer
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 mailing list
> Inform...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
Richard Spitz
>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
Art S. Kagel (Oninit LLC)
> Martin Fuerderer <MART...@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
> Inform...@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
===========================================================================================
Fernando Nunes
> Richard Spitz wrote:
>> Martin Fuerderer <MART...@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...
Sheshnarayan Agrawal
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 <Richar...@med.uni-muenchen.de>
Sent by: informix-l...@iiug.org 23/01/2008 21:06 |
|