Connect to Microsoft SQL Server on UNIX

Execute the ECDA environment script to point to odbc.ini file to connect to 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 ECDA environment script to point to the qualified path name of the centralized file, provided by the ECDA installation. For example:

For C shell:

DC_SYBASE.csh

For Bourne or Korn shell:

DC_SYBASE.sh

Executing the script sets the ODBCINI environment variable to install_dir/DC-15_0/connectivity/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 install_dir/DC-15_0/connectivity.