Enter a password to connect to a database in the script

[#1]

Hello everyone,

I want to extract data from an oracle database. The problem is that each time I need to reload my application, a prompt opens up and I have to manually enter this password. (which makes impossible any planifications)

Is there a way to write the password directly into the script ?

[alexandros17]

You can connect with ODBC , in this way you write the password in the connection only once and then use the connection name into your document

[#3]

Thank you for your answer Alessandro.

I already use an ODBC but it was configured in a way that I still need to enter the password each time. And I tried to change that but I didn't find how to do it.

That's why I was wondering if there was a way to enter it in the script.

[alexandros17]

Then use the conection string:

ODBC CONNECT TO [dbsomething;DBQ=DB00_APP.WORLD] (XUserId is Z1YSHSIRJJaSMVEVIXacA, XPassword is LcFPKXNGXDMcW33ZI2W);

obviously with your data

[#5]

Thank you

ODBC CONNECT TO [NameOfTheODBC;DBQ=NameoftheODBC](XUserId is MyUserID, XPassword is MyPassword);

But I still get the prompt..

[#6]

Check in the ODBC driver that the correct password is entered in there. As well as the one when you connect using the script.

When both passwords match it should work.

Regards,
Marius

[p_verkooijen]

Don't use ODBC CONNECT but CONNECT like

CONNECT TO Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;
Uid=myUsername;Pwd=myPassword;

This way you don't use a odbc dns but just the driver

[#8]

thanks Marius,

The thing is I can't see where in the odbc the password is entered ... (I'm not very comfortable with odbc )

I can see the User ID but I can't find the password... 😕  For example, when I click on "Test connection", a prompt opens up to ask me for the password.

thank you for your help

[#9]

Hi Laura,

Connect To Oracle Via ODBC Driver [Enterprise Architect User Guide]

In this link you will find a how to set up / manage an ODBC driver.

Regards,
Marius

[#10]

Hi Laura,

Here is a how to create / manage an ODBC Connection.

sparxsystems.com/enterprise_architect_user_guide/8.0/projects_and_teams/connect_to_oracle_via_odbc.html

Regards,

Marius