• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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