By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

DSNless ODBC from Access 2000 database gets password not valid error

P: n/a
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
<sUserIdon server <SystemNameis 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

Aug 21 '06 #1
Share this Question
Share on Google+
2 Replies

P: n/a
Do you know what the project is connecting to? It sounds like some sql
db. You need to specify what your project is trying to connect to. Can
the Access97 application still connect to the back end? If you can
still reach the back end from the Access97 App then you can find out
what you are trying to connect to. You need to know this first. Then
we can work on the correct connection string.


*** Sent via Developersdex ***
Aug 21 '06 #2

P: n/a
Sorry I am getting back so late. I forgot I posted this question.

I figured out that when we converted the Access database, the field
with the mask of "********" had been the culprit. Apparently, the
..Text property of the field was being passed to the connection as
"********" instead of the actual password. I had to change using the
..Text property to the .Value property.

Sep 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.