DB2 Connect Affecting Sybase
I am working on a PC application that is connecting to DB2 OS/390 using DB2
Connect. When I installed the DB2 Connect client piece along with my app
on a user machine, 3 different Sybase applications no longer work. They
are getting connection errors. Anyone else ever run into this? Any light
you can shed would be greatly appreciated!
Thanks...Dave
# 1 Re: DB2 Connect Affecting Sybase
"Dave Shepherd" <sheptech@excite.com> wrote:
>
>I am working on a PC application that is connecting to DB2 OS/390 using
DB2
>Connect. When I installed the DB2 Connect client piece along with my app
>on a user machine, 3 different Sybase applications no longer work. They
>are getting connection errors. Anyone else ever run into this? Any light
>you can shed would be greatly appreciated!
>
>Thanks...Dave
Check the environment variables. DB2 sets an environment variable LC_ALL
to a value of EN_US. The LC_ALL variable is used by Sybase to tell what languages
are installed. If you're using the US version of DB2 you can safely remove
this environment variable and Sybase should work again.
HTH
Tim
Tim at 2007-11-12 0:01:33 >
# 2 Re: DB2 Connect Affecting Sybase
"Dave Shepherd" <sheptech@excite.com> wrote:
>
>I am working on a PC application that is connecting to DB2 OS/390 using
DB2
>Connect. When I installed the DB2 Connect client piece along with my app
>on a user machine, 3 different Sybase applications no longer work. They
>are getting connection errors. Anyone else ever run into this? Any light
>you can shed would be greatly appreciated!
>
>Thanks...Dave
Dave,
Check the set path command in the autoexec.bat file. Installing the DB2 Connect
on your user's machine resets the path to DB2 at the exclusion of the batch
file (wsybset). This is always the case in our shop for those users with
Sybase application. Hope this help.
roger at 2007-11-12 0:02:35 >
# 3 Re: DB2 Connect Affecting Sybase
"Tim" <tguimond@ma.ultranet.com> wrote:
>
>"Dave Shepherd" <sheptech@excite.com> wrote:
>>
>>I am working on a PC application that is connecting to DB2 OS/390 using
>DB2
>>Connect. When I installed the DB2 Connect client piece along with my app
>>on a user machine, 3 different Sybase applications no longer work. They
>>are getting connection errors. Anyone else ever run into this? Any light
>>you can shed would be greatly appreciated!
>>
>>Thanks...Dave
>Check the environment variables. DB2 sets an environment variable LC_ALL
>to a value of EN_US. The LC_ALL variable is used by Sybase to tell what
languages
Tim...the "LC_ALL" variable was the culprit. I removed this and everything
works! Thanks a lot!
Dave
>are installed. If you're using the US version of DB2 you can safely remove
>this environment variable and Sybase should work again.
>
>HTH
>Tim
