SQL Mobile and Datasets Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Nuno Silva <isf@xxxxxxxxxxxxx>
Date: Mon, 07 Aug 2006 13:14:15 +0100

Hi,

I'm using the RDA replication between sql server mobile and sql server 2005. The replication works very well but now i'm facing another problem, i'm trying to generate dataset on the replicated tables but when finishing the wizard i always get the error "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information".

All my tables have a primary key (GUID type). I don't understand why this error keeps appearing...

Could anyone help me with this?

Thanks in advance,
Nuno Silva.
.

Follow-Ups:
- RE: SQL Mobile and Datasets Problem
  - From: "privatenews"

Prev by Date: Re: updating subscriber error for transaction replication
Next by Date: Re: Error in Merge Replication_compensate_for_errors
Previous by thread: Re: updating subscriber error for transaction replication
Next by thread: RE: SQL Mobile and Datasets Problem
Index(es):
- Date
- Thread

Relevant Pages

Re: Transactional replication from SQL Server 2005 to SQL Server 7 - how?
... SQL Server 7.0 from the SQL2005 management tools but I would encourage to ... primary keys are replicated as unique indexes if you ... configure replication using the SQL2000 Enterprise Manager. ... If you plan to reinitialize your SQL2000->SQL2005 subscription in the ...
(microsoft.public.sqlserver.replication)
Re: High Availability
... also does failover. ... Async replication is real-time, as opposed to the scheduled Log Shipping ... > Note that one of the considerations for the active/passive GEO Cluster is ... > SQL Server 2000 High Availability Series ...
(microsoft.public.sqlserver.clustering)
Re: Snapshot Creation
... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
(microsoft.public.sqlserver.replication)
Re: QUEUE READER - A FREQUENT PROBLEM!
... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... queue table and the same transaction coldn't be inserted at the ...
(microsoft.public.sqlserver.replication)
Re: QUEUE READER - A FREQUENT PROBLEM!
... opinion what is the best choice: instal sp on sql server 2000 or install sql ... We are experimenting sql server 2005 replication making crash ... queue table and the same transaction coldn't be inserted at the ...
(microsoft.public.sqlserver.replication)