Cannot create merge replication from SQLSERVER 2000 to ORACLE

Hello everybody,
I am trying to build a merge replication between 2 servers
i managed to create it between to SQLSERVER 2000 with no problem
but now i am trying to do it between SQLSERVER 2000 and ORACLE server
when i try to do a transactional replication it work fine between the two
servers
but when i try to do the merge replication the following error occur:
The step did not generate any output. The step failed
i searched the topics and did not find any help but i managed to try writing
the output error on a file and it gave me the following message:
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
Category:NULL
Source: Merge Process
Number: -2147200933
Message: The process could not load the Merge Replication Provider for
'Oracle'. Check to see if the component is registered correctly.
if anyone can help me with, please do
best Regards
Nicolas
This is not supported, you can only replicate to SQL Server, MSAcess and SQL
CE. You will have to cobble a solution together for this.
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
"Nicolas Akl" <c_khano@.hotmail.com> wrote in message
news:D66DB88D-29E0-449B-B578-D775BFDD2572@.microsoft.com...
> Hello everybody,
> I am trying to build a merge replication between 2 servers
> i managed to create it between to SQLSERVER 2000 with no problem
> but now i am trying to do it between SQLSERVER 2000 and ORACLE server
> when i try to do a transactional replication it work fine between the two
> servers
> but when i try to do the merge replication the following error occur:
> The step did not generate any output. The step failed
> i searched the topics and did not find any help but i managed to try
writing
> the output error on a file and it gave me the following message:
> Microsoft SQL Server Merge Agent 8.00.760
> Copyright (c) 2000 Microsoft Corporation
> Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
> Category:NULL
> Source: Merge Process
> Number: -2147200933
> Message: The process could not load the Merge Replication Provider for
> 'Oracle'. Check to see if the component is registered correctly.
> if anyone can help me with, please do
> best Regards
> Nicolas
|||Dear Hilary,
As i understand from you, that there is no way to make a merge
replication from sqlserver 2000 to Oracle,
if so why does it support transactional replication and not the merge
replication
Best Regards
Carlo khanati.