[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • Last Modified:

How do I pass authentication information between Access and Iseries ODBC linked table?

I have a table linked from Microsoft Access to an Iseries file using the Iseries ODBC driver.  I then have an Access data access page that uses a query to display rows from the table.  I want to automate the authentication process to the Iseries.  I have tried to create a file DSN in the ODBC driver and then include UID/PWD information, but this does not seem to be working.  I also went into table design from Access and modified the table properties (description attribute), again no luck.    The table contains non-sensitive information, so I have no concerns over suppressing the need for the user to authenticate.
0
keykjexpert
Asked:
keykjexpert
  • 4
  • 2
1 Solution
 
coffeeshopCommented:
You can save the ODBC-Connection with User/Pwd to your query showing the data.
0
 
keykjexpertAuthor Commented:
Coffeeshop...please supply more details of your suggestion.  The ODBC connection dialogue allows me to store a userid under the 'connection options' parameter, but not the password.   And how is the Access query linked to the ODBC connection string?  I thought this was maintained in the linked tabled manager.
0
 
coffeeshopCommented:
You have 2 ways to save the passwort:

1) In the table: If you link a table (Files > External Data > Link Table) from your ODBC-Source, there is a Box "Save Password" at the Tablelist. Just tick this.

2) You can create a Pass-Through-Query: Add a new query, change it to SQL-specific > Pass-Through and add the connection in the properties. Here you can save your password too.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
coffeeshopCommented:
An addition: This is both done from Access and it is not necessary to save the User/Password at the ODBC-DSN.
0
 
keykjexpertAuthor Commented:
Thanks for the feedback.  I tried the 'save password' tick in the tablelist in the past, but the results were not stable.   I need to mention the query contains prompts so I need to stay away from the pass-thru query method.   Can you tell me where the connection string (UID/PWD) is stored when the 'save password' option is selected in the tablelist?   We may end up publishing this as a data access page so I need to clear where all the configuration components are stored.
0
 
coffeeshopCommented:
I don't know where the uid/pwd is saved for tables, I asume it's the intern tabledefinitions MSysObjects. What you can do is to create a pass-through query that delivers all data and set your queries to this instead of the table.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now