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)
*** Logboekvermelding voor assembly-binder (08-09-2014 @ 14:39:35) ***
De bewerking is mislukt.
Resultaat van binding: hr = 0x8013101b. Geen beschrijving beschikbaar.
Assembly-beheer geladen vanuit: C:\\Windows\\Microsoft.NET\\Framework\\v2.0.50727\\mscorwks.dll
Wordt uitgevoerd onder uitvoerbaar bestand C:\\Windows\\system32\\odbc\\16\\dbextclr16.exe
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.