whoa… you have all the dotnet stuff correct for the version? There’s a list of things we had to upgrade. We also went to Windows Server 2019. Is that the same?
Tried different version of Microsoft.Data.SqlClient still that error
Got it to work, moved the sql bit out of the bpm into a function passing the function a string for cmdText. Added an assembly for System.Data.SqClient and it worked… why BPMs no longer work I have no idea
OK Bill…
Nice, some light reading for the holidays!
Lok
Thanks,
Tanner Post
We are on 2022.1.27 I’m trying the same thing in a function.
I add the Assembly to the library , looks like it’s the correct version.
Still get that same error you did, when trying to create a SqlConnection object in the function code editor.
can you share how you got that to work?
This might be helpful.
Thank you bmanners
Bill Jackson | Sr ERP Application Developer
O: 401-227-5557
1160 Cranston St | Cranston, RI 02920 | TacoComfort.com