Re: Excel ODBC connections

I don't know if this is it, but try this:

Go to iSeries Navigator (IBM i Navigator? System i Navigator?), right-click on the system you are connecting to, select Properties from pop-up menu.

Go to Connection tab, "Signon Information" panel. There are four options:

- Use Windows user name and password, no prompting
- Use default user ID, prompt as needed
- Prompt every time
- Use Kerberos principal name, no prompting

So maybe your dev / prod machines have different options for the Signon Information option.

Craig Pelkie


----- Original Message ----- From: "Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Saturday, July 17, 2010 7:13 AM
Subject: Excel ODBC connections

I've been working with ODBC connections in Excel spreadsheets and they
work really great. I can set up a list of values, use those cells to
populate a table using a "SELECT ... WHERE FIELD IN (?,?,?)" construct
and then get the data back into my original table using VLOOKUP. It all
works fantastic except that I'm being prompted for user ID and password
every time I change a value (essentially every time I do a new ODBC
request). What's really strange is that the prompting only occurs on
the production machine, not on the development machine.

Does anyone know what controls the ODBC connection persistence? On the
development machine, is it connecting every time but with cached user ID
and password, or is it somehow keeping the connection up? How do I
control it? And how would you go about diagnosing it?

Joe
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.