Fix for running the services

[oneeyeman1]

Hi,

Could someone please let me know if I can submit a fix for SAP/ASE?

I recently successfully installed the program on my Linux box.

Now I'm trying to connect to it using SAP ASE isql.

I opened a terminal did "source SYBAS.sh" and then "OCS-16/bin/isql"

Got following message:

[quote]

igor@IgorReinCloud /opt/sap $ OCS-16_0/bin/isql


The context allocation routine failed when it tried to load localization files!!
One or more following problems may caused the failure

Your sybase home directory is /opt/sap. Check the environment variable SYBASE if it is not the one you want!
Using locale name "en_US.utf8" defined in environment variable LANG
Locale name "en_US.utf8" doesn't exist in your /opt/sap/locales/locales.dat file
An error occurred when attempting to allocate localization-related structures.

[/quote]

Adding that locale name to the locale list for linux in that file fixes the issue.

Now I'm getting:

[quote]

igor@IgorReinCloud /opt/sap $ OCS-16_0/bin/isql
Password:
CT-LIBRARY error:
ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

[/quote]

which means I just need to pass proper server name to isql.

But the issue with locale is there and I hope it will be fixed with the next release.

Could someone please push that to core developers?

I also have another quick question.

Is isql GUI has been removed?

Because I can only see isqland not dbisql.

If not - could someone please explain how to make it work?

Thank you in advance.

[luc_vanderveurst]

Hi Igor,

Are you sure the sybase environment variables are set correctly?

You wrote:

I opened a terminal did "source SYBAS.sh"

Unless there is an odd name change, the file with the env variables is SYBASE.sh and located in the install directory.

Best Regards,

Luc.

[sladebe]

Re: Requested server name not found

Since you didn't specify -S on the isql command line, isql will use the DSQUERY environment variable as the Sybase server name to connect to (doc page). What was DSQUERY set to in your test?

[oneeyeman1]

@ Ben Slade,

It's default value.

But it work after supplying server and user names.

Still want to have GUI isql though...

Thank you.

[oneeyeman1]

@ Luc Van Der Veurst,

sorry about the typo. It definitely was SYBASE.sh.

can you help with the other 2 issues?

Thank you.

[c_baker]

16 SP04 PL02 is the current version. 16 SP04GA may not have been updated yet.

DBISQL is installed with the SDK components of the ASE installation or by a separate SDK installation. As mentioned previously, it will look at the $SYBASE/interfaces file to resolve host:port to servername, but you can define a host:port directly in a connection if you do not have a server entry in the $SYBASE/interfaces file.

Chris

[c_baker]

DBISQL is the isql gui.

"locale = en_US.UTF-8, us_english, utf8" has been added to the SDK for Linux and AIX. Can you confirm what version of SDK you are running?

Chris

[oneeyeman1]

c.baker ,

I installed 16.04 version of the server. Don't know about SDK. Maybe there was a condition on which that locale was added to the file in question?

Also - it was exactly the same issue with the 16.03 version.

How do I set up DBISQL?

Thank you.