Not able to login by ISQL

[Former Member]

Hi , Installed Ecc6 on EHp7 on Sybase database but not able to login to database isql.

I login by sybsid run command isql -Usapsso -SSID but giving below error:-

CS-LIBRARY error:

        comn_get_cfg: user api layer: internal common library error: Configuration section isql not found.

CT-LIBRARY error:

        ct_connect(): user api layer: external error: The connection failed because of invalid or missing external configuration.

Regards

Adil

[ryan_hansen · Accepted solution]

Hi,

Do you have an ocs.cfg setup?
location: $SYBASE/$SYBASE_OCS/config/ocs.cfg

This is the same error if this file is being read, but an [isql] section is missing.

isql -Usa -Psybase -Sredhead

CS-LIBRARY error:

        comn_get_cfg: user api layer: internal common library error: Configuration section isql not found.

CT-LIBRARY error:

        ct_connect(): user api layer: external error: The connection failed because of invalid or missing external configuration data.

example ocs.cfg file:
[DEFAULT]

        ; This is the default section loaded by applications that use

        ; the external configuration (CS_EXTERNAL_CONFIG) feature, but

        ; which do not specify their own application name (CS_APPNAME).

        ; Initially this section is empty - defaults from all properties

        ; will be the same as earlier releases of Open Client libraries.

[isql]            <--- This is what is added

test:

isql -Usa -Psybase -Sredhead

1>

Regards,

Ryan

[Former Member]

Hello Adil,

Are you facing the same issue when you are trying to login in with user sapsa as well.

Ex.

isql -Usapsa -P<password> -S<DBSID>

[Former Member]

Thnx everyone...

Closing this thread

[former_member3043]

Hello Adil,

could be a problem of incomplete environment settings.

Verify what variables are set, best would be if you can execute SYBASE.bat or SYBASE.sh / SYBASE.csh before you try to use ISQL, then we are sure that all settings are correct.

Thank you.

With kind regards,

Stefan

[Former Member]

Hi Stefan,

We are also getting the same error isql: Command not found. As per the suggestions, we have executed SYBASE.sh/SYBASE.csh files, but stillthe same error persists. All enviornment variables are also set.

Please suggest how to proceed.

Many thanks in advance!!

Regards,

Hitesh Pathak

[ryan_hansen]

Hi Hitesh,

This should probably be a new thread as this seems to be a different error.

The error you are mentioning sounds like an O/S error saying there is no executable for isql in the PATH environment variable.

Example type command:

which isql

This should bring back the location of the isql executable.

What installation are you working with?

Do you see the isql executable in:
$SYBASE/$SYBASE_OCS/bin

If so, can you run isql with:

./isql -v

Regards,

Ryan

[Former Member]

Hi Ryan,

Thanks for your reply.

We are installing Dev PI system on RHEL 6 platform and this issue is while resolving error in 54th phase (Check DDIC password) of installation.

As per your suggestion, we executed the commands, screenshots of which are pasted below -

Please suggest required further action.

Thanks & Regards,

Hitesh Pathak

[ryan_hansen]

Hi Hitesh,

When you ran the ./isql, you were not in the bin directory.

What version of SDK or EBF number are you trying to run on RHEL 6?

How did you install this SDK?

If you open a new cmd prompt, source SYBASE.csh, and try running isql,
do you have the same issue?

Something is wrong either with the environment or the installation I would guess.

Could also be the permissions as they are restricted

[sunny_pahuja2]

Hello,

Please refer to SAP KBA 1294595 - Unable to connect to Sybase 15

This is for Sybase 15 but has similar error that you are facing.

Thanks,

Sunny