Graduate Windows Lab

Remote Sybase Connection

Instructions for setting up jisql for use on your home computer.

  1. If you don't have a recent version of the Java 2 SE SDK installed on your system then you should download the latest production release from http://java.sun.com/j2se/1.4.2/download.html
     The version I downloaded was 1.4.2_04. Install J2SE SDK v1.4.2_04 - Take all default answers.
  2. Download jConnect™ 5.5 and 6.0 for JDBC™ from the link below. http://www.sybase.com/detail?id=1041013
  3. Create a directory C:\Sybase and extract the contents of the zip file into it.
  4. Download jisql. Unzip jisql.zip in the same c:\Sybase directory and follow the final configuration steps below.


Create an environment variable named JDBC_HOME under Control Panel -->Select System and Double-Click-->Select Advanced Tab--> Environment Variables --> Click Add.

Next Set
Variable Name: JDBC_HOME
Variable Value: C:\Sybase\jConnect-5_5

Note: The environment variable can be set to either System or User.

Open up the folder C:\sybase\jutils-2_0\jisql

Double click on jisql.bat

Iin the jisql login window fill in the form fields as follows:

  • Username:        <Your Sybase username>
  • Password:        <Your password>
  • Hostname:        rdb.translab.cs.sunysb.edu
  • Port number:    5000

Properties:   PROXY=http://www.translab.cs.sunysb.edu/proxy/servlet/TDSTunnelServlet