Connecting to Oracle XE (10g) with c++ builder 6

[GalR]

Hello all,
I'm kinda noobie here, and' originally a Java programmer...

been trying to find some clue to how to use BDE/dbExpress to connect to the HR db on my local machine...

anyone did it/knows how/can guide me in doing this?

thank you in advance.
Gal

 

[2ffat]

Let's start with the basics. What DB does your HR use?

Is this a stand-alone DB, a server based DB, or a multi-tier DB?


James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}

 

[GalR]

Thx for the repaly....

It's a server/client type... in java you need a driver and a URL String (with other params like username/password, Service name or SID...).

 

[2ffat]

OK. For client/server, don't use BDE. It will only work for "local" databases like Paradox and FoxPro. Also, Borland/Codegear has suggested that BDE is on the way out.

I would recommend dbExpress or ADO or OBDC. Which version of BCB6 are you using, Personal, Pro, or Enterprise?


James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}

 

[GalR]

Enterprise

 

[GalR]

From reading I came to prefer the dbExpress and not ADO/ODBC

 

[2ffat]

I'll have to do some reading up on dbExpress and Oracle. I've used ADO with great success and not that hard to use, either.

BTW, C++Builder Developer's Journal has some excellent articles on dbExpress but they are for subscribers. Excellent rag IMHO.



James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}

 

[GalR]

thank you...

I hope this riddle will be solved ...
ADO is very good but the program will work with systems that don't have ODBC.

keep me posted please,
Gal

 

[2ffat]

OK, try this for a start. Dr. Bob (aka Bob Swart) has published a PDF of Database Development articles. These are for C++ Builder 2006 but they should apply to BCB 6, too. If you run into problems, check back here and I or someone will try to help.



James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}