Chapter 5: Installing DirectConnect

For DirectConnect for Microsoft SQL Server

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, setting the attributes listed in the following table.

As you edit the odbc.ini file, be sure you have the necessary information available. For all others, you can accept the default or provide a value appropriate for your site.

**Table 5-5: Descriptions of data source parameters**
Parameter	Description
*Driver	The full path to the driver.
Description	An optional long description of the data source name.
*QuotedID	Parameter that allows quoted identifiers; that is, identifiers in the SQL Server that you can quote using a quoting character.
*Database	Name of the database to which you want to connect by default.
*Address	Parameter that contains a 4-part IP address and the port number that it is listening on.

Example of an odbc.ini file

Following is an example of the contents of the odbc.ini file for DirectConnect for Microsoft SQL Server, you must edit the section of the file that applies to your site. The following is an example:

; MS SQLServer 7 and 2000
;;
;; Use values from installation worksheet.
;;
;; Data Source Name
[dcmssql]
Driver=/sybase/DC-12_6/lib/MVmsss20.so
QuotedId=Yes
Database=
;; Address: Enter numbers from your install worksheet
;;   In the form: AAA.BBB.CCC.DDD,PPPP
;;   Where AAA.BBB.CCC.DDD is the 4 part IP Address 
;;   and PPPP is the port number it is listening on.
Address=
;;
;; Optional Failover options 
;;
LoadBalancing=0
AlternateServers=
ConnectionRetryCount=0
ConnectionRetryDelay=3

Diagnosing ODBC connectivity problems

After entering these parameters, use the odbct tool (see Chapter 10, “Troubleshooting,”) to test connectivity to the DRDA source.

View this book as PDF