🚀 go-pugleaf

If you intend to use the TDatabase component, just have the user input the
server name (Oracle SQL Net alias), user name and password and add the three
params to the TDatabase Params property.  Something like
  
  Database1->Params.Clear();
  Database1->Params->Add("Server Name=" + SeverName);
  Database1->Params->Add("User Name=" + UserName);
  Database1->Params->Add("Password=" + Password);
  Database1->Connected = true;


Please turn off the HTML posting on your newsreader.  This goes against
newsgroup guidelines.  Thnak you.

> Yunki Paik wrote:
> 
> My application has to check the connectivity from the host PC to several
> Oracle
> instances on various machines.
> I plan to use TDatabase object for the job.
> 
> What I am wondering is: since we don't know the database information during
> application installation, I will have to configure the BDE during runtime.
> i.e.,
> enter alias name and others.
> 
> Can some one advise me on the technique?
> My guess is that BDE config file is kept in a text file. Or, is it in a
> registry?
> 
> Thank you so much!
> 
> /yunki
> 

-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
Mild mannered supermen are held in kryptonite, and the wise and foolish
virgins giggle with their bodies glowing bright.  Through the door a harvest
feast is lit by candlelight; it's the bottom of the staircase that spirals out
of sight.
  (new classic Genesis) Carpet Crawlers 1999
--

It seems like I can get away with no entry at all in the BDE config file?
How does BDE know, then, which driver (in this case, Oracle 8.1.5) to use?
Please comment. Thanks.

/yunki

Jeff Overcash (TeamB) <overcash@onramp.net> wrote in message
news:37F15A8B.41C6A2DD@onramp.net...
> If you intend to use the TDatabase component, just have the user input the
> server name (Oracle SQL Net alias), user name and password and add the
three
> params to the TDatabase Params property.  Something like
>
>   Database1->Params.Clear();
>   Database1->Params->Add("Server Name=" + SeverName);
>   Database1->Params->Add("User Name=" + UserName);
>   Database1->Params->Add("Password=" + Password);
>   Database1->Connected = true;

You can get away without having an alias, but when you create an internal Alias
using the TDatabase component, it still uses the current BDE driver
configuration for Oracle.  The Oracle Driver can only have one configuration at
a time.

Yunki Paik wrote:
> 
> It seems like I can get away with no entry at all in the BDE config file?
> How does BDE know, then, which driver (in this case, Oracle 8.1.5) to use?
> Please comment. Thanks.
> 
> /yunki
> 


-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
Mild mannered supermen are held in kryptonite, and the wise and foolish
virgins giggle with their bodies glowing bright.  Through the door a harvest
feast is lit by candlelight; it's the bottom of the staircase that spirals out
of sight.
  (new classic Genesis) Carpet Crawlers 1999
--

How does BED know it is Oracle?
I have other databases( non-Oracle) on my machine also...

/yunki

p.s. Well, I have to try the code you suggested. Sorry, I am being lazy.

Because in the TDatabase component you must set the DriverName property if you
are not tying to a permanent BDE Alias.  So you have to set the DriverName to
ORACLE and that tells the BDE you are conencting to an ORACLE DB.

Yunki Paik wrote:
> 
> How does BED know it is Oracle?
> I have other databases( non-Oracle) on my machine also...
> 
> /yunki
> 
> p.s. Well, I have to try the code you suggested. Sorry, I am being lazy.

-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
Mild mannered supermen are held in kryptonite, and the wise and foolish
virgins giggle with their bodies glowing bright.  Through the door a harvest
feast is lit by candlelight; it's the bottom of the staircase that spirals out
of sight.
  (new classic Genesis) Carpet Crawlers 1999
--