Trei Jackson on Thu, 27 Mar 2014 17:29:54
When I try to insert into my DB I get the following error: Common Language Runtime (CLR) v2.0.50727 not installed properly. The CLR is required to use SQL/CLR features..
I have tried running the .NET fix tool as suggested and re-installing .NET 2.0 but with no luck. Has anyone encountered this error? Any help is appreciated.
Let me mention that if I am updating an existing record, there is not an issue.
Win 2003 Server using SQL Server 2005 SP4. have plenty of memory and disc space.
Bob Beauchemin on Sun, 30 Mar 2014 10:35:07
What are you using to insert into your database? You can't insert into SQL Server directly, you need a tool or a client program that connects to the database and issues SQL statements.
An ADO.NET program, SQL Server Management Studio, A stored procedure written in .NET, or something else.
And are you using the same mechanism to update?
And is the client running on the same machine as SQL Server or a different machine?
This sounds like more of a setup issue or a tools issue than a SQLCLR issue, but perhaps we could point you in the right direction.