We have some problems using external procedures (using CLR) on client's server. Actually, we do not have problem with the procedure itself, but with the external environment.
When I run the command "Start external environment CLR" in dbisqlc on my PC, there is no problem running it. But, when I run the same command on my client's server, I have the following error : "External environment cannot be started, external process terminated on start up". I tried many things but I could not find the source of the error. The file dbextclr16.exe is correctly located in the Bin32 directory and the .Net framework (2.0, 3.0, 3.5, 4.0) is correctly installed.
When I look in the Event Viewer of the server, I got the following report :
Fault bucket , type 0 Event Name : CLR20r3 Response : Not available Cab Id : 0
Thanks for the feedback
It's probable you are missing a required file. (dll, exe) Do make sure you have the neccessary .Net runtime installed, the documentation indicates you need to have a minimun version 3.5 CLR. dbextclr16.exe does require the .Net provider to be registered and needs some additional dlls.
If this doesn't help any, you may find you'll need to do some tracing of the failure and compare that to a running system. The old sysinternals ProcessMonitor or ProcessExplorer may help out to do some of that. There may also be some .Net CLR tools that may be useful.