General discussion

Locked

ODBC & passwords

By jenniferN ·
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.

This conversation is currently closed to new comments.

13 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

ODBC & passwords

by M.A. Durkee In reply to ODBC & passwords

Have a look at this document:


http://www.guptahosting.com/support/books/dba.pdf

Should be page 10-3 or so, under the heading ODBC Administration.

This might help get you in the right direction -

Best of luck,

Collapse -

ODBC & passwords

by jenniferN In reply to ODBC & passwords

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.

Collapse -

ODBC & passwords

by drinkin and thinkin In reply to ODBC & passwords

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.

Collapse -

ODBC & passwords

by jenniferN In reply to ODBC & passwords

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.

Collapse -

ODBC & passwords

by drinkin and thinkin In reply to ODBC & passwords

Have you tried the Centura Connectivity Administrator?

Collapse -

ODBC & passwords

by jenniferN In reply to ODBC & passwords

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.

Collapse -

ODBC & passwords

by drinkin and thinkin In reply to ODBC & passwords

It should be on the Start menu... START>PROGRAMS>CENTURA

Collapse -

ODBC & passwords

by jenniferN In reply to ODBC & passwords

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.

Collapse -

ODBC & passwords

by drinkin and thinkin In reply to ODBC & passwords

OK... do you have SQLTALK.EXE somewhere on your machine?

Collapse -

ODBC & passwords

by drinkin and thinkin In reply to ODBC & passwords

Hey... it finally gave me a link to add a comment :-)

Back to Web Development Forum
13 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums