Windows 2003 SP2 x64 + SQL 2005 Standard 32bit + Oracle ODBC Driver 10.2.01
Replication between SQL servers works FINE, bit I'm not able to replicate betwen MS SQL and ORACLE server.
Any ideas ?
View Complete Post
I am having problems with data truncating when inserting into a SQL 2005 db from Oracle 10g- using openquery and a linked server. For instance, if I run something like:
select * from openquery(LK_Snomass,'select RSFORM.REPRESENTATION as REPRESENTATION
, DOCUMENT.DOCUMENT_ID as DOCUMENT_ID
, DOCUMENT.DOCUMENT_TEXT as DOCUMENT_TEXT')
The results of the blob data are only 202 hexademical characters in length. And then when I convert it to varchar, the results are cut-off. For instance, on a particular test record that I converted, here is what I have in the SQL database
select convert(varchar(max), DOCUMENT_TEXT), DOCUMENT_TEXT from dbo.CWDocumentStaging
I get the following:
for Document_Text, I get the following:
then for convert(varchar(max), DOCUMENT_TEXT):
this old man, he played one, he played knick-knack on my thumb with a knick-knack paddy whack give a
If I insert the data running the query against the linked server directly, the data does not truncate