andrewyu
asked on
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)
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)
Which Delphi Version C/S?
ASKER
Version 4 with Update Pack 1.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
with Delphi Client Server, if you are using native driver then in the BDE\Configuration\ORACLE\ write VENDOR INIT=ORA803.DLL
ASKER
But, how come I can only use SQLORA8.DLL or SQLORA32.DLL ?
Andrew
Andrew
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.
This file comes with Delphi.
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
This file comes with Delphi.
Also write NET PROTOCOL=TNS
ASKER
So, I need to replace OCI.DLL with ORA803.DLL ?
ASKER
Do I need to copy some files ?
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.
ASKER
So, after I install Delphi 4 and configue the BDE then Oracle 8 Client, it should be ok ?
Andrew
Andrew
You should also configure the Oracle. Ask your Oracle DBA.
ASKER
Do you mean the client or server side ?
The server side.
ASKER
Is there anything else need to do other than adding new user name as well as password ?
Andrew
Andrew