Remember user and password of an Oracle ODBC connection

Asked

Viewed 1,515 times

0

I am connecting an Oracle database with an Access database through Oracle ODBC Driver 11.2.

The problem is that every time I access the base in Access, the driver from Oracle requests authentication:

Janela de solicitação de credenciais

Is there any way to remember the user and password?

I couldn’t find that option on driver oracle.

oracle ms-access odbc

2 answers

1


Here are two ways to solve this:

When creating the Tables link, have a checkbox "Save Login ID And Password Locally".

In the microsoft URL you have more information

Another way to solve this:

If you are using System DSN, you can edit the record to include the password that is stored without encryption (open text) in the following location:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<dsnname>\Password

  • There is some difference between using a System DSN or a User DSN ?

  • Yes. System dsn can be used by all system users. User dsn works only for the specific user. In the case of the user, the data is in the Current user.

-1

It asks for the password again because at the time you linked the table with Access you probably did not check the box to save the password, I believe that’s all.

Browser other questions tagged oracle ms-access odbc

You are not signed in. Login or sign up in order to post.