Oracle OCI/ SQL*NET and tnsnames

Oracle OCI/ SQL*NET and tnsnames

Postby Guest » Mon 14 Nov 2005 05:51

Is there a discussion of the advantages of using OCI vs SQL*Net anywhere?

Also a howto on how to switch between the two?

Also if using OCI.DLL and multiple orcle clients are installed how does dbexpoda.dll determine which OCI.DLL to use and hence which tnsnames.ora to use.

TIA
Guest
 

Postby Paul » Tue 15 Nov 2005 09:13

Net connection can work without Oracle client software. But it does not have all functionality of Oracle client.
You can switch between OCI connection and Net by using "Oracle (Core Lab)" driver or "Oracle Net (Core Lab)" driver from dbExpress connections list. You can use only one type of connection in one application simultaneously.
DbxOda knows about installed Oracle clients locations. It loads OCI.DLL that is the first in the environment PATH variable.
You can add variable
OCIDLL = "Your/path/to/ocidll"
to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE registry folder and choose location of oci.dll in non-standard place.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dbExpress driver for Oracle