Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    as/400 ODBC Connection (Access 2002)

    I have an ODBC connection to our AS/400 database. It seems to be working OK, but I cannot get the "save password" option to function properly when linking to tables. I check the "save password" option, but it doesn't seem to have any effect and always has me log into the 400 for each query call. It was a pain to have to logon each time I ran one of my reports, but I just wrote my first report (for this system) with 2 nested queries and I have to logon 3 separate times for the report to run! We have definitely jumped from "pain" to "decidedly unacceptable". Anyone else have this issue? Is there a workaround?

    The only thing that I've found on the IBM site is a reference to Oracle, stating that the Oracle ODBC connector will not retain passwords and that this is a problem with Access.

    And while I'm here, for those of you with AS/400 to Access experience: A file-based DSN fails when reading data from the 400; IBM documentation says to use a machine-based DSN. Does anyone know of a workaround to make a file-based DSN work properly???

    <font color=white>By the way, I love the speed of the "new" site!!!</font color=white>

  2. #2
    Star Lounger
    Join Date
    Sep 2003
    Location
    Ocean Gate, New Jersey, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: as/400 ODBC Connection (Access 2002)

    Randall,

    I have experienced your "save password" problem also. I first experienced this "pain" after upgrading to Win XP and then the administrator changing the ODBC password. My password always reverts back to the original password which then i need to log in with the new correct one (MAJOR PAIN).

    Good post though and I'll be following this one.

    I'll be watching this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •