UtterAccess.com
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    
 
   
Derevon
post Jan 9 2020, 10:05 AM
Post#1



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:

ODBC;DRIVER={iSeries Access ODBC Driver};TRANSLATE=1;SYSTEM=XXXXX

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
Replies
GroverParkGeorge
post Jan 9 2020, 10:19 AM
Post#2


UA Admin
Posts: 36,964
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    29th March 2020 - 05:32 PM