Instructions for setting up jisql at home

• If you are in GRADLAB skip all the install steps

• If you don't have a recent version of the Java 2 SE SDK 5.0 installed on your system then you should download the latest production release from http://java.sun.com/j2se/1.5.0/download.jsp. If you have a previous version of J2SE SDK v1.4.2_x installed it should be good to run jisql.

•Download jConn2.jar from here. Copy it to C:\jConnect

• Download jisql from here. Unzip jisql.zip. Extract contents to a folder in your system.

• To set an environment variable (system or user is fine) for JDBC, create an environment variable named JDBC_HOME with its value as the folder C:\jConnect. Add %JDBC_HOME%\jConn2.jar to your CLASSPATH variable (e.g., the JDBC_HOME variable on my PC looks like C:\jConnect and the CLASSPATH variable looks like this "%JDBC_HOME%\jconn2.jar" )

• Run in a command window jisql.bat from the folder where you extracted jisql.zip

• In the jisql login window fill in the form fields as follows:
• Username: <Your database username>
• Password: <Your database password>
• Hostname: rdb.translab.cs.sunysb.edu
• Port number: 5000
• Properties: PROXY=http://www.translab.cs.sunysb.edu/proxy/servlet/TDSTunnelServlet&CHARSET=iso_1

Type sp_help in the input window and click "GO". You should see the schema of your database in the output window. You are connected to Sybase. For JISQL: If you just close the window, your connection will remain active. Please disconnect before closing the window. Click on Connection/Close Connection.