?
Solved

Oracle 8

Posted on 1998-09-08
15
Medium Priority
?
906 Views
Last Modified: 2008-02-26
I had already install Oracle 8 Client for Application User as well as Delphi 4 Client/Server Suite.

When I tried to connect to Oracle 8 in the BDS Administrator, I had received a error message "Cannot load an IDAPI service library. File: SQLORA8.DLL ". Why this happened and how can I solve this problem ?

Andrew
(I will increase the point as if I receive more back from elsewhere)
0
Comment
Question by:andrewyu
[X]
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
  • 8
  • 7
15 Comments
 
LVL 5

Expert Comment

by:ronit051397
ID: 1339078
Which Delphi Version C/S?
0
 

Author Comment

by:andrewyu
ID: 1339079
Version 4 with Update Pack 1.
0
 
LVL 5

Accepted Solution

by:
ronit051397 earned 80 total points
ID: 1339080
From the groups  http://developers.href.com/NEWS:ARTICLE::waArticle.82101

"...Oracle 8 server can use new Net8 server and SQL*Net 2.3 server as listener.
                  Also client must be the listener server's client (SQL*Net client for SQL*Net
                  server & Net8 client for Net8 server you must know which listener is the one
                  you use.

                  If you use Net8 server (it's default for the installation of database) you
                  must install Net8 client and change vendor init parameter to Ora8xx.dll. xx
                  is dependent to Oracle version (if beta is must be 02. Else 03). look for
                  ora8xx.dll in the oraclehome\bin directory and change vendor init parameter
                  to this to connect the server.

                  If you use SQL*Net server (optionally you can install for support oracle 7
                  clients) you must use SQL*Net client to connect the server & change the
                  vendor init parameter to ora7x.dll or orant7x.dll. the rest is same for
                  SQL*Net as i described above for Net8

                  Turan..."
0
Industry Leaders: 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!

 
LVL 5

Expert Comment

by:ronit051397
ID: 1339081
with Delphi Client Server, if you are using native driver then in the BDE\Configuration\ORACLE\ write VENDOR INIT=ORA803.DLL
0
 

Author Comment

by:andrewyu
ID: 1339082
But, how come I can only use SQLORA8.DLL or SQLORA32.DLL ?

Andrew
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1339083
with Delphi Client Server, if you are using native driver then in the BDE\Configuration\ORACLE\ write      DLL32=SQLORA32.DLL
This file comes with Delphi.
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1339084
with Delphi Client Server, if you are using native driver then in the BDE\Configuration\ORACLE\ write      DLL32=SQLORA32.DLL
This file comes with Delphi.
Also write NET PROTOCOL=TNS
0
 

Author Comment

by:andrewyu
ID: 1339085
So, I need to replace OCI.DLL with ORA803.DLL ?
0
 

Author Comment

by:andrewyu
ID: 1339086
Do I need to copy some files ?
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1339087
It depends on what version of Oracle you have, if you have Oracle 8.03, then this ORA803.DLL comes with Oracle. You don't need to copy any files, they are there already.
0
 

Author Comment

by:andrewyu
ID: 1339088
So, after I install Delphi 4 and configue the BDE then Oracle 8 Client, it should be ok ?

Andrew
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1339089
You should also configure the Oracle. Ask your Oracle DBA.
0
 

Author Comment

by:andrewyu
ID: 1339090
Do you mean the client or server side ?
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1339091
The server side.
0
 

Author Comment

by:andrewyu
ID: 1339092
Is there anything else need to do other than adding new user name as well as password ?

Andrew
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month13 days, 11 hours left to enroll

801 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