ODBC and OLEDB with PAM support?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Spitz - 23 Jan 2008 15:36 GMT

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

Reply to this Message

Martin Fuerderer - 23 Jan 2008 17:06 GMT

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,
>
[quoted text clipped - 25 lines]
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

Reply to this Message

Richard Spitz - 23 Jan 2008 17:21 GMT

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

Reply to this Message

Art S. Kagel (Oninit LLC) - 23 Jan 2008 17:35 GMT

> Martin Fuerderer <MARTINFU@de.ibm.com> schrieb:
>
[quoted text clipped - 13 lines]
>
>

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?
[quoted text clipped - 14 lines]
>
>

===========================================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.oninit.com/home/disclaimer.php

===========================================================================================

Reply to this Message

Fernando Nunes - 24 Jan 2008 00:02 GMT

>> Martin Fuerderer <MARTINFU@de.ibm.com> schrieb:
>>
[quoted text clipped - 24 lines]
>>
>> 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...

Reply to this Message

Sheshnarayan Agrawal - 24 Jan 2008 11:57 GMT

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

Reply to this Message