sqlcereplication error

[news]

Hi,

When I want to synchronize a database using Merge replication, I get this
stack of sqlce errors (using errors collection):

Error Code : 80004005
Message : Run
Native Err.: 28557
Source : Microsoft SQL Server 2000 Windows CE Edition
Err. Par. : data source=\Storage
Card\Speedy\Data\local.sdf;provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;

Error Code : 80040E14
Message : The OLE DB Execute method failed. The SQL statement is not
valid. [,,,SQL statement,,]
Native Err.: 28560
Source : Microsoft SQL Server 2000 Windows CE Edition

Error Code : 80040E21
Message : The column data type cannot be indexed. [,,,,,]
Native Err.: 25059
Source : Microsoft SQL Server 2000 Windows CE Edition


I can't find the source of these problems (especially the last one).

Does anybody have already seen this error ?

Thanks,
Franck

 

[Darren Shaffer]

pls move this discussion over to microsoft.public.sqlserver.ce.

the error you are seeing indicates that you are probably using the
create database option during merge replication and your publication
has some constraints that are causing problems when converting
the schema to SQL CE.

be happy to help you over in the sql ce newsgroup.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com