Devart Forums

Hello
Can ODAC use the Oracle 10g Instant Client ?
If so as from which version and how does it work ?
Best Reagrds
Paul
MitSa

ODAC can work with Oracle 10g Instant Client since version 5.10.1.7. The working schema is the same. Please set needed HomeName to TOraSession.HomeName property. If you would like to connect to Instant Client using the default home (TOraSession.HomeName=''), be sure that you have path to oci.dll in the Windows environment PATH variable.

Ok i made this statment but i found this message ("can not find OCI dll") in OraSession i copy all dll file in instant client oracle 10g in many folder system32 & delphi/lib & odac/lib many many folder and when i try again the same message appear how can i solve this
note :
i have odac 5.10.1.7 (release not trail) and delphi 7 ;
thanks

You do not need to copy dll files. Probably you did not include path to oci.dll to environment PATH variable. Please try the last ODAC version.
Please send us small demo project with parameters of TOraSession and include registry settings starting from HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and value of environment PATH variable. Write your email message to ODAC support address.

I am having the same problem. Was a solution worked out?
I am using delphi 7 and the latest release of odac, 5.10.4.13(full version).

Cheers
Darren

Here is a common instruction how to work with Oracle 10g Instant Client (and
other clients)
1. Please choose how you want to configure TOraSession: to set
TOraSession.HomeName property directly or to use Oracle 10g Client as default
home (TOraSession.HomeName='').
2. If you set value to TOraSession.HomeName property directly ODAC will find
oci.dll in Oracle 10g Instant Client directory using its registry settings.
3. If you TOraSession.HomeName='' then ODAC will try to determine the
default Oracle client.
3.1. Please check that environment PATH variable has path to oci.dll library
that is situated in Oracle 10g Instant Client directory. Please check that
environment PATH variable does not have any other paths to any other
oci.dll before Oracle 10g Instant Client directory.
4. If you have problems with Oracle 10g Instant Client please send registry
settings starting from HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and a value of
environment PATH variable. Write your email message to ODAC support address.

Here is a common instruction how to work with Oracle 10g Instant Client (and
other clients)
1. Please choose how you want to configure TOraSession: to set
TOraSession.HomeName property directly or to use Oracle 10g Client as default
home (TOraSession.HomeName='').
2. If you set value to TOraSession.HomeName property directly ODAC will find
oci.dll in Oracle 10g Instant Client directory using its registry settings.
3. If you TOraSession.HomeName='' then ODAC will try to determine the
default Oracle client.
3.1. Please check that environment PATH variable has path to oci.dll library
that is situated in Oracle 10g Instant Client directory. Please check that
environment PATH variable does not have any other paths to any other
oci.dll before Oracle 10g Instant Client directory.
4. If you have problems with Oracle 10g Instant Client please send registry
settings starting from HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and a value of
environment PATH variable. Write your email message to ODAC support address.

I have a trouble with Oracle Instant client (instantclient-basic-win32-10.1.0.3-20050113.zip) http://www.oracle.com/technology/tech/o ... lient.html

Why are you trying to find some registry records? Instant client does not need any of this. Can you fix this trouble? Look at DOA code - this works fine!

We need more detailed description of your problem i.e. your Oracle client/server versions, ODAC version, complete sample to demonstrate your problem and script to create server objects. Please, send a message to our ODAC support e-mail address.