udb question[SMTP:[EMAIL PROTECTED]] wrote:
> > Hi..
> >
> > Any one to help on this problem..
> >
> > One user had sybase open client installed on his NT
> > box. He wanted to have UDB runtime client V7.1
> > installed. We installed for him and then when he tries
> > to use sybase open client he gets the message
> >
> > "Fail to initialize LIBTCL.DLL .Please make sure the
> > SYBASE environment variable is set correctly"
> >
> > The ENV variable is set for sybase properly....
> >
> > What could be the problem???
>
When Sybase runs, it tries to load the language-specific components based on
two things. The environment language setting, and the corresponding
language component from its locales.dat file. On NT, the Sybase client may
use LANG as the environment variable, but more often, it uses LC_ALL. By
default for an english environment, it expects the value 'enu'. Now, when
you install the DB2 runtime client, it sets LC_ALL to 'EN_US' - and Sybase
then has a fit because it can't find a matching value for this in it's
locales.dat file.
(Yes, I've run into this problem before - can you tell?)
The best solution is to hack the Sybase locales.dat file (it's just a text
file), and find the [NT] section
e.g.
[NT]
locale = enu, us_english, iso_1
...
just enter a new line with EN_US as the value, e.g.
[NT]
locale = EN_US, us_english, iso_1
locale = enu, us_english, iso_1
...
This has the advantage of keeping both the DB2 and Sybase clients happy.
The other option is to play with the environment variable, but I had
problems with the DB2 client when doing this - YMMV.
(The only thing worse than being an Oracle+DB2+Sybase+MSSQLServer DBA? When
your boss says 'Hey, what about this Informix thing?' :-P )
Ciao
Fuzzy
:-)
----------------------------------------------------------------------------
"Woo Hoo!" H. Simpson
----------------------------------------------------------------------------
The contents of this post are my opinions only
If swallowed seek medical advice
(Apologies for the excess signature)
This email message (and attachments) may contain information confidential to
TOWER Software. If you are not the intended recipient you cannot use,
distribute or copy the message or message attachments. If you are not the
intended recipient, please notify the sender by return email immediately and
delete all copies of the message and attachments. Opinions, conclusions and
other information in this message and attachments that do not relate to the
official business of TOWER Software, are not given or endorsed by it.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
