Re: ODBC Connections - Prompt for User ID and Password

The first time, it prompts the user for how to connect. It's likely your
single user didn't choose Kerberos. Check out the DOS commands at the end
of this IBM link and see if they help.
How to create IBM i connection objects in the ACS Windows Application
Package
<https://www.ibm.com/support/pages/how-create-ibm-i-connection-objects-acs-windows-application-package>

HTH


date: Mon, 19 Jun 2023 18:14:55 +0000

from: "Sizer, Joseph via MIDRANGE-L" <midrange-l@xxxxxxxxxxxxxxxxxx>
subject: ODBC Connections - Prompt for User ID and Password

I have a Word document that uses the Client Access (ACS) ODBC driver to
pull DB2 data in. The Word document is stored on a network drive and uses
a User DSN. Several people in the group use the Word doc. Only one person
in the group is required to enter their user ID and password each time they
access the document.

We have compared each user setup and they all appear to be set the same.
Yet only one user must provide credentials. They are set up in EIM
correctly and we are using Kerberos authentication. We are using ACS
version 1.1.8.7.

Does anyone have any other suggestions as to where to check for an ODBC
connection to the IBM i?

[cid:image003.jpg@01D9A2B8.6C052920]


Joe Sizer
IBM I Power9 Administrator
Pencor Digital Services

[PSI]
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
Office: 610.826.9080 Ext. 2117