If you are looking for how to connect to SQL Server from UNIX here are few simple steps to configure them
#
# Start/stop processes required for SPMF
#
case “$1” in
‘start’)
/apps/iw-home/local/bin/spmf/db/start_jdbc.sh
/apps/iw-home/local/bin/spmf/db/stop_jdbc.sh
*)
echo “Usage: $0 { start | stop }”
exit 1
;;
esac
exit 0
CLASSPATH=/apps/iw-home/local/bin/spmf/db/dbd_jdbc.jar:/apps/iw-home/local/bin/spmf/db/log4j-1.2.15.jar:/apps/iw-home/local/bin/spmf/db:/apps/iw-home/loca
l/bin/spmf/db/sqljdbc.jar
export CLASSPATH
DRIVERS=com.microsoft.sqlserver.jdbc.SQLServerDriver
/usr/bin/java -Xms64m -Xmx512m -Djdbc.drivers=$DRIVERS -Ddbd.port=9001 com.vizdom.dbd.jdbc.Server &
JDBC_PID=$!
echo $JDBC_PID > /apps/iw-home/local/bin/spmf/db/jdbc.pid
kill -9 `cat /apps/iw-home/local/bin/spmf/db/jdbc.pid`
use DBD::JDBC;
my $sql = “select DepartmentID from Department where DepartmentName like ‘$dept%'”;