Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

asked 08 Sep '14, 09:42

Patrick%20Eijkelhardt's gravatar image

Patrick Eijk...
accept rate: 0%

Thank you for reporting this issue. This bug is known to us and being worked on. A fix will be made available shortly.

permanent link

answered 08 Sep '14, 14:45

Karim%20Khamis's gravatar image

Karim Khamis
accept rate: 40%

Thank you for the feedback!

(09 Sep '14, 03:01) Patrick Eijk...
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 08 Sep '14, 09:42

question was seen: 3,349 times

last updated: 09 Sep '14, 03:01