Neoview ODBC Drivers Manual (R2.5)

6. Make the connection.
Call SQLConnect or SQLDriverConnect. The driver manager uses the connection options
and the SQL_ATTR_CP_MATCH attribute to determine which connection in the pool to
assign to the application.
7. Set connection attributes.
Call SQLSetConnectAttr to set these attributes if necessary:
• SQL_ATTR_TXN_ISOLATION (default: SQL_TXN_READ_COMMITTED)
• SQL_ATTR_ACCESS_MODE (default: SQL_MODE_READ_WRITE)
• SQL_ATTR_AUTOCOMMIT (default: SQL_AUTOCOMMIT_ON)
An application, however, cannot change the schema using an ODBC API function. If more
than one user wants to create objects in the same schema, set the schema to USR (the default)
using the Microsoft ODBC Administrator.
8. Retrieve and process data from the database.
When using connection pooling, an application must preserve the database context within
the session and should not execute SQL statements that change the name of the database or
its context.
9. Disconnect and return the connection to the connection pool.
Call SQLDisconnect.
NOTE: If a transaction is pending when an application calls SQLDisconnect and
SQL_ATTR_AUTOCOMMIT is set to SQL_AUTOCOMMIT_OFF, the ODBC driver returns
SQLSTATE 25000 (Invalid transaction state). The application must then explicitly commit
or roll back the transaction, and then disconnect.
10. Free the environment and connection handles.
Call SQLFreeHandle for each handle.
For detailed information about connection pooling and the ODBC API functions, refer to: SQL
Server Connection Pooling (ADO.NET).
Configuring the Client Data Source on Linux, HP-UX, IBM AIX®, and Sun
Solaris
The install.sh script creates the data source configuration file MXODSN.template in the
/etc/hpodbc directory. Rename MXODSN.template to MXODSN and make the necessary
changes.
Setting Trace On
By default, trace is set OFF. To set trace ON, set the flag TraceStart to 1. For example,
TraceStart = 1.
[ODBC]
traceFlags = INFO
TraceStart = 1 A value of 0 will set trace OFF
TraceFile = TRLOG
Setting Trace Level
You can set the trace level by setting traceFlags. Each level of tracing includes successively
more tracing information. For example, if you choose the CONFIG level, you get messages from
60 Configuring Client Data Sources