To install your new Data Direct SQL Server driver:


1) Download the  'sql60xxx.tar' file to the unix box where SAS is installed.

2) move the tar file to the directory where you want the driver to reside


3) Run the following unix command:

unix_prompt=> tar -xvf sql60XXX.tar

4) This will create a subdirectory of lib.

5) Export your LIBPATH(AIX) LD_LIBRARY_PATH(Solaris) SHLIB_PATH(HP) environment variable to the lib subdirectory.
 You will have something like the following:

unix_prompt=> export LIBPATH=/usr/local/sql_server_dir/lib

6) You will also get an 'odbc.ini.sample' template.
In addition to making a change to the Driver= and Address= options within the file also
add the options:
QuotedID=yes
EnableBulkLoad=1

7)Once you have added the options to the 'odbc.ini.sample' file rename the file to 'odbc.ini' if 'odbc.ini' does not 
already exist. If 'odbc.ini' does exist then add the sql server entry from the 'odbc.ini.sample' to the existing 
'odbc.ini' file.

8) Export the environment variable 'ODBCINI' to your 'odbc.ini' file.

export ODBCINI=/usr/local/sql_server_dir/odbc.ini


9) Adding 'LIBPATH'(aix) 'LD_LIBRARY_PATH'(solaris) 'SHLIB_PATH'(HP) and 'ODBCINI' environment variables to the 
!SASROOT/bin/sasenv_local will make these environment variables global to all users who run SAS.