SQL Anywhere 8.0.2 SQL Remote FTP replication problems
I have a problem setting up the FTP message control parameters with SQL
I use the SET REMOTE FTP OPTION statement to do this. See an example.
Considering a remote user with name 'pippo'...
SET REMOTE FTP OPTION pippo.host = 'my_host';
SET REMOTE FTP OPTION pippo.user = 'mickey';
SET REMOTE FTP OPTION pippo.password = 'mouse';
SET REMOTE FTP OPTION pippo.root_directory = 'root_dir';
These four statements set FTP parameters for the pippo database user.
This means that I want that the user pippo gain access to the replicati...Replication Server with SQL Remote
This is a multi-part message in MIME format.
Content-Type: text/plain; charset="ISO-8859-1"
We are trying to configure a Replication Server Warm Standby
schema. We already have an SQL Remote replication runing in
this server. We try to use the SQL Remote open server, but
it didn' t work, we follow all the steps in the SQL Remote -
Replication Server Manual, but it don't have enought
information and we think, we are missig one step.
We are sending the log of our SQL remote open server.
Someone kn...Replication is not replicating
The new database is added to the replication system but all
tables on the RDB are empty. Setreptable is on and there's
no uncommitted transaction. It is using default action
class and there's no loss detection. Queue is caught up.
We turned on "dsi_buf_dump" and it shows on the error log
that the transaction executed on the PDB is replicated.
However, the table is again empty on the RDB. Log is not
full on both RDB and RSSD. Maint user is dbo. What else
can I take a look at? PDS and RDS is 22.214.171.124, RS is 11.0.3
I don't remember since what version warm ...SQL Remote stop replication problem
I use SQLAnywhere Studio 6.0.2, whith an WinNT server and Win98 Clients.
I start SQL Remote in continuos mode with ftp message type, but in severals
times it stop replication with the message:
Sending message failed
Why this happen?
If dbremote is unable to connect to the ftp server or if it loses the
connection to the ftp server, then it will report the error and shut down.
If you want dbremote to close on completion, then you need to use the -k
switch. To get more information about the error...remote-to-remote replication problem
I have a problem replicating item detail from one remote site to another.
The data is in two tables, header and detail. A header and its detail are first created. Later,
the status of the header is changed, and the change of status allows the header and detail to
replicate. A trigger on the header issues an UPDATE ... PUBLICATION on the detail.
The test environment is HQ, remote1, and remote2. If this data is created at HQ, it correctly
replicates to remote1 and remote2. However, if the data is created at remote1, it correctly
replicates to HQ, but only the header data replic...SQL Remote hangs during FTP replication (still the same problem)
I posted this already on 28/5/2001.
Version : Sybase Adaptive Server Anywhere 6.0.3 EBF 3114
Replication using FTP (Microsoft IIS 4.0, NT4.0 Service Pack 6a).
For some reason the replication hangs for 4 hours, and then continues.
I've changed the TCP/IP settings to what Reg Domaratzki suggested but this
does not change anything.
I also changed the FTP server timeout from 4 hours to 2 hours and to 1 hour.
If the timeout is set to 4 hours, the replication hangs for (exactly) 4
If the timeout is set to 1 hour, the replication hangs for (exactly) 1
see a part of t...Replicating trigger action with SQL remote (SQL/Anywhere)
I need to replicate the actions of a trigger in one of my tables. I've
tried to use the -t option when running dbremote, but this still does not
replicate the trigger actions. Is there a solution to this problem?
I need to replicate the action of the trigger because I'm trying to do the
I need a sigle unique id for record in a table, and that table may be
inserted into at any number of remote databases, and at the consolidated
database. I've used an autoincrement column and a current publisher column
as the actual unique primary key, and have another column ...sql replication problem
i tried to use replication with sql server. i used a merge replication. i need to run a mirror version of the dnn elsewhere and was told to use replication. with a working dnn with sql server, i used replications. as soon as i have done something with replication and working, i try to access dnn which was working b4 and now gives an error.
getting error :
A column named 'rowguid' already belongs to this DataTable.
as a being a newbie with sql, is there any docuemtnation with replication with dnn as a focus. i see many docs on sql but i need sth with dnn, anyhelp is a...sql replication problem
i tried to use replication with sql server. i used a merge replication. i need to run a mirror version of the dnn elsewhere and was told to use replication. with a working dnn with sql server, i used replications. as soon as i have done something with replication and working, i try to access dnn which was working b4 and try a error.
getting error :
A column named 'rowguid' already belongs to this DataTable.
as a being a newbie with sql, is there any docuemtnation with replication with dnn as a focus. i see many docs on sql but i need sth with dnn, anyhelp is apreciated...SQL Remote Replication
Anybody tried using SQL remote to do replication between two ASE? I don't
need Replication Server just basic replication. since 11.9.2 comes with SQL
Remote, I thought why not give it a try!
I just started research on SQL-Anywhere Remote using FILE and MAPI as well.
It's a realy nice feature, cause I do update data not so offten.
So, just try it out.
BTW what means ASE
BH Ong schrieb in Nachricht <01befd97$8f8994c0$7ccdc8c8@virtual-branch>...
>Anybody tried using SQL remote to do replication between two ASE? I don't
>need Replication Ser...SQL Remote Replication
I would like to use SQL Remote Replication over a telephone modem connection
with a FILE type link. The app I am working on is being written in VB and
contains an embedded Sybase DB (i.e. Only the DB and required run time files
The manuals show a tutorial on one PC, which works fine. It also refers to a
simple file transfer mechanism that can be used to exchange files
periodically to effect replication. It doesn't say which files should be
transferred and to what directories?
Does anyone have a specific example on how this can be done?
The modem connection ...ASE Replicator or SQL Remote
We have several 11.9.x servers running on RH Linux that we need a simple
replication solution for. These severs will be upgraded to 12.5 over a
year or so. Rep sever seems overkill. I have been looking at the new ASE
Replicator in 12.5 and SQL Remote that was designed for 11.9.x. Here are
If I set up one 12.5 db and use it as the primary database can it publish
data to the 11.9.x servers?
Is SQL Remote going to be a supported product or is Sybase encouraging
users to move to Replicator?
Does SQL Remote run on Linux?
Which is eaiser, more reliable?
T...SQL Remote and ASE Replicator
Is it possible to use SQL Remote and ASE Replicator on the same database?
SQL Remote and Replication Server for example have such capability when you
Both the ASE replicator and SQL Remote for ASE need to exclusively manage ASE's
secondary truncation point in order to identify the oldest data page in syslogs
that they need to start scanning from. There is only 1 secondary truncation
point, and by the nature of it, it can not be shared between processes to
identify more than one page.
This is why we included the SSQueue as a solution for an ASE ...SQL remote replication stops
I have a problem with SQL Remote replications via FILE (the same with
another message types).
dbtran and dblog are not showing any errors. there is no gap/space in log
Remote site is only getting messages from consolidated, but nothing sending
to consolidated. When dbremote starts, it shows correct start of transaction
log, starting scan and finishing without any outcoming message.
Seems like dbremote is not scaning log or checking bad offsets.
I. 10/27 15:57:03. Transaction log "c:\test\03101600.LOG" starts at offset