Sql CLR UDT error 0x80070002

If you get an error along the lines of

Could not load file or assembly "Assembly Name, Version=xxxx.xxxx.xxxx.xxxx, Cultere=neutral, PublicKeyToken=null' or one of its dependencies.  HRESULT: 0x80070002 The system cannot find the file specified

That error is most likely due to the calling application not being able to load the assembly where the type lives.  To solve this problem, do one of several things:

  • Deploy the assembly to the GAC on your client machine.
  • Copy the assembly to the executable's home directory and then restart the assembly.

Thanks to Niels for the help.


No Comments