MS Access and Informatica ODBC saving credentials RRS feed

  • Question

  • I am using Informatica ODBC client 10.1.1. I wanted to link to a table in MS Access with it. It connects fine and I can run queries, however when I select "Save Password" it does not actually save the password. Has anyone else experienced this? It only seems to occur when connecting to Informatica. Other ODBC clients (like Oracle), MS Access does save the password.
    Wednesday, October 24, 2018 1:58 AM

All replies

  • Whether you can save the credentials or not depends on the ODBC driver, not on Access. So you should ask the driver vendor.

    The only things you can try:

    1. Create a user DSN with saved credentials.

    2. Store the the credentials in a secure manner (which his pretty hard) and create a query per code using this credentials before accessing your tables. Then the connection gets normally pooled and you can reuse it.

    Sunday, October 28, 2018 1:02 PM