Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Multiple Sybase Directories

5 posts in Windows NT Last posting was on 1998-02-18 00:27:22.0Z
Thomas Ridley Posted on 1998-02-12 18:51:37.0Z
From: "Thomas Ridley" <tridley@questra.com>
Subject: Multiple Sybase Directories
Date: Thu, 12 Feb 1998 13:51:37 -0500
Lines: 15
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <Q95o939N9GA.378@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5202
Article PK: 1081280

I tried to install different versions of SQL Server, Rep Server, OC/OS down
different Sybase trees and managing paths and found that this is very tricky
to do successfully under NT.

I had good success if I started all servers up by hand in scripts after
carefully seting the SYBASE and PATH environment variables, but that keeps
me from running things as NT Services and the account which launched the
servers can not log out.

I would like to hear from others who manage multiple Sybase directories
in a production envrionment.

-TR


Reinoud van Leeuwen Posted on 1998-02-13 09:58:31.0Z
Message-ID: <34E41947.3A26@sybase.com>
Date: Fri, 13 Feb 1998 10:58:31 +0100
From: Reinoud van Leeuwen <reinoud@sybase.com>
Organization: Sybase Inc.
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
To: Thomas Ridley <tridley@questra.com>
Subject: Re: Multiple Sybase Directories
References: <Q95o939N9GA.378@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 33
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5198
Article PK: 1081279


Thomas Ridley wrote:
>
> I tried to install different versions of SQL Server, Rep Server, OC/OS down
> different Sybase trees and managing paths and found that this is very tricky
> to do successfully under NT.
>
> I had good success if I started all servers up by hand in scripts after
> carefully seting the SYBASE and PATH environment variables, but that keeps
> me from running things as NT Services and the account which launched the
> servers can not log out.
>
> I would like to hear from others who manage multiple Sybase directories
> in a production envrionment.

I have not tried this but this might be a sloution:
- create different accounts for each service (eg sybase_sql_10,
sybase_rep_10 etc)
- install one product (eg sybase SQL server 10)
- change the path: remove the sybase directories from the SYSTEM path to
the USER path (for this you might have to log on as the sybase_sql_10
account). Paths can be changed in the control panel-> system ->
environment (there are system and user settings)
- let the created service run under the created account (control panel
-> services -> SYBASE SQL SERVER (something like that) -> startup)

I think this should do the trick.

Reinoud van Leeuwen
Sybase Professional Services Maarssen / The Netherlands


Eoin Woods Posted on 1998-02-12 20:39:41.0Z
Message-ID: <34E35E0D.AD9395F8@sybase.com>
Date: Thu, 12 Feb 1998 12:39:41 -0800
From: Eoin Woods <eoin.woods@sybase.com>
Reply-To: eoin.woods@sybase.com
Organization: Sybase Inc.
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Thomas Ridley <tridley@questra.com>
Subject: Re: Multiple Sybase Directories
References: <Q95o939N9GA.378@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 34
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5201
Article PK: 1081282


> I tried to install different versions of SQL Server, Rep Server, OC/OS down
> different Sybase trees and managing paths and found that this is very tricky
> to do successfully under NT.

It is a little tricky if you want NT services.

> I had good success if I started all servers up by hand in scripts after
> carefully seting the SYBASE and PATH environment variables, but that keeps
> me from running things as NT Services and the account which launched the
> servers can not log out.
Yes, the problem is that NT does not provide a sensible way to specify
the environment
(specifically the PATH) for a service. Hence, starting the correct
binary is fairly
easy, but you can only have one set of DLLs to support it.

There are two ways you can work around this:

1. Copy all of the DLLs for a release into the %SYBASE%\bin directory
then
when executables start up they will pick up the correct DLLs (as
NT's
DLL search algorithm starts with the directory the .exe is in).

2. Run the services as different users with different PATH settings.

If you need more help with this, feel free to email me.

Eoin.
--
Eoin Woods, NT Development, ASE Engineering, Sybase Inc.
Sybase (UK), Crown Lane, Maidenhead, Berkshire, SL6 8QZ
Tel: +44-1628-597215 Fax: +44-1628-597000
Email: Eoin.Woods@sybase.com


