not able to run isql on cygwin

Question

When I am trying to run sybase query through isql syntex it is giving below error.

Error -

"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 C:\Sybase. Check the environment variable SYBASE if it is not the one you want! Using locale name "en_US.UTF-8" defined in environment variable LANG Locale name "en_US.UTF-8" doesn't exist in your C:\Sybase\locales\locales.dat file An error occurred when attempting to allocate localization-related structures. "

I checked the environment path variable which is correct.

Does it run from `cmd.exe`? How about from a `cmd.exe` started from `cygwin`, i.e. `cygstart cmd`? — Miserable Variable, Mar 06 '14 at 21:19
So does the locale file exist? Can you show us what your current environment (`env` command output) variables are set to (not just $SYBASE)? — Michael Gardner, Mar 07 '14 at 02:49

score 2 · Answer 1 · answered Sep 08 '14 at 10:38

2

I found that if I run

unset LANG

before running isql, then isql works as expected.

answered Sep 08 '14 at 10:38

UnlimitedInfinity

338
2
5

score 0 · Answer 2 · edited Mar 29 '19 at 08:34

0

If above is the output, then it means that the environmental variable is not set properly. In order to set the environment variable - go to sybase directory

$ cd sybase/

and set environment variable

$ **export LANG=en_IN.UTF-8**

And then start the server.

$ cd sybase/

Now go to OCS-16_0 folder

$ cd OCS-16_0/

And then connect to the server.

$ bin/isql64 -Usa -SSYBASEASE

where

sa is my user
SYBASEASE is my Sybase server name

It will ask for password. enter it, and it will connect to the sql shell.

edited Mar 29 '19 at 08:34

baduker

12,203
9
22
39

answered Mar 29 '19 at 07:45

Padmini Ishwarya

11
1
2

Thanks all for your response. – RDP Oct 24 '19 at 15:56

not able to run isql on cygwin

2 Answers2

Linked