Solved

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

Posted on 2009-05-04
1
589 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
ID: 24326359
did you install .net framework 3.5
and all SW service packs

can you try to do it on VS2005?
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Backup & Restore 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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 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

16 Experts available now in Live!

Get 1:1 Help Now