Issue launching Interactive SQL

adrianvanzyl

unread,

Jan 13, 2010, 11:29:47 PM1/13/10

to

Hi all,

I have installed ASE Developer 15.5 on my Ubuntu (Karmic)
laptop mainly as a means to get Sybase Central and
Interactive SQL tools to access our backend ASE servers.
Sybase Central runs fine - I can connect to and browse the
server dbs, but when I try to launch Interactive SQL I get
an ISQL error saying:

"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."

Well, I've tried reinstalling (executing setup.bin as a
sybase user with elevated privileges, following the install
guide), and that has not helped!

Does anyone have any ideas for me? What is the process or
where can I find docco on how to install and register
plugins for iSQL?

Thanks,

Adrian van Zyl

Jason L. Froebe [TeamSybase]

unread,

Jan 14, 2010, 3:07:45 PM1/14/10

to

Hi Adrian,

Open up /etc/ld.so.conf.d/sybase.conf (as root or sudo) and add the
following:

/opt/sybase/shared
/opt/sybase/shared32
/opt/sybase/DBISQL/lib
/opt/sybase/OCS-15_0/lib
/opt/sybase/OCS-15_0/lib3p
/opt/sybase/DataAccess/ODBC/lib

Then run ldconfig. I have a shell script I use to start Sybase Central:

% cat sybase_central.sh
#!/bin/bash

if [[ -z ${SYBASE} ]]; then
source /opt/sybase/SYBASE.sh
fi

if [[ -f ${SYBASE}/shared/sybcentral600/scjview.sh ]]; then
${SYBASE}/shared/sybcentral600/scjview.sh
fi
######

You'll probably want to update your /etc/environment file so you can run
it from the desktop (ubuntu won't read /etc/profile* for a desktop user):

% cat /etc/environment
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/oracle/app/jason/product/11.1.0/client_1/bin:/opt/sybase/ASE-15_0/bin:/opt/sybase/OCS-15_0/bin:/opt/sybase/DBISQL/bin:/opt/sybase/shared/sybcentral600:/usr/local/mp4v2/bin"
INCLUDE=/opt/sybase/OCS-15_0/include
LIB=/opt/sybase/OCS-15_0/lib
ORACLE_HOME="/opt/oracle/app/jason/product/11.1.0/client_1"
SCROOT=/opt/sybase/shared/sybcentral600
SYBASE=/opt/sybase
SYBASE_OCS=OCS-15_0
SYBASE_ASE=ASE-15_0
SYBASE_JRE6_32=/opt/sybase/shared/JRE-6_0_6_32BIT
SYBASE_JRE6=/opt/sybase/shared/JRE-6_0_6_32BIT
SYBASE_UA=/opt/sybase/UAF-2_0
SYBASE_PLATFORM=linux
SYBROOT=/opt/sybase

Hope this helps

Jason

Neal Stack [Sybase]

unread,

Jan 14, 2010, 3:41:27 PM1/14/10

to

Hello,

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 delete or 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"

If you installed the software as the user "sybase" but you are running
Interactive SQL as user "joe", you may need to copy the
"~sybase/dbisql.rep" file to joe's home directory "~joe/dbisql.rep".

Thanks,
Neal

adrianvanzyl

unread,

Jan 18, 2010, 2:14:04 AM1/18/10

to

Mate you are a legend! Worked perfectly first time - thank
you very much, you've saved me hours and hours of
frustration!

FYI, in my case the registry file had been created in the
root home directory. I did the original install as a
specially created sybase user with elevated permissions as
instructed, but still had to sudo to do the install under
Ubuntu!

adrianvanzyl

unread,

Jan 18, 2010, 2:17:12 AM1/18/10

to

Thanks for quick and comprehensive response Jason. As it
turns out I did not need this, as the solution Neal proposed
regarding the dbisql registry file sorted it out, but I
appreciate the time and effort you took to answer!

Thanks,

Adrian