Authentication and Commit questions

[pcerdaz]

Hi, I'm migrating from Paradox to InterBase and there is a lot
of advance, however I have two questions:
1. Why my application is not asking me for Commit to made
changes over tables? I need to modify the adecuate property to
manage both Commit and Roolback; these are two importante
characteristics that like me to change to InterBase.
2. Any time when I start my application I must to authenticate
with valid username and password to Interbase. How can I step
over this authentication process?

Thank you,
pcerdaz

[Antonio Felix]

Post by pcerdaz
Hi, I'm migrating from Paradox to InterBase and there is a lot
1. Why my application is not asking me for Commit to made
changes over tables? I need to modify the adecuate property to
manage both Commit and Roolback; these are two importante
characteristics that like me to change to InterBase.
2. Any time when I start my application I must to authenticate
with valid username and password to Interbase. How can I step
over this authentication process?
Thank you,
pcerdaz

Hi,

1. Use the TIBTransaction component to control the actions,
Commit or Rollback. This is something that you need to control
yourself.

2. You may use the TIBDatabase Params property to feed in
the Login Information:

...
TIBDatabase *IBDb;
...
IBDb->Params->Add("user_name=YourUSer");
IBDb->Params->Add("password=YourPw");
IBDb->Params->Add("lc_ctype=ISO8859_1");
IBDb->DatabaseName = "Your Database Name;
IBDb->Open();
....

Also set the LoginPrompt of TIBDatabase to false

HTH
Antonio