Solved

SQL Server Managed Code Error 'system.core.... was not found in the SQL catalog'

Posted on 2009-05-04
1
587 Views
Last Modified: 2012-05-06
Hi Experts,
I wrote a SP in C# to deploy to SQL Server using VS2008.  The code works fine when I use it in windows app.  But when I push put into C# SP it generates the following error:
Error      1      Assembly 'system.core, version=3.5.0.0, culture=neutral, publickeytoken=b77a5c561934e089.' was not found in the SQL catalog.      

Error      2      'System.Array' does not contain a definition for 'Count' and no extension method 'Count' accepting a first argument of type 'System.Array' could be found (are you missing a using directive or an assembly reference?)      

I have found several links to adding registering System.Core, adding references, etc.  but so far I have been unable to resolve the issue.  I 'think' it has to do with only 13 or so assemblies installed in SQL Server 2005.  Is there a way to add more references?

http://social.technet.microsoft.com/Forums/en-US/sqlnetfx/thread/3dfee9d1-0cfd-48da-a90f-100a7d67ee1c/

http://luke.breuer.com/time/item/SQL2005_using_LINQ_in_SQLCLR/213.aspx

http://social.technet.microsoft.com/Search/en-US/?Query=system.core+was+not+found+in+the+sql+catalog%3b

http://www.google.com/search?hl=en&client=firefox-a&channel=s&rls=org.mozilla%3Aen-US%3Aofficial&hs=XEg&q=Assembly+%27system.core+not+found+in+the+SQL+catalog&btnG=Search

NOTE: When I comment out everything between the drConflicts.Count() == 0 and the end it still gives the errors, when I comment out the if/end then the error goes away.  I am assuming System.array which is not part of the assemblies in SQL Server is the problem?

Thanks in advance your help!
...  

            DataRow[] dRow = dtInRunning.Select("plCallPID = " + pidID);

            DataRow[] drConflicts = dtConflict.Select("pdID = " + pidID);
 

            if (drConflicts.Count() == 0)

            {

                if (dRow.Count() > 0)

                {

                    pidRunningThreadQty = (Int32)dRow[0]["pidCnt"];

                    pidRunningThreadAllowed = (Int32)dRow[0]["pdPIDThreads"];

                    pidRunningClassQty = (Int32)dRow[0]["classCnt"];

                    pidRunningClassAllowed = (Int32)dRow[0]["pdClassThreads"];

                    pidMaxCallsPerDayAllowed = (Int32)dRow[0]["pdMaxCalls"];
 

                    if (pidRunningThreadQty >= pidRunningThreadAllowed)

                    { runPID = false; }

                    if (pidRunningClassQty >= pidRunningClassAllowed)

                    { runPID = false; }

                    //if (pidMaxCallsPerDayQty >= pidMaxCallsPerDayAllowed)

                    //{ runPID = false; }

                }

            }

            else

            {

                runPID = false;

            }  // if (drConflicts.Count(....

Open in new window

0
Comment
Question by:prgMan
1 Comment
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
Comment Utility
did you install .net framework 3.5
and all SW service packs

can you try to do it on VS2005?
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now