Error when attaching file using clr in sqlserver

Question

I have a scalar function in sql server which is using a clr for attaching file while sending mail using the sql procedure "MSDB.DBO.SP_SEND_DBMAIL ".

I am getting the below error whenever I am trying to send mail.

"The client connection security context could not be impersonated. Attaching files require an integrated client login".


Please help to resolve the issue.

Answer 1

Its not syntax error. The exception as I mentioned the post, is for the compact database which is not supported in that machine. There is no exception in those machine, which have installed visual studio.

Answer 2

Hi, as per your question i think you are getting Unhandled Exception due to some programming/coding error.
It might be possible that there is some error in your application or there is something which causes error and throwing exception in your application.
Without seeing any code I cannot blindly say what is the exact problem but I will suggest you, try to add try catch block for your code to handle exceptions. If you are getting this exception when you run your program then check your onLoad form event code or like that to identify the problem.

Best of luck.