Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

JDBC Connection to MS SQL Server 2000 on Linux

I am trying to install SQL Server 2000 Driver for JDBC on a Fedora Linux box. I dowloaded the driver from: http://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en. I followed the instalation instructions on the following site: http://msdn.microsoft.com/MSDN-FILES/027/001/779/install.htm but when they ask to enter install.ksh I get an error: command not found.
Does any one have a solution for this problem?

Thanks,
Jon
0
tmpllc
Asked:
tmpllc
  • 2
  • 2
  • 2
  • +1
5 Solutions
 
koppchaCommented:
which OS you are working on?
0
 
gnoonCommented:
I used JDTS instead. It's free and easy to use. No install needed, just copy and paste a jar file into  the CLASSPATH.
http://jtds.sourceforge.net/
0
 
aozarovCommented:
try running it:
./install.ksh
or
ksh install.ksh
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
tmpllcAuthor Commented:
OS is Linux Fedora.
This driver is free as well and should work, it was working for me on Windows.
I tried running ./install.ksh  I get the error: /bin/ksh: bad interpreter: No such file or directory.
Something is wrong with the shell I'm using ?
How can I fix this ?

Thanks,

Jon

P.S. Here is the install.ksh file I'm tring to execute ( maybe irelevant )

#!/bin/ksh

clear

echo ""
echo "============================================================"
echo "=    SQLServer 2000 Driver for JDBC Installation           ="
echo "=    Service Pack 2                                        ="
echo "=    Build 2.2.0037                                        ="
echo "============================================================"
echo ""
echo "Initializing....."
echo ""

ERRCHK=1
INSTALLDIR=`pwd`
TARFILE="$INSTALLDIR/msjdbc.tar"
DEFAULTDIR="/opt/msSQLjdbc"

echo ""
echo "================================================================="
echo "=    SQLServer 2000 Driver for JDBC License Agreement          ="
echo "================================================================="
echo ""
echo "Press <enter> to view License Agreement."
read DUMMY

more EULA.txt

echo ""
echo "Do you agree to the terms of the License Agreement? <y/n> (y)"

read ANSWER

case $ANSWER in
  "n" | "N" | "No" | "no" | "NO")
      echo "Installation Cancelled by user."
      exit 0
        break;
        ;;
   *)
      echo "Installation proceeding..."
        break;
        ;;
esac

while true
do
      if [ $ERRCHK -ne 0 ] ; then
            echo ""
            echo "Please enter the installation directory: ($DEFAULTDIR)"

            read TARGETDIR
            
            if [ -z $TARGETDIR ] ; then
                  TARGETDIR=$DEFAULTDIR
            fi

            if [ ! -d "$TARGETDIR" ] ; then
                  mkdir -p "$TARGETDIR"
                    ERRCHK="$?"
                    if [ "$ERRCHK" -ne 0 ] ; then
                        echo "You do not have permissions to write to this directory"
                        exit 0
                  fi
            fi
            break
      else
      break
      fi
done

echo ""
echo "Installing SQLServer 2000 Driver for JDBC...."

cd $TARGETDIR

tar -xf $TARFILE
ERRCHK="$?"
if [ $ERRCHK -ne 0 ] ; then
      echo "There was a problem opening the tar file ($TARFILE)"
      echo "Aborting Installation."
        exit 0
else
      echo "Installation is Complete."
      echo "SQL Server 2000 driver for JDBC is installed in the following location: $TARGETDIR"
      exit 0
fi





0
 
koppchaCommented:
At your command prompt  type this commanf "which ksh"
If it gives you the path thenpost the path.If it says that it can not find it then korn shell is not  properly installed.So you can not run korn shell scripts .
0
 
aozarovCommented:
Right you probably don't have ksh shell installed but I think this script can also work with bash shell (which probably you have) as well.
Try doing:
bash install.ksh
0
 
tmpllcAuthor Commented:
I needed to install the korn shell, I didn't had it on my system. Then I was able to complete the SQL driver instalation.
Thanks,
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now