• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 910
  • Last Modified:

Oracle 8

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
andrewyu
Asked:
andrewyu
  • 8
  • 7
1 Solution
 
ronit051397Commented:
Which Delphi Version C/S?
0
 
andrewyuAuthor Commented:
Version 4 with Update Pack 1.
0
 
ronit051397Commented:
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 
ronit051397Commented:
with Delphi Client Server, if you are using native driver then in the BDE\Configuration\ORACLE\ write VENDOR INIT=ORA803.DLL
0
 
andrewyuAuthor Commented:
But, how come I can only use SQLORA8.DLL or SQLORA32.DLL ?

Andrew
0
 
ronit051397Commented:
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
 
ronit051397Commented:
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
 
andrewyuAuthor Commented:
So, I need to replace OCI.DLL with ORA803.DLL ?
0
 
andrewyuAuthor Commented:
Do I need to copy some files ?
0
 
ronit051397Commented:
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
 
andrewyuAuthor Commented:
So, after I install Delphi 4 and configue the BDE then Oracle 8 Client, it should be ok ?

Andrew
0
 
ronit051397Commented:
You should also configure the Oracle. Ask your Oracle DBA.
0
 
andrewyuAuthor Commented:
Do you mean the client or server side ?
0
 
ronit051397Commented:
The server side.
0
 
andrewyuAuthor Commented:
Is there anything else need to do other than adding new user name as well as password ?

Andrew
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now