Ethan Smith Posted on 1998-02-13 16:57:02.0Z
From: xnoxspamx.ethans@pobox.com (Ethan Smith)
Subject: Re: Multiple Sybase Directories
Date: Fri, 13 Feb 1998 16:57:02 GMT
Organization: SPS Consulting
Message-ID: <34e47ae9.591560@forums.powersoft.com>
References: <Q95o939N9GA.378@forums.powersoft.com> <34E35E0D.AD9395F8@sybase.com>
X-Newsreader: Forte Agent 1.5/32.451
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 42
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5195
Article PK: 1081276

If memory server correct, NT does not loads the users environment when
a service is started under a particular user account, so you still
have a path problem, since the service will only see the system path,
regardless of which user account it is run under.

On Thu, 12 Feb 1998 12:39:41 -0800, Eoin Woods <eoin.woods@sybase.com>

wrote:

>> I tried to install different versions of SQL Server, Rep Server, OC/OS down
>> different Sybase trees and managing paths and found that this is very tricky
>> to do successfully under NT.
>It is a little tricky if you want NT services.
>
>> I had good success if I started all servers up by hand in scripts after
>> carefully seting the SYBASE and PATH environment variables, but that keeps
>> me from running things as NT Services and the account which launched the
>> servers can not log out.
>Yes, the problem is that NT does not provide a sensible way to specify
>the environment
>(specifically the PATH) for a service. Hence, starting the correct
>binary is fairly
>easy, but you can only have one set of DLLs to support it.
>
>There are two ways you can work around this:
>
> 1. Copy all of the DLLs for a release into the %SYBASE%\bin directory
>then
> when executables start up they will pick up the correct DLLs (as
>NT's
> DLL search algorithm starts with the directory the .exe is in).
>
> 2. Run the services as different users with different PATH settings.
>
>If you need more help with this, feel free to email me.
>
>Eoin.

---------------------------------------
To reply by e-mail, remove the "xnoxspamx"
prefix from the reply to address.


Lee Grimes Posted on 1998-02-18 00:27:22.0Z
From: "Lee Grimes" <lee.grimes@ibm.net>
References: <Q95o939N9GA.378@forums.powersoft.com> <34E35E0D.AD9395F8@sybase.com> <34e47ae9.591560@forums.powersoft.com>
Subject: Re: Multiple Sybase Directories
Date: Tue, 17 Feb 1998 19:27:22 -0500
Lines: 51
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <EjmFcr$O9GA.421@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5182
Article PK: 1081262

maybe you can look at the registry entries for each instance of the server
you have running and see if there are places for stating the path(s) that
instance will use when it starts up as a service.

Ethan Smith wrote in message <34e47ae9.591560@forums.powersoft.com>...
>If memory server correct, NT does not loads the users environment when
>a service is started under a particular user account, so you still
>have a path problem, since the service will only see the system path,
>regardless of which user account it is run under.
>
>On Thu, 12 Feb 1998 12:39:41 -0800, Eoin Woods <eoin.woods@sybase.com>
>wrote:
>
>>> I tried to install different versions of SQL Server, Rep Server, OC/OS
down
>>> different Sybase trees and managing paths and found that this is very
tricky
>>> to do successfully under NT.
>>It is a little tricky if you want NT services.
>>
>>> I had good success if I started all servers up by hand in scripts after
>>> carefully seting the SYBASE and PATH environment variables, but that
keeps
>>> me from running things as NT Services and the account which launched the
>>> servers can not log out.
>>Yes, the problem is that NT does not provide a sensible way to specify
>>the environment
>>(specifically the PATH) for a service. Hence, starting the correct
>>binary is fairly
>>easy, but you can only have one set of DLLs to support it.
>>
>>There are two ways you can work around this:
>>
>> 1. Copy all of the DLLs for a release into the %SYBASE%\bin directory
>>then
>> when executables start up they will pick up the correct DLLs (as
>>NT's
>> DLL search algorithm starts with the directory the .exe is in).
>>
>> 2. Run the services as different users with different PATH settings.
>>
>>If you need more help with this, feel free to email me.
>>
>>Eoin.
>
>---------------------------------------
>To reply by e-mail, remove the "xnoxspamx"
>prefix from the reply to address.