Thread View: borland.public.cppbuilder.database.multi-tier
4 messages
4 total messages
Started by Yunki Paik
Thu, 18 Nov 1999 00:00
Deployment: Connecting to Oracle
Author: Yunki Paik
Date: Thu, 18 Nov 1999 00:00
Date: Thu, 18 Nov 1999 00:00
28 lines
1290 bytes
1290 bytes
The following code works fine on my development system, but when deployed to
other
machine, I get error:
---
try {
Database1->Connected = false;
Database1->DatabaseName = "db";
Database1->DriverName = "ORACLE";
Database1->Params->Clear();
Database1->Params->Add("Server Name=deployPC");
Database1->Params->Add("User Name=scott");
Database1->Params->Add("Password=tiger");
Database1->Connected = true;
}
catch(EDatabaseError &e) {
ShowMessage(e.Message);
}
---
The error message is: Object not found.
The deployed machine does not have BDE alias. (But, I think it is OK since
it works
OK when tested without an alias on my machine.)
What does that mean? I would appreciate someone's help here.
Thanks.
/yunki
Re: Deployment: Connecting to Oracle
Author: Jeff Overcash (TeamB)
Date: Thu, 18 Nov 1999 00:00
Date: Thu, 18 Nov 1999 00:00
49 lines
2055 bytes
2055 bytes
The things I'd check is
a) Oracle client is installed properly
b) The Oracle Alias has been set up
c) BDE is install properly (check the BDE Admin to make sure you see the Oracle
Driver)
d) The <orahome>\bin is in the path
My gut guess is that b) is not setup correctly. To test a & b try loggin in
with SQL*Plus, to test c & d create a test alias in the BDE Admin and try to
connect.
Yunki Paik wrote:
>
> The following code works fine on my development system, but when deployed to
> other
> machine, I get error:
> ---
> try {
> Database1->Connected = false;
> Database1->DatabaseName = "db";
> Database1->DriverName = "ORACLE";
> Database1->Params->Clear();
> Database1->Params->Add("Server Name=deployPC");
> Database1->Params->Add("User Name=scott");
> Database1->Params->Add("Password=tiger");
> Database1->Connected = true;
> }
> catch(EDatabaseError &e) {
> ShowMessage(e.Message);
> }
> ---
>
> The error message is: Object not found.
> The deployed machine does not have BDE alias. (But, I think it is OK since
> it works
> OK when tested without an alias on my machine.)
>
> What does that mean? I would appreciate someone's help here.
> Thanks.
>
> /yunki
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Anyone who cannot cope with mathematics is not fully human.
At best he is a tolerable subhuman who has learned to wear
shoes, bathe and not make messes in the house. (Heinlein)
Re: Deployment: Connecting to Oracle
Author: Yunki Paik
Date: Fri, 19 Nov 1999 00:00
Date: Fri, 19 Nov 1999 00:00
28 lines
1447 bytes
1447 bytes
Jeff Overcash (TeamB) <overcash@onramp.net> wrote in message news:3834961E.80A38029@onramp.net... > The things I'd check is > > a) Oracle client is installed properly > b) The Oracle Alias has been set up > c) BDE is install properly (check the BDE Admin to make sure you see the Oracle > Driver) > d) The <orahome>\bin is in the path > > My gut guess is that b) is not setup correctly. To test a & b try loggin in > with SQL*Plus, to test c & d create a test alias in the BDE Admin and try to > connect. Jeff, a and b are OK. c cannot be tested because there is not a BDE applet in the control panel. (although I had specified full BDE installation when building the InstallShield Express project.) Am I missing any DLLs? Please advise. Thanks, Jeff, for your always helpful insights. Yunki
Re: Deployment: Connecting to Oracle
Author: Yunki Paik
Date: Fri, 19 Nov 1999 00:00
Date: Fri, 19 Nov 1999 00:00
8 lines
859 bytes
859 bytes
Jeff, The problem is now resolved. You were right. The problem was (c) - BED was not properly installed. When I corrected the InstallShieldExpress's setting, it was resolved. Thank you. /yunki
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads