Mega Code Archive

 

Categories / Delphi / ADO Database

 

Accessing interbase thru an at service

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: