Connecting to Oracle

Description from AEHimself - See this forum post:

oci.dll requires a TNSNames.ora file and an entry for the connection, because... Oracle.
Also, an environment variable must be created on the PC named TNS_ADMIN, pointing to the folder where your TNSNames.ora file is located. E.g.: C:\Oracle\TNSNames.ora -> SET TNS_ADMIN=C:\Oracle

Then, set up Zeos like this:
Database: connection entry name in TNSNames.ora
User / Pass: credentials
Host name can be empty, not used for Oracle. Target is stored in TNSNames.ora
Catalog: the schema name to use. Important for metadata, if multiple schemas exists with same tables / procedures / etc.

An average TNSNames.ora entry will look like this:

IDENTIFIER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SOMETHING)
)
)

Should be added to some generic Zeos Documentation