Question and Answer Database
FAQ85C.txt Accessing InterBase thru an AT service
Category :Database Issues
Platform :All
Product :C++Builder 1.x
Question:
I have an app that, thru BDE, updates an InterBase table.
From the command-line it runs fine. But if I try to run
it thru an AT service I get:
Error connecting to db: Unknown user name or password.
unavailable database. Alias: myalias
How can I make this work?
Answer:
First, as you are probably already doing, you need to
set the following properties on your Database object:
MyDatabase->AliasName = "myalias";
MyDatabase->LoginPrompt = false;
MyDatabase->Params->Add("USERNAME=SYSDBA");
MyDatabase->Params->Add("PASSWORD=masterkey");
Then, you will need to install BDE 4.0, the one that ships
with Delphi 3.0.
And finally, you will need to set the AT service to be
interactive, like:
AT 11:30 /INTERACTIVE c:\myexe
7/2/98 10:32:32 AM
Last Modified: 01-SEP-99