Ok then...plot thickens!
Replication works when it takes the initial snapshot of the data. Problems
occur when data is modified. Blank spaces appear where I'd expect the double
quotations to be! Any ideas??
"Rich Doyle" wrote:
Quote:
I am currently attempting to replicate data from a SQL Server 2000 database
to an Oracle database using transactional replication. All works fine with
the exception that when I attempt to replicate data which contains double
quotations, it is somehow stripped out by the time it reaches the subscriber.
I've tried toggling the quoted identifiers option and have also used various
ODBC and OLE DB drivers but to no effect. Can anyone help with this issue?
Thanks in advance!! |