X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Access Odbc Passthrough Query Problem With Ibm Iseries (db2) And Multiple Systems    
post Jan 9 2020, 10:05 AM

Posts: 3
Joined: 1-July 18

Hi everyone,

So I am using some pass-through queries in Access connecting to our finance system via ODBC (IBM iSeries etc). The connection string looks like this:


So this works just fine for the first system. If I just open Access and run this query I'm prompted for login and password.

The problem is if I try to run another query that is connecting to another SYSTEM, then it's trying to use the previously saved connection rather than prompting me for a new username/password, even though the SYSTEM is specified to something else in the connection string.

The only work-around I have found is to restart Access, but that's obviously not a very good solution when you need to connect to some different systems.

Does anyone know of a way to get around this problem?

Thank you
Go to the top of the page
Start new topic
post Jan 9 2020, 10:19 AM

UA Admin
Posts: 37,239
Joined: 20-June 02
From: Newcastle, WA

Welcome to UtterAccess.

That is, indeed, the down side to Access caching of connections. Normally, that's a good thing because, once the connection is established, you don't have to repeat the credentials during that session. Here, of course, you need to use different credentials for different passthrus and the caching is not helpful.

Is it undesirable to create and SAVE the credentials for each passthru? In other words, does your security context require that you sign in each time you start Access, or could you work with stored credentials in the Access accdb?

My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    25th May 2020 - 04:38 PM