locked
.NET CLR error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Trei



    Thursday, March 27, 2014 5:29 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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. 

    Cheers, Bob

    • Proposed as answer by Fanny Liu Thursday, April 3, 2014 11:35 AM
    • Marked as answer by Elvis Long Wednesday, April 9, 2014 6:58 AM
    Sunday, March 30, 2014 10:35 AM