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.

Removing Server and Registry keys

4 posts in Windows NT Last posting was on 2000-04-18 20:08:49.0Z
Don Fonza Posted on 2000-04-15 01:43:39.0Z
Message-ID: <38F7C94B.6A656168@colltech.com>
Date: Fri, 14 Apr 2000 21:43:39 -0400
From: Don Fonza <dfonza@colltech.com>
X-Mailer: Mozilla 4.7 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Removing Server and Registry keys
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 19
NNTP-Posting-Host: dt101nbc.maine.rr.com 24.95.1.188
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2316
Article PK: 1089747

I manually removed a sybase server (ASE1192) and tried to create another
one using the same name. It kept complaining that the server already
existed. However, the entry was removed from the sql.ini and the
appropriate O/S files were all deleted. Eventually, I searched the
registry keys and found the server name under

HKEY_LOCAL_MACHINE
SOFTWARE
SYBASE
SERVERS

After removing the keys pertaining to the server name, I was able to
proceed with creating the server.

Question: What is the best way to remove an existing server? Is there
something that will remove the appropriate registry keys? Are there
some other keys that need to be removed based on how I did the server
removal?

Thanks in advance,

Don


Jerry Dennany Posted on 2000-04-16 16:55:40.0Z
From: "Jerry Dennany" <jerdenn@mindspring.com>
References: <38F7C94B.6A656168@colltech.com>
Subject: Re: Removing Server and Registry keys
Date: Sun, 16 Apr 2000 12:55:40 -0400
Lines: 51
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <eneMKV8p$GA.211@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: user-37kae97.dialup.mindspring.com 207.69.57.39
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2312
Article PK: 1089741

When you "manually removed a sybase server" what method did you use?

1. Delete the binaries by hand ?

2. Remove the server using Syconfig ?

3. Use the Sybase uninstaller utility ?


I've had problems like you've described using methods 1 and 2 - but
generally using the Sybase uninstaller (insert the CD, go through the setup
until you see the "uninstall" option) usually correctly deletes the
registry entries. (It will also delete _all_ of the sybase servers
installed).


Sybase has a really good installer on 11.5.1 (NT) (it was horrible previous
to 11.5.1), it's good for 11.9.2, and goes back to 'horrible' again for 12.0
and their java installer - ugh!


Jerry Dennany
jerdenn@mindspring.com


Don Fonza wrote in message <38F7C94B.6A656168@colltech.com>...
I manually removed a sybase server (ASE1192) and tried to create another
one using the same name. It kept complaining that the server already
existed. However, the entry was removed from the sql.ini and the
appropriate O/S files were all deleted. Eventually, I searched the
registry keys and found the server name under

HKEY_LOCAL_MACHINE
SOFTWARE
SYBASE
SERVERS

After removing the keys pertaining to the server name, I was able to
proceed with creating the server.

Question: What is the best way to remove an existing server? Is there
something that will remove the appropriate registry keys? Are there
some other keys that need to be removed based on how I did the server
removal?

Thanks in advance,

Don


Don Fonza Posted on 2000-04-17 02:21:15.0Z
Message-ID: <38FA751B.285B5AC8@colltech.com>
Date: Sun, 16 Apr 2000 22:21:15 -0400
From: Don Fonza <dfonza@colltech.com>
X-Mailer: Mozilla 4.7 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Removing Server and Registry keys
References: <38F7C94B.6A656168@colltech.com> <eneMKV8p$GA.211@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 56
NNTP-Posting-Host: dt101nbc.maine.rr.com 24.95.1.188
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2311
Article PK: 1089742

Actually, I removed the server as I would on a UNIX box:

A. Removed the interfaces file entry (sql.ini)
B. Removed the "RUN_*" files in the SYBASE\install directory
C. Removed the associated errorlog file
D. Removed the associated configuration files

After rebooting the machine, I noticed that Sybase Central is showing
the removed servers, even though the server names are NOT in the
interfaces file. Not sure how to truly remove the server on NT. I was
thinking about creating the servers in the sql.ini file and removing via
the sybconfig utility. Any thoughts?

Jerry Dennany wrote:
>
> When you "manually removed a sybase server" what method did you use?
>
> 1. Delete the binaries by hand ?
>
> 2. Remove the server using Syconfig ?
>
> 3. Use the Sybase uninstaller utility ?
>
> I've had problems like you've described using methods 1 and 2 - but
> generally using the Sybase uninstaller (insert the CD, go through the setup
> until you see the "uninstall" option) usually correctly deletes the
> registry entries. (It will also delete _all_ of the sybase servers
> installed).
>
> Sybase has a really good installer on 11.5.1 (NT) (it was horrible previous
> to 11.5.1), it's good for 11.9.2, and goes back to 'horrible' again for 12.0
> and their java installer - ugh!
>
> Jerry Dennany
> jerdenn@mindspring.com
>
> Don Fonza wrote in message <38F7C94B.6A656168@colltech.com>...
> I manually removed a sybase server (ASE1192) and tried to create another
> one using the same name. It kept complaining that the server already
> existed. However, the entry was removed from the sql.ini and the
> appropriate O/S files were all deleted. Eventually, I searched the
> registry keys and found the server name under
>
> HKEY_LOCAL_MACHINE
> SOFTWARE
> SYBASE
> SERVERS
>
> After removing the keys pertaining to the server name, I was able to
> proceed with creating the server.
>
> Question: What is the best way to remove an existing server? Is there
> something that will remove the appropriate registry keys? Are there
> some other keys that need to be removed based on how I did the server
> removal?
>
> Thanks in advance,
>
> Don


Jerry Dennany Posted on 2000-04-18 20:08:49.0Z
From: "Jerry Dennany" <jerdenn@mindspring.com>
References: <38F7C94B.6A656168@colltech.com> <eneMKV8p$GA.211@forums.sybase.com> <38FA751B.285B5AC8@colltech.com>
Subject: Re: Removing Server and Registry keys
Date: Tue, 18 Apr 2000 16:08:49 -0400
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.5600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.5600
Message-ID: <e#7gxMXq$GA.111@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: hboc.com 139.177.224.128
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2300
Article PK: 1089729

I just tried reproducing your case on 11.5.1 (I was curious!)



1. Add the entry in the sql.ini for the server you wish to remove (the one
with the remaining NT service entries).

2. remove the server using syconfig.exe

3. delete the master.dat, sybprocs.dat, and any other files (errorlog, etc)

4. reboot the NT server and re-create the ASE server if needed.

It worked for me, your mileage may vary.


This could probably be avoided by uninstalling with syconfig originally...

Jerry Dennany
jerdenn@mindspring.com