I've created a .Net C# function (target Framework is .Net 4.5) which works perfectly with a stored function created with the 'CREATE FUNCTION ...language clr' syntax.
However, if I add extra functionality to the C# function (it references a second DLL, 'DocumentFormat.OpenXml'), the second DLL can't be loaded.
The SQL error reads '...assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded'.
I've used the 'Assembly Binding Log Viewer' tool from Microsoft to analyse the binding process, which reads: (the log is in Dutch, and I only printed the first 5 lines)
I think the dbextclr16.exe is executed using the .Net 2.0 Framework. Am I missing some essential code or isn't this supported (yet) in SQL Anywhere?
I'm using SQL Anyhwere 16.0.0 build 1989
asked 08 Sep '14, 09:42
Thank you for reporting this issue. This bug is known to us and being worked on. A fix will be made available shortly.
answered 08 Sep '14, 14:45