Problem installing SQSH

You need these libraries to connect to Sybase server. They are part of Open Client. If you don't need a whole Sybase installation, you can just install Open Client. You should be able to download a trial version from Sybase web site and install it.

Thanks,

I could not find location to download Sybase Open Client, can you suggest a URL ?

The Sybase clients are included as part of the ASE Developer's Edition. You can just install the client side if you want.

When trying to install SYBASE from ASE setup, it returnign error, please refer to the logs below:

 ./setup.bin -console
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

Usage: setup [-f <path_to_installer_properties_file> | -options]
            (to execute the installer)

where options include:
    -?
            show this help text
    -i [swing | console | silent]
            specify the user interface mode for the installer
    -D<name>=<value>
            specify installer properties
    -r <path_to_generate_response_file>
            Generates response file.
The options field may also include the following in case of uninstaller
if it is enabled for Maintenance Mode
    -add <feature_name_1> [<feature_name_2 ...]
            Add Specified Features
    -remove <feature_name_1> [<feature_name_2 ...]
            Remove Specified Features
    -repair
            Repair Installation
    -uninstall
            Uninstall

notes:
    1. the path to the installer properties file may be either absolute,
       or relative to the directory in which the installer resides.
    2. if an installer properties file is specified and exists, all other
       command line options will be ignored.
    3. if a properties file named either 'installer.properties' or
       <NameOfInstaller>.properties resides in the same directory as the
       installer, it will automatically be used, overriding all other command
       line options, unless the '-f' option is used to point to another valid
       properties file.
    4. if an installer properties file is specified but does not exist, the
       default properties file, if present, will be used.  Otherwise, any
       supplied command line options will be used, or if no additional
       options were specified, the installer will be run using the default
       settings.

Which version of ASE Dev Edition are you installing? I think Sybase is only letting us download ASE 15.7 in the Developer Edition, which may not even be compatible with sqsh for ASE 12.5 - there were many changes in the Sybase client from 12.5.x to 15.x.

Also, try:

   setup.bin -i console

instead.

Lastly, ensure you have all the RHEL patches Sybase requires... These are documented in the ASE 15.7 Installation Guide for Linux. These depend on your platform, but basically you what RHEL 5.0 update 5 or above, and in particular:

   kernel-2.6.18-53.1.13.el5 (or higher)
   glibc-2.5-18 (or higher)

Hi

Is it easy to do if I use PERL scripting ?

You'll still need the Sybase client, plus the right version of Perl, plus the SybPerl libraries.

Note you don't actually need Perl or sqsh if all you want to do is run a sql file from a shell script. But you'll still need the Sybase client for that.

i.e. every possible solution requires the Sybase client. :)

Is there any way I could do it without using Sybase client, becaue its not FREE to use.  I may try using PHP scripting also.

I did not find it free, is it possible if you could provide me with link to download free sybase client ?

http://www.sybase.com/ase_1500devel

This is the full ASE but it will also include all the client-side stuff you need. You can choose not to install any server-side stuff during installation.

Thanks, I'll try and let you know.

I doubt that Sybase client available for free, since I have stopped working on this project, may not be able to test it even.