DSNless ODBC from Access 2000 database gets password not valid error

Giganews Newsgroups
Subject: DSNless ODBC from Access 2000 database gets password not valid error
Posted by:  hmye…@dartcontainer.com
Date: 21 Aug 2006

We have converted an Access 97 database to Access 2000 on an XP
machine.  The application uses a DSN-less connection:

adoConn1.Open "DRIVER={iSeries Access ODBC Driver};" & _
  "SYSTEM=SystemName;DBQ=LibraryName,Libraries;", sUserID, sPassword

This fails everytime with an error message saying "Password for
<sUserId> on server <SystemName> is not correct..."

The user enters their userid and password via a form created in the
Access 2000 database.  The password field has a Password mask applied.
The form also has the references checked for DAO 3.6 and ActiveX 2.6.

Anyone have ideas?

Thank you

Replies