[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

Does any body uses Apollo 4.0 database engine?

Does any body uses Apollo 4.0 database engine? I have some questions to ask, please contact me or post a message so I can ask some questions.

Thanks.
0
davichoi
Asked:
davichoi
  • 2
1 Solution
 
williams2Commented:
That should not be a problem at all, if you have the proper drivers installed, you can access the specific database though the Intrbase engine.
0
 
davichoiAuthor Commented:
I am using Apollo 4.0 because it's small, about 300K, but with BDE engine it's too big.
0
 
williams2Commented:
Hmmm.. I've have had success (not with Apollo 4) with inserting the exact same parameters from the BDE-manager into the Database Objects params-strings. I can show you how I did with dBase, where I never configured a BDE-engine at first.

I don't know if this would be any help to you, but you may try configure your database like, but not exact this way:

    db1 := TDatabase.create(nil);
    db1.databasename := 'DBElev';
    db1.drivername   := 'INTRBASE';

    db1.params.clear;
    db1.params.add('SERVER NAME=C:\DBELEV.GDB');
    db1.params.add('USER NAME=SYSDBA');
    db1.params.add('OPEN MODE=READ/WRITE');
    db1.params.add('SCHEMA CACHE SIZE=8');
    db1.params.add('LANGDRIVER=');
    db1.params.add('SQLQRYMODE=');
    db1.params.add('SQLPASSTHRU MODE=SHARED AUTOCOMMIT');
    db1.params.add('SCHEMA CACHE TIME=-1');
    db1.params.add('MAX ROWS=-1');
    db1.params.add('BATCH COUNT=200');
    db1.params.add('ENABLE SCHEMA CACHE=FALSE');
    db1.params.add('SCHEMA CACHE DIR=');
    db1.params.add('PASSWORD=masterkey');

    db1.loginprompt  := false;
    db1.connected    := true;

    DBase:= TQuery.create(nil);
    DBase.databaseName:= 'DBElev';
    DBase.requestLive:= true


Good luck!

Cheers
Williams
0
 
glabaxCommented:
what do you want to know about apollo 4 ?
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now