Posted on 2002-05-03
Last Modified: 2013-11-23

I just installed ORACLE server 9i on a machine and ORACLE client 9i on another (which is quite an event by itself!).  

I'd like to know what I have to do to configure the BDE to work with it.  When I try to connect to it I get an error about drivers or something.  I work with Delphi 4.

Also, I'd like to know how to do it with Delphi 6's ADO component.  I also get the error when configuring the connection string.

Question by:qas
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +4
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 6989521

from one of my old Paqs, here's the 3 ways to connect to oracle database, I havn't tested that with oracle 9i yet, but working fine with oracle 8 and 8i

but first, could u view the tables on the server using the Sql plus in the client machine?
 here's 3 ways to connecting to Oracle

to use the ado, you should have D5 enterprise edition, or if you have D5 Pro, you can buy ADOExpress

from borland store

1) Native Connection:

Go to the BDE Administrator, you need to make new alias here
from Object menu > New > Database driver name > Oracle
now you have new alisa called oracle1, or any thing you chose
you need to change some of oracle1 properties:
Server Name : OraServer (it's will be oracle service name in your machine)
Just insure net protocol is : TNS
choose apply for the alias
now you have new alias connected to oracle, and you can access to it via
the table and query component like you connect to paradox or access

2) ADO

 this require you have delphi 5 enterprise edition, or delphi 5 pro with
ado express

from delphi in component palette switch to ADO

drop in the form ADOTable component
from object inspector we need to modifiy some properties of ADOTable

ConnectionString : double click on it
you will see new window, choose : use connection string then press Build
you will see datalink window now from provier tab choose > microsoft OLE DB
provider for oracle  then press next button
now in connection tab enter the following

Enter a server name : OraServer (oracle service name in your machine not the
alias name you created befor)
and enter the user name and password
click to check allow saving password check box
then click on Test connection, if it give you message "Test connection
Succeeded" that's mean you are connect now to oralce
then press ok button to close the this window and ok agian to close ado
connection window

again back to object inspector and now choose table name

go to contorl panel, and than choose 32bit ODBC

in the user DNS tab choose Add, then choose Microsoft ODBC driver for oracle, then click finish
you will see now micosoft odbc driver for oracle setup dialog
in the dialog enter your informations
data source name : choose name to define the odbc for your application ( you will it as alias in BDE

description : any thing
user name: any user is exist in the oracle database(Scott for testing)
connection string: choose your oracle server name

I hope that working with you, but anyway, I think if you use delphi native connection or ado to connect

to oracle
database, both of them better and faster than odbc

if you have Delphi 6 enterprise edition, you could use the DBExpress also

to check the tables in the oracle database use this select statment
"select * from tab"

if you have any errors, plz post them

Best regards
Mohammed Nasman

Author Comment

ID: 6989972
Hey mnasman!

Thanks for the answer.

I still get an eror message though.  With BDE connection, the message says (it is translated from french so maybe it is not accurate):

Cannot load an IDAPI service library
File: SQLORA8.dll
Alias: ORACLE1

With ADO, the problem is similar, with different a message.  That message though is raised when I test the connection.

Delphi is installed on the client computer with running Oracle 9i client software.  I can get a connection with sqlplus without any problem.

Any hint ?


Expert Comment

ID: 6990132
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 6990256
Hi qas,

be sure that Oracle drivers has right configuration. Try to run BDE admin and follow to:
be sure that
DLL32 and VENDOR INIT has right settings.

check out this link:


Author Comment

ID: 6991155
Hello folks!

I've tried all u said guys.  But I don't think the problem is a BDE one.  When I try to test an ADO connection, windows tells me that I need Oracle drivers (7.3 and upper) to get it to work (also translated from french so I'm sorry if it's not accurate).

I think it's more of an Oracle installation problem.  Is there a specific way I have to install the client so that the correct DLLs get at the right place ?

Thanks again!

Author Comment

ID: 6991341
Hey experts!

More news:

I just de-install and re-install Oracle client 9i and I now have a new option in the ADO Provider form: ORACLE PROVIDER FOR OLE DB.

When I try to use it, I get a message saying: OraOLEDBpus.dll: Can't find library (still translated from french)

Any clue ??

Expert Comment

ID: 6992991
I suppose that you have to replace interface dll shipped with BDE to interface dll shipped with Oracle. This one depend from Oracle version as mentioned in link  I provided.
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 6993107

  Try to install the Lastest MDAC, you can get it from microsoft site,

 also there's OLE DB proivder for native connection to Oracle database, you get it from Oracle site

  I read in the newsgroups that the BDE not working with Oracle 9i

  but the 3th party tools like ODAC and DOA working with oracle 9i


Author Comment

ID: 6994716
Thanks for the comments!

How do I replace those DLLs ?  I mean, which DLLs do I have to replace and how do I tell Windows they have been replaced ?

I've installed MDAC 2.7 without changes.

Thanks again.

Expert Comment

ID: 6995653
I talk about BDE.

run BDE admin and take a look at Orcale driver settings.

there should be

DLL32: some.DLL  
Vendor Init:  somevendor.DLL

set it according your Oracle version.

LVL 27

Expert Comment

ID: 6995721
is the oracle-client installed (comes with oracle)?

Author Comment

ID: 6996533
Oracle client IS installed.

BDE gives me two choices for DLL32:


When I select SQLORA8.DLL, I can select this file as vendor: OCI.DLL

When I select SQLORA32.DLL, I can select one of those two vendors: MTXOCI.DLL and ORA73.DLL

I've tried all the possible combination without success.  

I think mnasman's right about BDE not working with Oracle9i so here is a rewritten version of my question:  what are, from scratch, the steps for me to take so I can get Delphi6 to communicate via ADO connection with a distant Oracle 9i database ?

When I mean scratch, I mean that Delphi is installed and nothing more.

I work with win98se.

Thanks alot!

Expert Comment

ID: 9005015
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ/No Refund

Please leave any comments here within the next seven days.
Paul (pnh73)
EE Cleanup Volunteer

Accepted Solution

YensidMod earned 0 total points
ID: 9096649
Question is PAQ'd and no points refunded.

Community Support Moderator @Experts Exchange

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question