Welcome to jSQL

This document is being served from a web server on port running as a Java applet inside Internet Explorer on your PC or as a native java process running locally depending on your config.

With the standard release you should be able to connect to the Sybase server "SYBDEMO" by using the "Sybase" link below and selecting this server or select the "MySQL" link below and log into the "MSQDEMO" server. Depending on how your firewall is configured you may not be able to connect however but you will generally be able try the application by using the demo site. To configure other servers or server types additional "jar" files will be required. You can return to this page any time by closing all tabs. See the notes below and at http://dbexplorer.com.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

The following adaptors are included in the release and available to access databases:

AdaptorFunction
Sybase ASESybase Adaptive Server
SQL ServerMicrosoft SQLServer
MySQLThe popular MySQL

The following databases will only work if you install the required jars as described below.

AdaptorFunctionJar required
KSybase ASEKerberised Sybase Sybase's jconn3d.jar
OracleThe mighty Oracle Oracle's classes12.zip
ODBCAny defined file DSN None required on windows
OSYBSybase or SQLServer DSN None required on windows
ODB2ODBC DB2 file DSN None required on windows
DB2The Big Blue's DB2 IBM's v9 db2jcc*.jar

On windows the Sybase the list of servers is taken from the file "c:\sybase\ini\sql.ini" or
"%SYBASE%\ini\sql.ini" or the file specified in your "%SQL_INI%" environment variable.
Each entry must be of the form:

[SERVER_NAME]
query=NLWNSCK,hostname,port[,kerberos principal for "KSybase" connections]
To access Sybase using Kerberos authentication, use the "KSybase" adaptor
and add the kerberos principal after the server port in your "sql.ini" file.
The path to your kerberos configuration file will need to be in the env var
"KRB5_CONFIG" and ticket path if required in the variable "KRB5CCNAME".

To add jars on windows add their path to the JSQL_CLASSPATH environment pariable.

On OSX you will need a ~/.interfaces file in the usual UNIX interfaces file format i.e.:
SYBASE
        query tcp ether <hostname> <portnum>
        master tcp ether <hostname> <portnum>
To enable servers other than Sybase you will need to copy the required JDBC jar driver
file(s) into the "/Applications/DBExplorer.app/Content/Resources" directory and restart.

For ODBC on windows, the server list is of the "File DSNs" which are defined in the directory:
"C:\Program Files\Common Files\ODBC\Data Sources\".

For other server types the server list is taken from the file <type>.ini
(or ".<type>.ini" on UNIX in the user's home directory. The format is:

SERVER_NAME1,host:port
SERVER_NAME2,host:port[,kerberos principal for DB2]
Click on one of the links above to select your server type and continue...