Skip to content

v1.0.1

Choose a tag to compare

@ClaneSharke ClaneSharke released this 09 Sep 10:40
· 5 commits to main since this release

Bug fix release.

Fixed

  • Msg 10301 ... references assembly 'system.web.extensions' ... which is not present in the current database when running CREATE ASSEMBLY / calling the proc.
    • Root cause: v1.0.0 used JavaScriptSerializer (System.Web.Extensions), which SQL Server's CLR host does not auto-trust the way it does mscorlib/System/System.Data -- it needed its own separate registration, contradicting the project's whole "only your own assembly needs registering" design.
    • Fix: replaced it with JsonMini.cs, a small dependency-free JSON parser. MailboxReaderClr.dll now references only mscorlib, System, and System.Data -- confirmed via Assembly.GetReferencedAssemblies().

If you deployed v1.0.0 and hit this error: drop the old assembly and trusted-assembly entry, then redeploy using this release's DLL/Deploy.sql/Deploy-Remote.sql.

DROP PROCEDURE dbo.usp_ReadMailbox;
DROP ASSEMBLY MailboxReaderClr;
-- find the old hash: SELECT * FROM sys.trusted_assemblies;
EXEC sys.sp_drop_trusted_assembly @hash = <old hash>;

No functional/parameter changes since v1.0.0 -- same dbo.usp_ReadMailbox signature, both app-only and delegated password (ROPC) auth modes.