Web Development

Ask something
Discussion Locked

ODBC & passwords

0 helpful
13 replies

by jennifern

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have an Access app that uses an ODBC link to a SQLdb using Centura SQLBase 3.01 32bit driver NT/95.

SQLDb password is about to change, but I can't find where to change the password set in the ODBC setup.

Is the Hold/Release option anythingto do with this?

Before I arrived they tried to change the SQLdb password without success as it caused the ODBC link to fail.

13 replies

by jennifern

A useful doc to have. thanks (so I hate to give this an "unacceptabe" rating - but I have no choice).

But it only tells me what I know, which is the the UID is put in the UID field of the DSN setup. But it says it will prompt for a password, which it is currently not doing, as the application calling the ODBC connection runs an automatic update. So the Pwd must be stored somewhere - I just need to know where & how to change it.

by drinkin and thinkin

Try going to the ODBC Data Source Administrator, click the System DSN tab, select the DB you want to configure and click the Configure button, then the Advanced button. There should be fields there for username and password.

by jennifern

There should be, but there isn't! I think it's a feature of this particular ODBC driver.

Where I've got to now is:

The Config dialogue box allows me to specify a default user.
I am then prompted each time an ODBC call is made for the password.
On the db that I'm trying to work with, no password is prompted for when it makes this ODBC call. I cannot work out how this has been automated when it is not set in the ODBC configuration. I've looked through the VB project that drives thedatabase, but that seems to rely on the underlying Access database to make the connection to the external SQLdb.

by jennifern

No Where can I find it?

(don't mean this is a rejected answer, but I can't follow up it seems, without accepting/closing the q or rejecting... answer with comments next time... I'll still give you the points if it gets me there.

by jennifern

No, the drivers are installed as part of our HR software. It is not a centura cd installation. I've looked but can't find much of anything on the gupta site.

by neobrew

Try using RegEdit -- Look under HKCU or HKLM \Software\ODBC\ODBC.INI\dsn (where dsn is the data source name you are looking for). Under your datasource, you should see all sorts of string values, one being UID and another being PWD. UID is the user ID to log in, and PWD is the plain text password.

by rrv

A similar situation if you have linked tables with AS400. AS400 comes with a tool called Operation Navigator to manage AS400 client. As it is ADO standard 2.0 or above the client password may be cached in client but will not prompt. You have to set prompt everytime option of the database ADO connection object property. Then immediately restart the PC. Once restarted the passwords cached are cleared. If still did not work, open internet explorer properties, Content tab\Auto Complete buttonand remove "Cache user names, passwords" etc and click clear user names and passwords buttons. Restart the PC. Now your database while accessing the linked table should prompt you for password.

Good luck
RV

This discussion is closed to new replies.