Sunday, February 21, 2010

Sybase interacive sql error

Just installed sybase 15.0.3 on 64 bit linux server successfully.Then tried to peek in my db using interactive sql but it just doesnt launch.It complains about some missing library.
"Interactive SQL could not load the "SQLAnywhere" plugin.
Its "saip11.jar" file has moved or has been deleted. You
will not ..."

The same error message is repeated for UltraLite and
GenericODBC and then I get a message saying:

"Interactive SQL cannot start because it is not installed
correctly. No database plugins has been registered. To fix
this problem you should reinstall the program."

After bit of searching i finally found the cause of the problem.
I had installed ase as using a wrong user login.

Under normal circumstance, the DBISQL registry file ($HOME/dbisql.rep)
should be correctly created by the installer. If for some reason the
file does not exist or if it's corrupted, the error messages mentioned
are raised (due to the fact that DBISQL assumes an ASA installation when
there is no registry).

To register ASEIsqlPlugin with DBISQL, first rename the
dbisql.rep file if it exists (just to be safe). Then, either re-run the
installer and install DBISQL again, or manually execute the following
command, assuming SYBROOT and SYBASE_JRE6 env variables are properly
defined:

$SYBROOT/DBISQL/bin/dbisql -Xregister aseisqlplugin11 "Adaptive Server
Enterprise" com.sybase.aseisqlplugin.ASEISQLPlugin
"$SYBROOT/shared/lib/jconn3.jar:$SYBROOT/DBISQL/lib/aseisqlplugin.jar:$SYBROOT/DBISQL/lib/jodbc.jar:$SYBROOT/DBISQL/lib/xml4j.jar:$SYBROOT/DBISQL/lib/planviewer.jar:$SYBROOT/DBISQL/lib/dsparser.jar:$SYBROOT/DBISQL/lib/asa.jar:$SYBROOT/DBISQL/lib/uaf-client.jar:$SYBROOT/DBISQL/lib/jini-core.jar:$SYBROOT/DBISQL/lib/jini-ext.jar:$SYBROOT/DBISQL/lib/jmxremote.jar:$SYBROOT/DBISQL/lib/jmxri.jar:$SYBROOT/DBISQL/lib/commons-logging.jar:$SYBROOT/DBISQL/lib/log4j-1.2.6.jar"

credits to Neal from sybase team for the explaination.

0 comments: