14 March 2010: Recent updates at www.sypron.nl
----------------------------------------------
This month's quiz question is about a head-against-the-wall
problem that took an evening to solve last week...

Let's put a primary key on the table_name for columns (key_field,
key_field2)
THIS WILL WORK:
begin tran

When I dump the queue using "sysadmin dump_queue" I see a ton of
transactions
wrapped in begin tran/commit that have nothing to do with the error message.
I take the batching off via 'alter connection set batch to 'off' to make

The Yellowfin BI team have produced a new paper on "Location
Intelligence", the mashup of BI with GIS
Extract
More than 70% of your organizational data has a location component -

I'm replicating the entire database, and refresh the replica using dump
marker method.
After I load the replica and resume connection, all of a sudden I get a
flurry of duplicate inserts into quite a few tables.

It appears that dump marker pertains only to database subscriptions.
We are using table subscriptions. How do I not lose data accrued during dump
and load from primary to target, if new records are being created in the
process of replication refresh?

Hi everyone, first im sorry because i dont know how to explain my
issue so i have to put a fragment of my code which is written in php
and mysql, my goal is transfer this querys to sybase, hope im not
disturbing and somebody can help me:

There is a strange issue about sybase interfaces file. We have an
application which is run on solaris sparc OS and this application uses
open client (sybase OCS-12_5) for database operations. When we upgrade
our database server to sybase 15.03, our application didn't work. then

07 February 2010: Recent updates at www.sypron.nl
-------------------------------------------------
This month's quiz question is about something I learned
about 'isql' -- the hard way...

A legacy application uses Sybase 11.0.3 on OpenVMS.  A process
attempts to open a connection to the database using the dblibrary
'dbopen' function, specifying a NULL for the 'server' parameter.
However the connection is refused.  The reason is that it is ignoring

I have one of our accounting program working on sybase 6 uder linux.
We would like to migrate databse engine to new serwer run by win2008.
We are ready to buy ASA 9. Can someone explain  how to converse databses?
Bartek

Why am I getting different results from sp_server_info 2 and
@@version?  (@@version is correct).
exec sp_server_info 2
attribute_id  attribute_name    attribute_value