Database Guide

For UNIX users


UNIX
On UNIX systems, the ODBC drivers are 32-bit drivers. The required network software supplied by your database system vendors must be 32-bit compliant. Consult the system requirements for specific requirements for each ODBC driver.

ODBC.INI

ODBC.INI is a plain text file called .odbc.ini.

Since UNIX is a multiuser operating system, each user can have a private copy of .odbc.ini that resides in his or her home directory. System administrators can also maintain a centralized copy of odbc.ini that they control. To maintain a centralized copy, set the environment variable ODBC_INI to point to the fully qualified pathname of the centralized .odbc.ini file.

For example, if the fully qualified path is /opt/odbc/system_odbc.ini and you are using the C shell, you would enter the following:

setenv ODBC_INI /opt/odbc/system_odbc.ini

If you are using the Korn or Bourne shells, you would enter the following:

ODBC_INI=/opt/odbc/system_odbc.ini 
export ODBC_IN

This makes /opt/odbc/system_odbc.ini the centralized copy of the file. If a user has a copy of the .odbc.ini file in his or her home directory, then that file is used instead of the centralized version.

Starting the ODBC Administrator

For UNIX, you cannot start the ODBC Administrator. Instead, edit the .odbc.ini file with a text editor.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]