Installation

From SQLBWiki

Contents 1 Prerequisites 2 Installation 3 Sybase ini File 4 Network Installation and Preferences 5 Internet Proxy

[edit] Prerequisites

SQLBrowser runs on a Windows XP Client connecting to Sybase ASE 12.5 to 15 data servers with Java 1.6_07+ installed.

Important For best results, we generally recommend to upgrade to the latest JRE

[edit] Installation

Although this will come some day, SQLBrowser currently does not have an installer. The distribution is a zip file that you have to unzip. Please follow the current instructions for installation:

• Install JRE 1.6 or JDK 1.6 which you can find here
• Download the zip file and unzip it in a directory, e.g. 'c:\Program Files'. We will further refer to this installation directory as the <installdir>
• This will create a version specific directory, e.g. 'C:\Program Files\sqlbrowser_Jun08_222_Official'
• You can create a cmd file launching <installdir>\bin\sqlbrowser.exe, sqlbrowser.cmd is in the bin directory as an example
• In case of JDK version problems (this can happen depending on order of JDK/JRE installations or if an older JDK is installed after the 1.6), add an argument to the command line to specify the jdkhome like for example:

 <installdir>\bin\sqlbrowser.exe --jdkhome "C:\Program Files\Java\jre1.6.0"

• To add more memory (for batch analysis for instance), add -J-Xmx400m -J-Xms64m to the command line
• For more informatin, go to the Command Line section.
• For the first start, please read the Getting Started section.

[edit] Sybase ini File

• The Sybase ini file is necessary To SQLBrowser.
• The Sybase ini file is part of your Sybase open-client software.
• It is normally located in C:\sybase\ini.
• It contains the definitions (host port) of your servers.
• Generally, people interested in using SQLBrowser have Sybase Open Client installed.
• Please install Sybase Open Client software to get this file or get a copy an ini file describing the servers you wish to analyze.
• SQLBrowser does not otherwise require any other Sybase file than the Sybase ini file.
• Set up the path to the ini File in SQLBrowser Options.

[edit] Network Installation and Preferences

• It is advised to install SQLBrowser in a directory located on a network drive shared by users:

1. All users use the same version of SQLBrowser. Version upgrades are done only in one place
2. User can share preferences, such as the registration key. Make sure your organisation is registered for the effective number of users.
3. Create a sqlbrowser.cmd file in a network drive as described above with the desired amount of memory and possibly the correct JDK shared path
4. Have people using shortcuts pointing to this cmd file
5. To share preferences simply supply an argument file containing these preferences. See the Command Line section for the argument file description

[edit] Internet Proxy

• SQLBrowser can check for updates on the internet. To switch this option on or off do the following:
  • Go in "Tools" / "Plugins" / "Settings" and Select the Check Interval you need. Select "Never" to bypass update checks

• Go in "Options" / "SQLBrowser" / "Proxy" / "Check For Updates At Startup" and tick or untick the checkbox

• If you turn update checks on and your require a proxy, please set up the proxy accordingly in "Options" / "General". If your proxy requires authentication, you can provide the credentials in this panel