Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Native Oracle DB connection using an ORACLE_SID



Permlink Replies: 1 - Last Post: Jul 2, 2014 8:33 AM Last Post By: quinn wildman
Colin Maharaj

Posts: 23
Registered: 3/19/09
Native Oracle DB connection using an ORACLE_SID
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 1, 2014 5:36 AM
Hi all,
I use the Oracle Enterprise Manager at work to
manage some databases servers.

I was just browsing the folders and what I noticed
was a simple database connection C example.

It looked like a VC project.

Well I was able to do the LIB conversion, get
the headers adjusted, did some simple C changes
and was able to compile and it worked.

What I did next was copy the files to an XP
VM that had no oracle presence at all.

Well it complained about a missing DLL.

I copied it and it complained about another DLL
and I kept going until I got frustrated and
copied all the DLLs I could find in the Oracle
Enterprise Manager DLL folder.

I also had to copy the tns names files to
the DLL/EXE path of my app in the XP VM.

It worked, I was able to connect to a database
natively using a tns name.

QUESTION!!

What can I use in BCB XE4 Pro to do a native
Oracle DB connection that is component based,
and if it exists, what kind of supporting files
will be required.

Right now the project I did required the DLLs
and I copied ~120 files that was ~40 MB in size,
and all are Oracle DLLs.

And what is going to happen if I need to compile
to 64 bit, which is what I intend.

Thanks.


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

quinn wildman

Posts: 856
Registered: 12/2/99
Re: Native Oracle DB connection using an ORACLE_SID
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 2, 2014 8:33 AM   in response to: Colin Maharaj in response to: Colin Maharaj
Colin Maharaj wrote:
What can I use in BCB XE4 Pro to do a native
Oracle DB connection that is component based,
and if it exists, what kind of supporting files
will be required.

You'll have to use the DBGo components. The supporting files you need
will be dependent on the OLEDB Provider you select. However, most likely
you will want ODBC and you'll need the Oracle 32 bit client installed
and on your path.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02