Re: SQL Mobile - can't replicate anymore?

Hilary,

I had the same type of problem last week, where the SqlCeException message
was empty. How do you know its a generic access denied error? Do you get
that from HRESULT? If so where do you look that up?

Graham


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:%23U0Lq3CpFHA.2580@xxxxxxxxxxxxxxxxxxxxxxx
> this is a generic access denied. Has permission changed somehow?
>
> --
> 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
> "dw" <dw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:106AB11D-ABFB-4FDF-BAE7-010A82C27E92@xxxxxxxxxxxxxxxx
>> Hello...
>> I created a small prototype app last week that was working great -
>> replicating data between SQL Mobile on my pda and SQL Server 2000.
>> Today,
>> for some unknown reason, the replication process fails on the client. I
>> checked the server logs and also ran the SQL Profiler....and the
> replication
>> process (on the server) works fine and indicates that it sent changes and
>> data to the client/subscriber.
>>
>> On my client app, the Synchronize method runs for a few seconds and then
>> errors out...but the SqlCeException has no error message...only HResult =
>> -2147467259.
>>
>> I searched around and could not find anything about this.
>>
>> I even deleted the SQL Mobile database from the client and started
>> over...but this still does not work. The database gets created...but no
>> tables are created.
>>
>> thanks for any help
>> - will
>
>


.

Relevant Pages

  • Re: connect to named instance w/ non-default port
    ... SQL Native Client Configuration. ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)
  • Re: Questions about RDA & Replication
    ... When performing RDA relations are not preserved in the corresponding sql ce ... when performing replication relation for a table T are preserved ... > in the table on the SQL Server side. ... One approach is to allocate a distinct range for each subscriber and a range ...
    (microsoft.public.sqlserver.ce)
  • Re: Merge replication in SQL Server
    ... However, port 443 is for https, did you want your SQL ... Configuring an instance of SQL Server to use a static port ... you can script out replication jobs by right clicking on a publication ...
    (microsoft.public.sqlserver.replication)
  • Norton Security and Merge Replication - Help!
    ... We have a built a mobile solution for a client by using MS SQL Merge ... The replication is done everytime the user syncs his Pocket PC device ...
    (microsoft.public.sqlserver.replication)
  • Source table filtering in DTS by target table values.
    ... I am new to SQL Server and to DTs. ... for the client master. ... file (created in the DTS package) and add them batch by batch ...
    (microsoft.public.sqlserver.dts)