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. Verify that the keyword value is the path to the directory $SYBASE/$SYBASE_ECON.
To define data source entries, edit the odbc.ini file using the attributes in each of the categories, or sections, of the file. Each of these sections is delimited by comments.
As you edit the odbc.ini file, be sure you have the necessary parameters available. For all others, you can accept the default or provide a value appropriate for your site.
For more detailed definitions of data source parameters in the odbc.ini file, see the documentation for your site’s ODBC driver.
For DirectConnect for ODBC, you must edit the section of the file that applies to your site. The following example contains the required sections. Add DSN definitions based on driver documentation:
[ODBC Data Sources] ;: ODBC Data Source definitions ;;
[ODBC] Trace=0 TraceFile=odbctrace.out TraceDll=/sybase/DC-12_6/lib/odbctrac.so InstallDir=/sybase/DC-12_6
To help you diagnose ODBC connectivity problems, the Sybase odbct tool verifies that your system configuration and odbc.ini are configured correctly by attempting to make a simple connection to the target. See the configuration problems section in Chapter 10, “Troubleshooting,” for more information.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
