How can I avoid setting shell environment variables required by a driver?

Easysoft ODBC-Oracle Driver

How can I avoid setting shell environment variables required by a driver?

Article :	00809
Last Reviewed :	14th February 2006
Revision :	1

Some drivers require environment variables setting before you can successfully connect (e.g. DB2 and DB2INSTANCE, Oracle and ORACLE_HOME). If you are using the unixODBC Driver Manager you can set environment variables per DSN in the odbc.ini file using the following syntax:

DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={ENVVAR=value}

e.g.

DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={DB2INSTANCE=db2inst2}

The unixODBC driver manager will then set the environment variable before connecting to the driver. Note, this only works this way when using DSN based connections.

Applies To

Products
- Easysoft ODBC-Oracle Driver

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-Oracle Driver

How can I avoid setting shell environment variables required by a driver?

Applies To

Knowledge Base Feedback