SQL Central fails repeatedly ASE 11.5Anyone else having difficulty preventing SQL Central from crashing? I've
just installed ASE 11.4 on NT 4.0 sp3, and can do very little before SQL
Central wakes up Dr Watson and complains about access protection faults
(GPF by another name)
Kevin
I am using ASE 11.5 and Sybase Central 2.3.01 Build #1832 and it happens at
least 5 times a day it crashes...and when I am using the NetImpact Dynamo
1.2 plug-in it crashes every hour.
Mvg Jan
Kevin Campbell wrote in message <3471ECD4.AB14A897@gte.net>...
>Anyone else having difficulty preventing SQL Central from crashin...
ASE to ASEHi,
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 ASECould 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...
long sql failed in ASE 11.5.1 failedI tried to send a query with a long where list to an oracle database
through ASE CIS, but the server hang. If I took the same statement send
to DCOracle and bypass ASE it works. Can someone shed some light for me
on this? Thanks
Tony TRan
Long where clauses may be a problem if it ur user stack is full.
Try to increase the ASE "default stack size" parameter on server and try it
again.
...
What generals generally doReading a McChrystal thread elsewhere, I came across someone quoting a
US general
http://en.wikipedia.org/wiki/Smedley_Butler
> I spent 33 years and four months in active military service and
> during that period I spent most of my time as a high class thug for
> Big Business, for Wall Street and the bankers. In short, I was a
> racketeer, a gangster for capitalism. I helped make Mexico and
> especially Tampico safe for American oil interests in 1914. I helped
> make Haiti and Cuba a decent place for the National City Bank boys to
> collect revenues in. I ...
Loading ASE 15 beta2 --> ASE 15 failsHaving issues loading a dump from ASE 15 beta2 into ASE 15.
Beta license expired so installed new copy of ASE 15 and the
dumps from beta2 do not load.
Have tried doing remote load into ASE 15 using beta2 backup
server. Issues here because dumps done with level 4
compression:
1> load database dbadmin from
"compress::4::/usr/sybase/dump/IT_TEST.dbadmin_onite_0.dat"
at IT_BETA_back
2> go
Backup Server: 5.21.2.1: Remote DUMP/LOAD is not allowed
when interfacing to a stripe for device
'compress::4::/usr/sybase/dump/IT_TEST.dbadmin_onite_0.dat'.
....
30 10:5...
Fail to online database(ASE 12.5->ASE 15.0 developer)Hi Everyone,
Could you please help me to take a look at the error? It
happened when I want to online databse, I can load database
successfully:-), but failed to online......
I backup up the database from ASE 12.5, and restore it to
ASE 15.0 developer...
1> online database AdventureWorksDW
2> go
Started estimating recovery log boundaries for database
'AdventureWorksDW'.
Database 'AdventureWorksDW', checkpoint=(15436, 11),
first=(15436, 11),
last=(15436, 11).
Completed estimating recovery log boundaries for database
'AdventureWorksDW'.
Started ANA...
Why does the following query fail on ASE 15.0.2 but work on ASE 12.5.4?Connection conn = getConnection();
PreparedStatement stmt = conn.prepareStatement("select 'test' from
syscolumns where ? = ?");
stmt.setString(1, "test");
stmt.setString(2, "test");
stmt.execute();
The error is "Implicit conversion from datatype 'VARCHAR' to 'INT' is not
allowed. Use the CONVERT function to run this query."
I think I found the solution, which is that the database needs to know what
type to expect for the parameter marker. Therefore using an explicit
conversion (as mentioned in the error me...
ASA To ASE - VSWhat 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 ...
ASE 11.9.2.6Hi there
I'm running 11.9.2.6 (so latest patch level) on Fedora Core 3. It's a quad
i686 system.
I've configured 3 sybase online engines to run. Min = 3 and Max = 3.
Sometimes all 3 startup.
Sometimes only 2 or only the initial engine startup.
When 1 or more engines fail to startup the error message in the logs is
similar to:
kernel engine 1, os pid 5228 exited
kernel os_process_exists: kill failed. pid 5229 No such process
I've checked if some stale network connection is still connected on port
4100 before a problem restart, but this does not seem to b...
Displaying only failed statementsHi,
using ASA 9.0.2.3198 with DBRemote. The command line is :
dbremote -m 32M -c "dbn=Sp" -rd 2 -rp 5 -q -os 5M -o C:\Remote\Remote.log
C:\Sp\Data\
This is part of log file, created by -o option
I. 01/05 12:04:37. Applying message from "office"
(0-0012563077-0012727816-0)
E. 01/05 12:04:37. SQL statement failed: (-194) No primary key value for
foreign key 'Vend_Art' in table 'Art'
I. 01/05 12:04:38. Applying message from "office"
(0-0012563077-0012727816-0)
E. 01/05 12:04:38. SQL statement failed: (-194) No primary key value for
...
Failing ASE creation.I have installed ASE 12.5 and am trying to build the master device.
I believe the following excerpt is the cause, but have no idea how to fix
it. Can anyone shed some light on this?
00:00000:00001:2001/12/20 13:46:24.68 kernel ueshutdown: exiting
ld.so.1: /opt/sybase/ASE-12_5/bin/dataserver: fatal: relocation error: file
/opt/sybase/ASE-12_5/bin/dataserver: symbol
__1cG__CrunVdo_exit_code_in_range6Fpv1_v_: referenced symbol not found
The complete output below...
Building Adaptive Server 'hades':
Writing entry into directory services... Directory services entr...
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...
Restore ase database failHi:
Help me.
Error content using backup server:
Backup Server session id is: 30. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name '/home/sybase/date' section number
0001 mounted on disk file '/home/SYBASE/zbbak090202.dat'
Backup Server: 3.14.2.4: Logical page 1051903 is not in the given database
map.
...
Displaying an alert when a validator fails
Hi All,I've got a RangeValidator that ensures that the integer input in a textbox is in the allowed range. It pops up some red error text next to the textbox if they enter the wrong text.I am wondering if there is a way to trigger a dialog box (e.g., alert('You must enter a value between 5 and 15')) if they enter an invalid number in the field. The reason being, we've had a number of people who go through past that field quickly, and don't notice the red error text. The alert() dialog, which will interrupt user activity and give an audion alert, will (ho...