@thoa_nguyen99: "Do you know how I can set the SQLConnection at run time?
Thanks,
Emily
- posted by geoForum on <url>"
    @tmiller: "if (UpperCase(aBssSysInfo.DBType) = 'ORACLE') or
      (UpperCase(aBssSysInfo.DBType) = 'ORACLE8') then begin
     aSQLConnection.Connected := False;
     aSQLConnection.DriverName := 'Oracle';
     //=================  Core Lab Driver  ================
     {aSQLConnection.GetDriverFunc := 'getSQLDriverORA';
     aSQLConnection.LibraryName := 'dbexpoda.dll';
     aSQLConnection.VendorLib := 'oci.dll';
     aSQLConnection.AfterConnect := SQLConnectionAfterConnect;}
     //=================  Borland Driver  ================
     aSQLConnection.GetDriverFunc := 'getSQLDriverORACLE';
     aSQLConnection.LibraryName := 'dbexpora.dll';
     aSQLConnection.VendorLib := 'OCI.DLL';
     aSQLConnection.LoginPrompt := False;
     //aSQLConnection.Options := [coBcdToFmtBcd, coFloatIntegersToFmtBcd];
     //aSQLConnection.Options := [coBcdToFmtBcd];
     aSQLConnection.Params.Clear;
     if UpperCase(aBssSysInfo.DBType) = 'ORACLE' then begin
       aSQLConnection.Params.Add('DatabaseVendor=Oracle');
       end
     else begin
       aSQLConnection.Params.Add('DatabaseVendor=Oracle8');
     end;
     aSQLConnection.Params.Add('DriverName=Oracle');
     aSQLConnection.Params.Add('AutoCommit=True');
     aSQLConnection.Params.Add('BlockingMode=True');
     aSQLConnection.Params.Add('BlobSize=32');
     aSQLConnection.Params.Add('Multiple Transaction=True');
     aSQLConnection.Params.Add('Oracle TransIsolation=ReadCommited');
     aSQLConnection.Params.Add('OS Authentication=False');
     aSQLConnection.Params.Add('RowsetSize=350');
     aSQLConnection.Params.Add('Trim Char=False');
     // Security
     aSQLConnection.Params.Add('DataBase=' + aBssSysInfo.DBAlias);
     aSQLConnection.Params.Add('User_Name=' + 
aModuleSecurityInfo.LoginName);
     aSQLConnection.Params.Add('Password=' + 
aModuleSecurityInfo.LoginPassword);
   end;  // End Oracle / Oracle8
<quote>
Thomas Miller
Chrome Portal Project Manager
Wash DC Delphi SIG Chairperson
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
<url>
<url>
<url>
<url>
<url>"
    @not: "<quote>
If the previous reply looks daunting, try checking out the 
TSQLConnection.LoadParamsFromIniFile method.
David Cornelius
<url> "
{'source': 'USENET', 'other_information': '{"reply_count": 2, "forum_name": "borland.public.delphi.database.dbexpress.20140711.mbox"}', 'file': 'data/output/usenet-borland.public.parquet'}