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.

xp-server after upgrade

2 posts in Windows NT Last posting was on 2000-10-13 22:34:44.0Z
Anonymous Posted on 2000-10-13 18:39:18.0Z
From: Anonymous@sybase.com
Date: Fri, 13 Oct 2000 14:39:18 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: xp-server after upgrade
Message-ID: <CA5852CBE52495F5006679BC85256977.006679C985256977@webforums>
Lines: 7
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1575
Article PK: 1089051

Hi All

We recently did a upgrade from 11.0.3.2 to 12.0. Could some explain
to me how can I get a xp server installed. The "Server Config" utility
does not give any option for creating a xp-server

Thanks


Rob Verschoor Posted on 2000-10-13 22:34:44.0Z
Reply-To: "Rob Verschoor" <rob@sypron.nl>
From: "Rob Verschoor" <rob@sypron.nl>
References: <CA5852CBE52495F5006679BC85256977.006679C985256977@webforums>
Subject: Re: xp-server after upgrade
Date: Sat, 14 Oct 2000 00:34:44 +0200
Lines: 66
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <$3Kb2fWNAHA.281@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i0458.pvu.euronet.nl 194.134.165.203
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1574
Article PK: 1089052


<Anonymous@sybase.com> wrote in message
news:CA5852CBE52495F5006679BC85256977.006679C985256977@webforums...
> Hi All
>
> We recently did a upgrade from 11.0.3.2 to 12.0. Could some explain
> to me how can I get a xp server installed. The "Server Config"
utility
> does not give any option for creating a xp-server
>

Just follow these steps:

1. if your ASE servername is ABCD, run this command: sp_addserver
ABCD_XP

2. Using "dsedit", add a servername ABCD_XP on an unused portnumber.
You should find this new entry back in your SQL.INI file.

After this, XP server should be configured and ready for use.

HTH<

Rob

--
If you don't want to use X Windows, you could try "sybinit4ever", a
free tool which uses only an ASCII interface to create a new ASE
server. It can be downloaded from http://www.sypron.nl/si4evr.html

See the
ASE reference manual / System Administration Guide / Transact-SQL
user's guide
This / These books can be viewed or downloaded as PDF files from the
Sybase website http://sybooks.sybase.com . For more details how to get
there, see http://www.sypron.nl/sybbooks.html .

For more information on the background of this problem, as well as a
solution, see http://www.sypron.nl/idgaps.html .

... syntax and description are in the ASE Quick Reference Guide
Supplement, which you can download from
http://www.sypron.nl/ase_qref.html .

To use dynamic SQL, you need at least ASE version 12.0, which has the
"execute immediate" feature for this. In earlier versions of ASE you
can simulate some types of dynamic SQL though; for more information,
see http://www.sypron.nl/dynsql.html and
http://www.sypron.nl/dynsqlcis.html .

HTH,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:rob@sypron.nl.*No*Spam*Please*
WWW http://www.sypron.nl
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------