An old recipe that was laying around for Oracle Instant Client 10.2.
Some good things to know;
1. Oracle Client 10.2 contains some defects that requires the user that is running it to have Create global object permissions.
2. The user needs read-access minimum to the directory you will install the application to.
Unpack all Oracle-clients to (instantclient-basic-win32-10.2.0.4.zip and instantclient-odbc-win32-10.2.0.4.zip);
Append C:\instantclient_10_2 to the PATH variable
Create tnsnames.ora in c:\instantclient_10_2 with the following content;
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
(ADDRESS = (COMMUNITY = tcp.WORLD)(PROTOCOL = TCP)(HOST = FQDN)(PORT = 1531))
(CONNECT_DATA = (SID = name))
Execute the following command;
Oracle ODBC Driver is installed successfully.
Create a new System DSN