Chapter 5: Installing DirectConnect

For DirectConnect for Informix (wire protocol driver)

In the UNIX environment, the ODBC driver allows you to establish a centralized ODBC system information file that you can control. To do so, set the environment variable ODBCINI by executing the DirectConnect environment script to point to the qualified path name of the centralized file, provided by DirectConnect install. For example:

For C shell:

DC_SYBASE.csh

For Bourne or Korn shell:

DC_SYBASE.sh

Executing the script sets ODBCINI to $SYBASE/$SYBASE_ECON/odbcini

Remember, there must be an [ODBC] section in the system information file that includes the InstallDir keyword. Be sure that the keyword value is the path to the directory $SYBASE/$SYBASE_ECON.

To define data source entries

To define data source entries, edit the odbc.ini file, entering values for the parameters on your worksheet.

Descriptions of data source parameters

The following table provides descriptions of the parameters that you can provide in the odbc.ini file. Asterisks(*) identify the required parameters.

**Table 5-4: Descriptions of data source parameters**
Parameter	Description
*Driver	The full qualified path to the driver.
Description	An optional long description of a data source name.
*Hostname	Name of the machine or IP address on which the Informix server resides.
*PortNumber	Port number of the server listener.
*Server Name	Name of the server that contains the database you want to access.
*Database	Name of the database to which you want to connect by default.
WorkArounds (optional)	Name of the WorkArounds string key to support DirectConnect bulk transfers. The value is 536870912.

Example of an odbc.ini file

Following is an example of the contents of the odbc.ini file for DirectConnect for Informix:

;; Informix Wire Protocol Driver (Informix 9.x)
;;
;; Use values from installation worksheet.
;;
;; Data Source Name
[dcinfxwp]
Driver=/sybase/DC-12_6/lib/MVifcl20.so
Description=Informix Wire Protocol
HostName=
PortNumber=
ServerName=
Database=
;;
;; Advanced options
;;
CancelDetectInterval=0
ApplicationUsingThreads=1
TrimBlankFromIndexName=1
;;
;; Optional Failover options
;;
LoadBalancing=0
AlternateServers=
ConnectionRetryCount=0
ConnectionRetryDelay=3

[ODBC]
IANAAppCodePage=4
InstallDir=/sybase/DC-12_6
Trace=0
TraceFile=odbctrace.out
TraceDll=/sybase/DC-12_6/lib/odbctrac.so

For DirectConnect for Microsoft SQL Server

View this book as PDF