ASE Server Port Numbers...
I am just wondering if the usual port assignment for ASE
server which is 5000, could be changed to any other number.
Is there any range of values that could only be assigned for
use with ASE, or we can use any port number as long as no
one uses the port?
You can use any port that is not in use on your system
> I am just wondering if the usual port assignment for ASE
> server which is 5000, could be changed to any other number.
> Is there any range of values that could only be assigned for
> use with ASE, or...ASE to ASE
Is anyone out there doing ASE to ASE replication using SQL remote? If
you are have created your own version of the SSEXTRACT utility to set up
a replicant database in ASE rather than ASA? Or does anyone know if
SYBASE has created a version SSEXTRACT for use with ASE to ASE
Thanks in advance
I thought the SQL Remote Replication support in ASE11.5 was meant for a
consolidate-database only (by design)! At least that was what Sybase
said when they announced support for SQL Remote technology support in
I will be happy to...ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE
Any information is welcome
ASA supports a fairly large sub-set of Transact-SQL, so if you write your
stored procedures and triggers in ASA using T-SQL, you should be able to
create scripts that will run against both ASE and ASA. If you're planning
to do this though, I would suggest developing your database schema against
ASA, since everything you write in T-SQL in ASA will be supported on ASE,
but the reverse is not true.
Check out the section in the ASA documentation entitled "Tra...ASE to Rep Server to Rep Server to ASE Configuration
I am hoping someone can help me. I am relatively new to Rep server
and definately new to this configuration. I am trying to set up
replication from ASE to Rep server to remote Rep Server to ASE. I am
doing this type of configuration because the one ASE server is in
North America and one is in England. This was recommended to me by
Sybase becuase the transformation/language of Rep Server to Rep Server
is quicker over the wan.
Anyway. I have a ASE to rep server to ASE configuration and had no
problem setting that up. Now I am trying to set up a new replication
environme...ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to
ASE and ASE To ASE ?
You should start with the Help file and then ask specific questions:
Data Replication with SQL Remote
PART 5. Appendix
APPENDIX A. Enterprise and Anywhere: Differences
There are many differences, so begin there.
Please only post to the newsgroup
BH Ong <email@example.com> wrote in message
> What are the differents in terms of configuring SQL Remote Between ASA to
> ASE and ASE To ASE ...Adding ASE to existing ASE-to-ASE Installation
I am using all ASE's in my SQLRemote setup.
My current installation consists of a Consolidated ASE & 2 Remote ASE's.
My attempt to add another Remote ASE to the existing installation
consists of these steps:
- Install the sqlremote system objects in the new Remote
- Install the stable queues in the new Remote
- Manually extract a bcp file of the shared table from the Cons
- Configure the Cons server for another subscriber
- Configure the new Remote's shared table, publications, &
- Manually b...ASE 15.0.2
Is it supported? Anyone tries this, if so, could you post the steps and
comments. I don't want to use ECDA (gateway) here, unixODBC driver is
You can't setup a "remote server" to anything other than another ASE, ECDA,
or any other open server product. In order to connect to an ODBC target,
your only option is ECDA.
"dbMethods" <firstname.lastname@example.org> wrote in message
> Is it supported? Anyone tries this, if so, could you post the steps and
> comments. I don't want to use ECDA (gateway)...ASE 11.5 on same server as ASE 12.5?
Anyone have 11.5 running on same server as 12.5 on NT?
Would not be concerned to do this in Solaris as I am on an NT 4.0 Box sp6.
Any known gotchas or issues? Going to take toni's advise in earlier posting
on doing the 11.5 install as a seperate user on the server already running
12.5 just fine. Hope this wilkl take care of env vars???
We have one app that the company who developed it will no longer support us
on newer versions of Sybase as a result this one crucial app must stay up
and running on 11.5 while we allow the rest of our company to progress
forward to 12.5 an...changing port number ASE
I need to change the port number of ASE , how can be done ??( no entry
for port number in cfg file)
You need shutdown your ASE server, edit the entry in the
interfaces file on the ASE server's host and restart the ASE
server. When it starts, it will use the new port number in
the edited interfaces file. Don't forget to change the port
number in all the client interfaces files as well.
> I need to change the port number of ASE , how can be
> done ??( no entry for port number in cfg file)
> Hi,...ASE eval and port number?
I just received the ASE 11.5 eval disc and am having some trouble setting up the
port number and transport protocol. I've used SQL server on UNIX extensively,
and am new to the NT version.
I've installed the server on an NT box and accepted the defaults. I need to
access it from a Win95 machine. What application do I use to to configure the
client for access to the remote server.
Apologies for the boneheaded question. Just getting used to the new server
...Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
We are in the process of planning the upgrade of our ASE
12.5.4 dataservers to ASE 15.x. What is the most
recommended way to upgrade ASE dataservers from ASE 12.5.4
to ASE 15.x?
1) Install new instances of ASE 15.x and load database
dumps from our ASE 12.5.4 dataservers to the newly installed
ASE 15.x dataservers.
- OR -
2) Use the ASE upgrade utility (sqlupgrade) to upgrade our
existing ASE 12.5.4 dataservers to ASE 15.x.
What are the Pros vs. Cons for loading a 12.5.4 database
into a 15.x ASE dataserver versus performing an ASE
dataserv...How to flush ASE defualt data cache without restart ASE server?
I want to test the io of some sql.
Thanks every one!
Try running the following for each table you wish to 'flush' from cache:
-- for each table in question:
See the reference manual for more details regarding the sp_unbindcache stored proc.
> I want to test the io of some sql.
> Thanks every one!
Thank you Mark!
> Try running the following for each table you wish to
> 'flush' from cache:
...ASE 12 & ASE 15 compatibility with Windows Server 2003
We've some ASE 12 & ASE 15 databases. We connect those
databases from different geographic locations. We also
connect to those databases via Citrix server.
At present the OS installed in the Citrix Server is Windows
2000. And we are planning to upgrade the same to Windows
Prior upgrading, we want to confirm the compatibility of ASE
12 & ASE 15 with Windows Server 2003.
Note: We've 10+ applications in Citrix Server that connects
to the ASE 12/ASE 15 databases.
You can use Sybase's certificati...why does ASE always prompt " Warning: There is no valid license for ASE server product"
I installed Sybase 12.0 on HP-UX 11.0 ,When Sybase is starting ,It
always promt the fllow messages:
00:00000:00000:2000/11/27 06:31:17.10 kernel Warning: There is no valid
license for ASE server product. Server is booting with all the option
00:00000:00000:2000/11/27 06:31:17.28 kernel Using config area from primary
00:00000:00000:2000/11/27 06:31:17.30 kernel Configuration Error:
Configuration file, '/home/sybase/othp.cfg', does not exist.
00:00000:00000:2000/11/27 06:31:17.33 kernel Warning: A con...