ASE Server Port Numbers...
Hello!!! 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? Thanks!!! -KNUBIL You can use any port that is not in use on your system Knubil wrote: > Hello!!! > 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
Hi, 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 replication? Thanks in advance Doug Trainer Hi Douglas, 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 ASE11.5. 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 jean-fran�ois 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
Hello 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. -- David Fishburn Sybase Please only post to the newsgroup BH Ong <bhong@tm.net.my> wrote in message news:01bf4b98$33183580$7ccdc8c8@virtual-branch... > 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 server - Configure the Cons server for another subscriber - Configure the new Remote's shared table, publications, & subscriptions. - 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 preferred. Thanks 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" <dbmethods@nospam.com> wrote in message news:47e19f5a@forums-1-dub... > 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
Hi, I need to change the port number of ASE , how can be done ??( no entry for port number in cfg file) Isabella, 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. Cheers Raymond > Hi, > 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?
Hi, 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 platform. Thanks, Tim ...

Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
Hi All, 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? Potential options: 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: ====================== use <dbname> go -- for each table in question: sp_unbindcache <dbname>,<table_name> go ====================== See the reference manual for more details regarding the sp_unbindcache stored proc. binlib wrote: > 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
Hi, 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 2003. 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. Kindly advise. Thanks! Regards, Velu Hi, You can use Sybase's certificati...

why does ASE always prompt " Warning: There is no valid license for ASE server product"
Dear all: I installed Sybase 12.0 on HP-UX 11.0 ,When Sybase is starting ,It always promt the fllow messages: ASE_SERVER_ERROR: 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 features disabled. 00:00000:00000:2000/11/27 06:31:17.28 kernel Using config area from primary master device. 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...