Connexion to oracle without oracle

[Laurent Boutet]

Hi, (a long time since i havent been posting something here ;-))

Here is the following error message i get when i try to connect :
================================
Initialization Error
SQL *Net not properly installed

OracleHomeKey: SOFTWARE\ORACLE
OracleHomeDir:
================================

I must tell you my config :
I have an oracle server and a client computer without Oracle installed on it.
This error occurs on the client computer without oracle installed.
I just use environnment variables to use oracle set in a batch file. Here is the .bat :
==============================
set ORACLE_HOME=G:\

set ORACLE_SID=CAPTURE
set PATH=%ORACLE_HOME%\bin;C:\program;%SystemRoot%\system32;%SystemRoot%;d:\oracle\bin

set TNS_ADMIN=D:\oracle\network\admin

d:
cd "d:\ConnexionOracle\"
start ConnexionOracle.exe
==============================

ConnexionOracle.exe is a delphi application with DOA. I try to connect with it and get the error at the beginning of the post.

Can you help me ?
I must use oracle on computers without Oracle installed...is that possible with DOA ?

Last thing to say : the oracle environment variables setting seems to be allright : indeed, server manager works fine from my client computer after lanuching the .bat file(without oracle !!).

Thanks in advance,
Laurent.

 

[Marco Kalter]

You normally need an Oracle registry section for this, so that Direct Oracle Access can find the Oracle installation. You can however also specify the Oracle Net DLL on the command line:

start ConnexionOracle.exe ocidll=d:\oracle\bin\oci.dll

This should do the trick.

------------------
Marco Kalter
Allround Automations