Custom library Use

When I had used SQL2K5 Sept. CTP there was an issue using custom .net framework 2.0 library. I had to register the library in GAC + had to copy the dll into .Net framework 2.0 folder structure. I understand why we need to copy the dll on the development box so we can build packages, but why do I need to copy the dll in framework folder for production environment. Should GAC registration be enough?

If this is a feature, what's the purpose of registering the dll in GAC if it requires it to be in folder hierarchy. Especially in .net framework 2.0 so that the reference dialog box can display the component.

The question is if I have custom dll how do I deploy it so that it works with the package? How can I use the same dll in development environment without having to copy it in .net framework folder?

You need to put the DLL in the Framework folder if you are calling it from a script task or script component. You only have to do this on your development workstation.

More info here: http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2341.aspx

-Jamie|||

The DLL should be in Frameworks folder at runtime only if the script task's or component's PreCompile option is set to FALSE. In this case the script is compiled at runtime, and the dependency needs to be in the Frameworks folder due to VSA limitations.

In default case when PreCompile is TRUE, the DLL only needs to be deployed to GAC at runtime.

|||That was it. I found a script task that did not have PreCompile set to True.

Thank you.

Custom Conflict Resolver

Hi there,

I have created a custom conflict resolver for an article that is using Merge replication. I can register my custom resolver OK, I can change my merge article to use my new custom resolver, but when a conflict occures the replication monitor shows the following errors:

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 'BRANCH' does not have a valid digital signature. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147198713)
Get help: http://help/MSSQL_REPL-2147198713

At first I thought it was because my assembly wasn't signed, so I signed it. I still get the same error.

I have various debug statements in the assembly and I can see that Initialize and HandleChangeStates gets called ok, but no other overrides.

Can anyone help me please?

Thanks

Graham

Hi Graham

When you added the article with sp_addmergearticle did you want the the signature verified?

[@.verify_resolver_signature = ] verify_resolver_signature

Specifies if a digital signature is verified before using a resolver in merge replication. verify_resolver_signature is int, with a default of 0. 0 specifies that the signature will not be verified. 1 specifies that the signature will be verified to see if it is from a trusted source.

See here for more info:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl_11et.asp

Thanks

Nabila Lacey

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Hi there Gravy, i'm new in merge replication, conflict resolution, procedures and more.

I managed to make a replication from a PC to a PPC, and it works, but now i have conflicts updating colums, i never worked with procedures, and i'll have to do one to problaby solve my conflict cause i think i dont need any of the com based resolvers.

Could you explain me how i do a procedure to conflict resolver? if possible the steps, how can i get the publisher table and subscriber table with conflicts, ao can i make some calculations with them and put in the final column to be correct values.

If your could give me some procedure example, or your example, i would be greatfull.
I've read lots of Book online and foruns, and ive not discovered nothing that i need, but i think maybe you could help me.

Thanks in advance

Custom Conflict Resolver

Hi there,

I have created a custom conflict resolver for an article that is using Merge replication. I can register my custom resolver OK, I can change my merge article to use my new custom resolver, but when a conflict occures the replication monitor shows the following errors:

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 'BRANCH' does not have a valid digital signature. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147198713)
Get help: http://help/MSSQL_REPL-2147198713

At first I thought it was because my assembly wasn't signed, so I signed it. I still get the same error.

I have various debug statements in the assembly and I can see that Initialize and HandleChangeStates gets called ok, but no other overrides.

Can anyone help me please?

Thanks

Graham

Hi Graham

When you added the article with sp_addmergearticle did you want the the signature verified?

[@.verify_resolver_signature = ] verify_resolver_signature

Specifies if a digital signature is verified before using a resolver in merge replication. verify_resolver_signature is int, with a default of 0. 0 specifies that the signature will not be verified. 1 specifies that the signature will be verified to see if it is from a trusted source.

See here for more info:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl_11et.asp

Thanks

Nabila Lacey

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Hi there Gravy, i'm new in merge replication, conflict resolution, procedures and more.

I managed to make a replication from a PC to a PPC, and it works, but now i have conflicts updating colums, i never worked with procedures, and i'll have to do one to problaby solve my conflict cause i think i dont need any of the com based resolvers.

Could you explain me how i do a procedure to conflict resolver? if possible the steps, how can i get the publisher table and subscriber table with conflicts, ao can i make some calculations with them and put in the final column to be correct values.

If your could give me some procedure example, or your example, i would be greatfull.
I've read lots of Book online and foruns, and ive not discovered nothing that i need, but i think maybe you could help me.

Thanks in advance

Custom Code in SSAS

Hi,

in AS2000 you could register an own dll to add functionality in MDX for calculations. What is the equivalent in AS2005?

Thanks...

The same except now it is a .NET assembly.

Mosha has some interesting examples on his web site and in his blog.

http://www.mosha.com

http://www.sqljunkies.com/WebLog/mosha/

Enjoy.

_-_-_ Dave

|||

Dave,

thanks, I'll have a look at it...