Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-26 : 12:42:10
|
James writes "I am using SQL Server 6.5, publishing data from 1 SQL database on server A to another SQL database on server B.
The data to be published on Server A contains a text field with values like BERT ' AND MARY ' WENT TO THE ZOO'S BOOKSTORE.
When the data is replicated onto Server B the value looks like
BERT '' AND MARY '' WENT TO THE ZOO''S BOOKSTORE. These are 2 single quotes.
The publication goes through a firewall using TCP/IP socket 1434. I am using version 3.50.0305 ODBC drivers.
The whole thing used to work correctly until SQL Server was reinstalled on server B, at the same time the ODBC setting may have been changed.
I can publish an item from Server B (with a similar text content, but to a different table) to Server A without any problems.
What have I missed ?" |
|
|
|
|
|
Replicated data contains double quotes, while Published contains only single quotes