replication error

we are replicating from SQL 2000 to Oracle via linked server. and are
getting the following error "The process encountered invalid column
data in bcp file", the bcp file is too big to investigate it, any one
has any insight of this?
Did this ever work? By default SQL Server maps the SQL Server datatypes to
the Oracle datatypes, so it should be able to construct the table on Oracle
and bcp the data there. You might want to try it with a null filter to see
if the problem exists with the schema or the data.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"shunyen" <kate.s.chiang@.healthnet.com> wrote in message
news:1175209502.943214.313370@.d57g2000hsg.googlegr oups.com...
> we are replicating from SQL 2000 to Oracle via linked server. and are
> getting the following error "The process encountered invalid column
> data in bcp file", the bcp file is too big to investigate it, any one
> has any insight of this?
>
|||It worked before, the table got rebuilt and we have to recreate the
replication and this shows up. what do you meen to use a null
filter?
On Mar 30, 5:56 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> Did this ever work? By default SQL Server maps the SQL Server datatypes to
> the Oracle datatypes, so it should be able to construct the table on Oracle
> and bcp the data there. You might want to try it with a null filter to see
> if the problem exists with the schema or the data.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "shunyen" <kate.s.chi...@.healthnet.com> wrote in message
> news:1175209502.943214.313370@.d57g2000hsg.googlegr oups.com...
>
>
> - Show quoted text -
|||A filter that looks like this
where 1=2
It always evaluates to false.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"shunyen" <kate.s.chiang@.healthnet.com> wrote in message
news:1175268021.364120.267330@.p77g2000hsh.googlegr oups.com...
> It worked before, the table got rebuilt and we have to recreate the
> replication and this shows up. what do you meen to use a null
> filter?
>
> On Mar 30, 5:56 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
>

replication between SQL Server database and linked informix server

I need help setting up replication between my SQL Server (data warehouse) database and a linked informix database.
Does anyone know the best to accomplish this. I can provide any additional information you require to help you, help me ;-)SQL Server support replicate between SQL Server and non-SQL Server Database.
U can choose snapshot replication ,transactional replicate and merge replication.
First U must establish a distributor(a SQL Server which is an agent is responsible for transfering data between two database server)
Then u will make SQL Server as a publisher and using the distributor u created to publish your data.
last, make the informix server as the subscriber to retrieve the data from the distributor.|||Also refer to books online about replication, heterogeneous data sources topic.|||Originally posted by Satya
Also refer to books online about replication, heterogeneous data sources topic.

I would like to use Access as the publisher and SQL as the subscriber. When I check BOL and forums... I am not finding anything that explains how I can accomplish this. Please keep in mind, I want to set up transactional replication between Access and SQL.|||I think after enabling Linked server connection to Access you can use Replication wizard as listed in this [http://www.databasejournal.com/features/mssql/article.php/1438201] article.

HTH

Replication and use of Remote Server

When Replication is configured it creates a remote server connection. Can it
be configured to use Linked Server instead? Linked server seems to have all
the same capability as Remote Server (and more).
LMK
In SQL 2005 they are all linked servers. IIRC it can, you have to give it
the name of distr_admin. Drill down in remote servers to determine what the
name should be.
Why do you want to do this?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LMK" <LMK@.discussions.microsoft.com> wrote in message
news:6DD94C8B-7AB8-463D-A4DB-CA42A3C5E7B1@.microsoft.com...
> When Replication is configured it creates a remote server connection. Can
> it
> be configured to use Linked Server instead? Linked server seems to have
> all
> the same capability as Remote Server (and more).
> --
> LMK
|||In this same server, we have a separate true need for a linked server
pointing back to the same master server. I cannot create a linked server with
the same name as a remote server. Therefore if I can change the remote server
for rep to a linked server instead, I have solved both problems. I am on
Win2000. So are you saying that I cannot make this change to Linked Server in
Win2000?
LMK
"Hilary Cotter" wrote:

> In SQL 2005 they are all linked servers. IIRC it can, you have to give it
> the name of distr_admin. Drill down in remote servers to determine what the
> name should be.
> Why do you want to do this?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "LMK" <LMK@.discussions.microsoft.com> wrote in message
> news:6DD94C8B-7AB8-463D-A4DB-CA42A3C5E7B1@.microsoft.com...
>
>

Replication and Linked Server Problemes

Hi @.ll,
we have right now big problemes with our replication and linked servers to
oracle.
has anybody an idea what wrong?
if we use a select statement everything works fine, only if we use a update
statement on a table on the SQL Server we see the error.
Just for your info. we use JOIN over 2 tbl on the Linked Server Side.
the error message is :
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'MSDAORA'
was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA'
ITransactionJoin::JoinTransaction returned 0x8000d048
thanks
klaus
Klaus,
apart from the obvious check - is MSDTC started - have a look at these
articles which are designed to troubleshoot this error:
http://support.microsoft.com/default.aspx?kbid=306212
http://support.microsoft.com/kb/280106/EN-US/
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||http://support.microsoft.com/default...;en-us;Q280106
does this help.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com