Re:IB app installation
Quote
"Frost Sheila" <OldMas...@gmx.de> wrote in message
news:3BBABEEF.4020500@gmx.de...
Quote
> Lynn Pye Jr. wrote:
> > Hi all,
> > I have an Interbase client application which I would like to distribute
and
> > which I expect to have a userbase who is a) not generally knowledgeable
> > about computer administration and b) can't or won't generally make the
> > attempt to pay for a full time system administrator. As a result, I have
to
> > provide a simple way to install not just the client but the server as
well.
> > The tricky part for me is the database data files, as I have come up
with a
> > "satisfactory" resolution for installing the client and server parts. So
my
> > question is how does one generally create a database the first time
without
> > requiring the user to start IBConsole or run separate scripts? Is there
a
> > way to use a TIBQuery or similar IBX component to issue commands to the
> > Interbase server in general without having had to connect to a specific
> > database (i.e. I'm trying to create a database)?
> > Thanks for any help,
> > Lynn Pye
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001
> This Code does it for me C-Builder
> try{
> IBDatabase1->DatabaseName = "D:\\Own\\abc.gdb";
> IBDatabase1->Params->Clear(); // clear Old params !!! ...
> IBDatabase1->Params->Add("USER \"sysdba\"");
> IBDatabase1->Params->Add("PASSWORD \"masterkey\"");
> IBDatabase1->Params->Add("PAGE_SIZE 4096");
> IBDatabase1->CreateDatabase();
> }catch(Exception &exc){
> ShowMessage(exc.Message);
> }
> After execution there the new Database abc.gdb exists.
> Gr?e
I have opted to use this approach. A test worked for me. In addition, I was
able to use the isc_add_user() function to subsequently add a user. As a
result, I now have my automated approach for creating a table and creating a
user during installation.
Thanks, everyone, for your help.
Regards,
Lynn Pye
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.282 / Virus Database: 150 - Release Date: 2001/09/25