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.
Wally