Login defaults

[PRice]

How could I implement the last userid/database like P/L SQL Developer presents at startup?

Thanks,

PRice

 

[Marco Kalter]

You will need to explicitly implement this. You need to save the last successful login information, and set the TOracleSession Logon properties (LogonUsername & LogonDatabase) before calling TOracleLogon.Execute.

 

[PRice]

Okay, its being stored in the registry. What's the process of reading the binary data (encrypted?) back out into strings?

Thanks,

PRice

 

[PRice]

Nevermind, I see another post explaining it.

How the Retries property, how does it work with Execute? I'm only getting one try although Retries is set higher. Execute is being called in the datamodule's Create.

Thatnks,

PRice

 

[Marco Kalter]

Reties should work without a problem. Note that if Retries = 1, you get 2 attempts. Try the DeptEmp demo to verify the workings.

 

[PRice]

Okay, I set up the TOracleLogon the same as the demo. It still only allows one logon try.

We check for Connected both in the project and the datamodule create. If not Connected, the user doesn't get to the main form creation, so that's another difference from the demo.

Are there some other suggestions?

Thanks,

PRice

 

[Marco Kalter]

Does the demo work okay?

 

[PRice]

The dialog gives a message, returns according to the Retries property, then shows an empty main form. The empty main form isn't desirable for us.

Thanks,

PRice

 

[Marco Kalter]

What is the message?

 

[PRice]

with an invalid username/password entered:
ORA-01017 invalid username/password login denied

with no username/password/database entered:
ORA-12560 TNS: protocol adapter error

These are fine, and I'm not saying that it isn't working properly. I'm wanting to know how to get retries working from OnDatamoduleCreate so that the main form never displays after # of retries is exceeded.

Thanks,

 

[Marco Kalter]

Okay. After calling TOracleLogon.Execute, check Session.Connected. If it's not Connected, terminate the application.

 

[PRice]

Alright, it works now, thanks. There was some Session.OnChange code that was interfering with retries.