[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now



Posted on 2002-05-03
Medium Priority
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: configurtaion.drivers.native.oracle
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, www.microsoft.com/data

 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

649 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