Re: SQL 2K5 Custom Resolver (Business Logic Handler)



Did you sign the dll? It sounds like it is expecting to be signed.
--
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

"SteveM" <SteveM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:71AD9FCF-573B-43F4-A6E6-40C019E12F7B@xxxxxxxxxxxxxxxx
I have a system where certain data for a given record can be updated by
either the Server or the Mobile Device.

Upon replication we get a conflict.

The data that can be updated is in different columns.
'
I have tried to use column level tracking but it does not appear smart
enough to "merge" the data.

Consequently I am trying to create a custom resolver in managed code that
allows me to choose which data is successfully applied to the resulting
record.

Had I been aware of this potential conflict earlier I would have designed
the database differently, however, this did not rear its head until we
reached production.

The problem I actually have is that I don't seem to be able to correctly
register the dll in order to get the resolver to work. I get the following
error

Error messages:

· No signature was present in the subject.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2146762496)
Get help: http://help/MSSQL_REPL-2146762496

The Custom Resolver Component for article 'job' does not have a valid
digital signature. (Source: MSSQL_REPL, Error number:
MSSQL_REPL-2147198713)
Get help: http://help/MSSQL_REPL-2147198713

Neither of the associated links has any information other than "sorry, no
information".

SQL Server and IIS are on the same box so no problem with which machine
to
use.

I have tried to strong name and GAC the dll but this does nto appear to
help
or my use of sp_registercustomresolver is incorrect.

I would appreciate any pointers from people who have succeeded in getting
a
managed code conflict resolver up and running.

Thanks

Steve


.



Relevant Pages

  • Re: Snapshot Agent No Such Interface Supported error.
    ... dll that had 'repl' in the file name and it worked. ... "Hilary Cotter" wrote: ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Error 22272: Cannot load the DLL xpstar.dll...
    ... I would look for MSVCR71.DLL in SYSTEM32. ... I believe that if an entire DLL was missing, ... Reinstall the SQL Server tools? ...
    (comp.databases.ms-sqlserver)
  • Re: getting process info for processes started by the Service Control Manager
    ... > I have written an extended stored procedure that need to know ... > GetStartupInfo when the dll was loaded by the parent process (SQL Server). ... The problem arises when the SQL Server instance is started ...
    (microsoft.public.win32.programmer.kernel)
  • dll copy question
    ... I have a program that references a DLL. ... Microsoft Visual Studio Tools for Office 77633-163-9000041-41865 ... Microsoft SQL Server Analysis Services Designer ... Microsoft SQL Server Integration Services Designer ...
    (microsoft.public.vsnet.general)
  • Re: Tabs, Comboxes and ADO.Net Problems
    ... Thank You Bart. ... I was hoping SQL Server might solve problem 1. ... The ADO.Net interface that addresses this ... The problem is that sometimes and only sometimes the dll won't ...
    (microsoft.public.dotnet.languages.csharp)