3. ODBC Client Components

3.8. Oracle 10g Instant Client: Connection String Formats

The Oracle 10g Instant Client can be used in OpenLink single-tier and multi-tier environments. In a three-tier configuration, an OpenLink Oracle 10g agent residing on the middle-tier can use the Instant Client to connect to an Oracle instance on the third tier.

Instant Client allows you to run applications without installing the standard Oracle client (SQL*Net or Net8) or having an ORACLE_HOME. It supports two basic connection string formats:

• //host:[port][/service name]
  • e.g. //dbase-server-5:4321/ORDERS
• an Oracle Net keyword-value pair such as

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=dlsun242)
      (PORT=5521)) (CONNECT_DATA=(SERVICE_NAME=bjava21)))

Naming methods that require a configuration file (such as tnsnames.ora or sqlnet.ora) for name translation can also be used if the environment variable TNS_ADMIN is set to point to the directory containing the file.

• Oracle documentation: connection string formats
• Oracle 10g Instant Client

Previous Oracle Connection Pooling Support

Chapter Contents

Next Contents of ADO.NET Data Providers