Trouble with different runtime environments of service (.NET Framework) and portal (.NET Core) and System.Data.ODBC

0

Hi,
Could you show used nugets in the solution ?
I had similar problem with Microsoft.Graph.Core

Hi Marco,

we aren't using it and unfortunately I don't have time to check this out on my own.

Maybe you can check out this approach.
https://raluca.encorsa.ro/?p=107

The blog post mentions this project, check out the readme as there may be other options.
https://github.com/Fody/Costura

I've read up on this when the post was released, but I haven't used it myself.

Best regards,
Daniel

I carried out a series of tests and documented them:

My Visual Studio solution / project structure:
- see attached Image "Project Structure - NuGet Packages.png
- there are three projects: 'ClassLibrary', 'ConsoleApp' and 'MoB.ODBCNetStandardTest'
- the target runtime of 'ClassLibrary' is '.NET Standard 2.0' and includes 'System.Data.ODBC' as a required NuGet package
- the target runtime of 'ConsoleApp' is 'NET 6.0' and includes 'ClassLibrary' as a project dependency
- 'MoB.ODBCNetStandardTest' is the plugin package project, targets to '.NET Standard 2.0', includes 'System.Data.ODBC' as a required NuGet package and has no link/dependency to the two other projects

The 'ClassLibrary' / 'ConsoleApp' construct was a hint from WEBCON support in an older support ticket for the 'System.Data.ODBC is not supported on this platform.' error (see below) occurred after changing the portal runtime in 2022.1 by WEBCON.
The trick is to take the 'System.Data.ODBC.dll' file from 'ConsoleApp'\bin\Debug\net6.0\runtimes\win\lib\net6.0 folder and add it to the plugin package zip file.

I ran each test in three variations of how the System.Data.ODBC.dll is published, with three System.Data.ODBC NuGet package versions and on both my Win11 and a Win2k22 system.

Each test followed these steps:
- adjust included System.Data.ODBC NuGet Package version
- clean solution
- build each solution project (order: 'ClassLibrary', 'ConsoleApp', 'MoB.ODBCNetStandardTest')
- publish WEBCON plugin package
- (optional) add System.Data.ODBC.dll to the plugin package zip file
- upload plugin package in WEBCON Designer Studio
- stop IIS app pool
- restart WEBCON Workflow Service
- start IIS app pool
- refresh WEBCON Portal site on the browser
- execute form action (global action / 'Menu button') on the browser to execute the plugin at portal (.NET runtime)
- execute form action (global action / 'On start (cyclical)') on the designer studio to execute the plugin at service (.NET Framework runtime)

The rusults in short:
Only on my local Win11 developer client System.Data.ODBC only works in version 6.0.0.0 within the service. I will post the results next (only one image allowed per post at this forum?)

Here is a picture of my test series...

Thank you for this hint, but didn't work. I get the 'System.Data.ODBC is not supported on this platform.' error when using Fody/Costura.

(see my first reply today, I've replied to the wrong reply)

Hi Marco,

which WEBCON BPS Version are you running? Is it using .NetCore 6 or older?

If stumbled across this one:

https://github.com/dotnet/runtime/issues/898

Fix the issue by matching the System.Data.Odbc package version relative to the dotnet version you are on. Example, if you are on .net 5, go to System.Data.Odbc package and make sure you are also on one of the versions starting with 5.


Regarding screenshots.
You can add more, when you edit the post. :)

Best regards,
Daniel

WEBCON BPS 2023.1.2.123 with .NET 6.0.8