Calling A .Net Assembly From Script Component Giving Error

ALTER ASSEMBLY Error Msg 6509 An Error Occurred While Gathering Metadata From Assembly ‘&&<Assembly Name&&>’ With HRESULT 0x1.
I work with February CTP of SqlServer 2008.
I have an Assembly with several UDTs inside. Version of assembly is 1.0.*
I use CREATE ASSEMBLY statement to register this assembly, and it runs without any errors. Then I rebuild CLR solution without doing any changes in source code. In that case the only difference between new and old assemblies is version (difference in fourth part of version).
Then I try to update assembly in SqlServer. I use
ALTER ASSEMBLY <name>
FROM <path>
WITH PERMISSION_SET = UNSAFE, UNCHECKED DATA
statement for this. Statement runs with error:
Msg 6509An error occurred while gathering metadata from assembly €˜<Assembly name>€™ with HRESULT 0x1.
I found the list of condition for ALTER ASSEMBLY in MSDN:
ALTER ASSEMBLY statement cannot be used to change the following:
·         The signatures of CLR functions, aggregate functions, stored procedures, and triggers in an instance of SQL Server that reference the assembly. ALTER ASSEMBLY fails when SQL Server cannot rebind .NET Framework database objects in SQL Server with the new version of the assembly.
·         The signatures of methods in the assembly that are called from other assemblies.
·         The list of assemblies that depend on the assembly, as referenced in the DependentList property of the assembly.
·         The indexability of a method, unless there are no indexes or persisted computed columns depending on that method, either directly or indirectly.
·         The FillRow method name attribute for CLR table-valued functions.
·         The Accumulate and Terminate method signature for user-defined aggregates.
·         System assemblies.
·         Assembly ownership. Use ALTER AUTHORIZATION (Transact-SQL) instead.
Additionally, for assemblies that implement user-defined types, ALTER ASSEMBLY can be used for making only the following changes:
·         Modifying public methods of the user-defined type class, as long as signatures or attributes are not changed.
·         Adding new public methods.
·         Modifying private methods in any way.
 
But I haven€™t done any changes in source code, so new version of assembly satisfies all this conditions.
What could be the reason for such behavior?
P.S. I€™ve got the same error, if I add or change any method in assembly before rebuilding.
 
 

View Replies !   View Related

---

Calling VB Based SQLCLR Function Failed With Error Can't Load System.Web Assembly
I created a CLR function based on following VB code:

 

Imports Microsoft.SqlServer.Server

Public Partial Class SqlClrVB

  <Microsoft.SqlServer.Server.SqlFunction()> _

  Public Shared Function GetTotalPhysicalMemory() As Integer

    GetTotalPhysicalMemory = My.Computer.Info.TotalPhysicalMemory

  End Function

End Class

 

The VB code was complied into a DLL called totalmem.dll and call following TSQL to map it into a SQL function:

 

create assembly totalmem from '!WORKINGDIR! otalmem.dll'

WITH PERMISSION_SET=UNSAFE

go

create function fnGetTotalMem()

returns int

as external name totalmem.SqlClrVB.GetTotalPhysicalMemory

go

 

When I call this function, it returned following error:

select dbo.fnGetTotalMem()

 

Msg 6522, Level 16, State 2, Line 0

A .NET Framework error occurred during execution of user defined routine or aggregate 'fnGetTotalMem':

System.IO.FileNotFoundException: Could not load file or assembly 'System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

System.IO.FileNotFoundException:

at Microsoft.VisualBasic.MyServices.Internal.ContextValue`1.get_Value()

at My.MyProject.ThreadSafeObjectProvider`1.get_GetInstance()

at SqlClrVB.GetTotalPhysicalMemory()

.

 

Anyone knows why I'm hitting this error? I didn't reference any System.Web interface why it needs to load System.Web assembly? The same code runs OK if I compile it as a separate VB application out side of SQL Server 2005.

 

Thanks much,

 

Zhiqiang

 

View Replies !   View Related

---

Calling CLR Stored Procedure From Within A CLR Table-valued Function Giving Errors
We are trying to create a TVF that executes a CLR Stored Procedure we wrote to use the results from the SP and transform them for the purposes of returning to the user as a table.

 




Code Snippet

[SqlFunction ( FillRowMethodName = "FillRow",

TableDefinition = "CustomerID nvarchar(MAX)",

SystemDataAccess = SystemDataAccessKind.Read,

DataAccess = DataAccessKind.Read,

IsDeterministic=false)]

public static IEnumerable GetWishlist () {

using (SqlConnection conn = new SqlConnection ( "Context Connection=true" )) {

List<string> myList = new List<string> ();

conn.Open ();

SqlCommand command = conn.CreateCommand ();

command.CommandText = "GetObject";

command.Parameters.AddWithValue ( "@map", "Item" );

command.CommandType = System.Data.CommandType.StoredProcedure;

using ( SqlDataReader reader = command.ExecuteReader ( System.Data.CommandBehavior.SingleRow )) {

if (reader.Read ()) {

myList.Add ( reader[0] as string );

}

}



return (IEnumerable)myList;

}

}

 

When command.ExecuteReader is called, I am getting an "Object not defined" error.  However, the stored procedure can be used in SQL Management Studio just fine.

 




Code SnippetEXEC GetObject 'Item'

 

Is there some sorf of trick I am missing?

 

Thank you!

 

View Replies !   View Related

---

Calling .net Assembly In DTS Package
Hi everyone,   I want to call the .net assembly(DLL) in a DTS package. Can anyone help me as to how to achieve this. I read numerous articles on internet, but couldn't find the one that can help me with this problem.Any help or directing me to an article will be greatly appreciated.Thanks.Vinki

View Replies !   View Related

---

Calling A C# Assembly From SQL Server 2005
Hi,
 I have got a simple C# assembly which call a ASP.net web service and executes a webmethod, now i want to call this assembly from sql server 2005 within the sql server function. can any body let me know how to do it.
Thanks

View Replies !   View Related

---

Registering A Assembly And Calling It From Managemnet Studio
 

Hi everyone,
 

i am trying to register a assembly in SSAS which i actually did fine as per BOL by right clicking on assembly folder and pointing to the dll file. And then i tried to call the function from management studio using Call command and Select statement...both outputs a error which looks like

 

Executing the query ...

Query (1, 6) The '[TestKPIMeasures].[KPIMeasures].[getKPIData]' function does not exist.

Execution complete

 
Let me explain my scenario so that you ll get a better picture. I have a cube named 'FourH KPI values' and i have registerd the below as dll file.

 

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using Microsoft.AnalysisServices.AdomdClient;

using System.Reflection;

using System.Reflection.Emit;

namespace TestKPIMeasures

{

public class KPIMeasures

{

public static System.Data.DataTable getKPIData(String Connstring, String ExecCommand, String kpimeasures)

{

CellSet cellset;

//DataSet ds = new DataSet("KpiDataSet");

DataTable dt = new DataTable("KpiMeasures");

// ds.Tables.Add("KpiMeasures");

try

{

//Create AdomdConnection object

AdomdConnection asConnection = new AdomdConnection(Connstring);

asConnection.Open();

String[] keyindicators = kpimeasures.Split(',');

string commandText = ExecCommand;

AdomdCommand command = new AdomdCommand(commandText, asConnection);

DataColumn column = new DataColumn();

column = new DataColumn("KPI Name");

column.DataType = typeof(string);

dt.Columns.Add(column);

column = new DataColumn("KPI value");

column.DataType = typeof(string);

dt.Columns.Add(column);

column = new DataColumn("KPI goal");

column.DataType = typeof(string);

dt.Columns.Add(column);

column = new DataColumn("KPI status"); column.DataType = typeof(string);

dt.Columns.Add(column);

 

foreach (string item in keyindicators)

{

command.Parameters.Clear();

command.Parameters.Add(new AdomdParameter("Value", item));

command.Parameters.Add(new AdomdParameter("Goal", item));

command.Parameters.Add(new AdomdParameter("Status", item));

command.Parameters.Add(new AdomdParameter("Trend", item));

cellset = command.ExecuteCellSet();

DataRow row = dt.NewRow();

row["KPI NamE"] = item;

row["KPI value"] = cellset.Cells[0].FormattedValue;

row["KPI goal"] = cellset.Cells[1].FormattedValue;

row["KPI status"] = cellset.Cells[2].FormattedValue;

dt.Rows.Add(row);

}

}

catch (Exception ex)

{

throw ex;

}

return dt;

}

}

}

 
Now i am trying to call the assembly from management studio,
 

CALL TestKPIMeasures.KPIMeasures.getKPIData("Provider=MSOLAP.3;DataSource=D64ETL01;Initial Catalog=FourH KPI values", "SELECT{KPIValue(@Value), KPIGoal(@Goal), KPIStatus(@Status)} ON COLUMNS FROM [Key Performance Indicators]", "Test measure,Test measure 2,KPI 3")
 
also tried Select statment...still no luck
 
Can anyone tell me what i am missing out.......Thanks in advance
 
 

View Replies !   View Related

---

Could Script Task Component Uses A Framework 1.1 Assembly?
TIA

View Replies !   View Related

---

Calling .Net Assembly Or Dll From SQL Server 2005 At Config Level 80
Hi,
I create a dll assembly with the strong name in VB.Net environment.
Created assembly is registered also.
SQL Server 2005 configuraton level is set at "80"
I want to call that assembly from stored procedure with the database config level at "80"
But when i execute the stored proecure i get the following error
Error Source: "ODSOLE Extended Procedure"
Description: "Invalid Class String"

My Code in VB.Net is given below:
Imports System
Imports System.Reflection
Imports System.Globalization
Imports System.IO
Imports System.data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports Microsoft.VisualBasic
Imports System.Diagnostics
Imports GreatDataAccess

Namespace Test
Public Class clsTest

        Public Shared Sub GenTest()
              ''''............ some code is here
       End Sub
End Class
End Namespace

Stored Procedure
CREATE PROCEDURE [dbo].[PPGenerateFile]
AS
BEGIN
Declare @retVal INT
Declare @comHandler INT
declare @errorSource nvarchar(500)
declare @errorDescription nvarchar(500)
declare @retString nvarchar(100)

-- Intialize the COM component

EXEC @retVal = sp_OACreate Test.clsTest, @comHandler OUTPUT
       IF(@retVal <> 0)
       BEGIN
          --Trap errors if any
          EXEC sp_OAGetErrorInfo @comHandler,@errorSource OUTPUT, @errorDescription OUTPUT 
         SELECT [error source] = @errorsource, [Description] = @errordescription
         Return
       END



-- Call a method into the component

      EXEC @retVal = sp_OAMethod @comHandler,'GenTest()',@retString

IF (@retVal <>0 )
BEGIN
EXEC sp_OAGetErrorInfo @comHandler,@errorSource OUTPUT, @errorDescription OUTPUT
SELECT [error source] = @errorsource, [Description] = @errordescription
Return
END
select @retString

END






Please Help me to solve this problem.

View Replies !   View Related

---

Calling .net Assembly In Script Task When Executing Via Web Service
I have a web service that executes packages using the object model. One of my packages calls a .net assembly from a script task. The .net assembly provides custom logging and sends an email with the package execution results. When I use remote desktop connection to conect to the server and execute that package using dtexeui.exe it runs with no problems. When I call the package via the web service I can access the file system throughout the network and various databases but it says it can't open the .net assembly. The web service runs under an application pool with administrator rights to the server and database. Does anyone know what the problem is or more importantly, what the solution is?

View Replies !   View Related

---

How To Call A DotNet Assembly In SSIS Script Component
I tried to access a dot net assembly (.dll) file in ssis script component using following steps.


Create new Script Task in Data Flow Task
Edit Design Script button-> Loads script Project in MS VSA
Locate Object Browser
Select Custom Component Set from the dropdown and hit browse button
Browse and place the custom component dll (This Custom component dll has to be in GAC - Global assembly cache before browsing)
Select the namespace from the Component list of the object browser and click on €œAdd to references to Selected project in the solution explorer€? button
Write Imports <namespace> in the script code to invoke class methods from the .NET custom component
The following steps worked properly with June CTP version of yukon.In september CTP version of Yukon in SSIS  when i browse the dot net assembly with the same above steps i get a error stating " The file could not be browsed ".Can anybody help me in the same.
 
Prashant Utekar

View Replies !   View Related

---

Error Registering Assembly Using CREATE ASSEMBLY
We have written a test CRL stored procedure to test replacing one of our complex stored procedures but can€™t get it deployed to our SQL server that hosts a mirrored configuration of our production database (very locked down). It works fine on our development instances (not very locked down). It only references the default assemblies that were added when we created the project. All it does is use Context Connection=true to get data, loops though some records and returns the data using SQLContext. CLR is enabled on SQL server, the assembly is strongly signed, and we tried deploy using the binary string with the SAFE setting.
 

 CREATE ASSEMBLY for assembly 'SQLCLRTest2' failed because assembly 'SQLCLRTest2' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
[ : SQLCLRTest2.StoredProcedures::GetLift][mdToken=0x600001e] Type load failed.
[token  0x02000008] Type load failed.
 

View Replies !   View Related

---

System.Windows.Form Assembly Is Needed On Script Component Task?
That affects only interface design... so that it doesn't exists at all in a SSIS.

What is it for??

Let me know your view on this or any clarification.

View Replies !   View Related

---

What Component To Use For Calling View
In SSIS 2005 what component can I use inside my Data Flow task to call my View and use it as a datasource?  I know I've used an Execute T-SQL Task but I don't know what component to use inside an actual task itself.  What I'm trying to do is in my Data Flow task, instead of using 3 OLE DB Source components, I want to actually call 3 stored procs and use those 3 components as the data sources to merge on using the merge and sort components later on

View Replies !   View Related

---

Calling A Serviced Component From A SQL CLR Function
Hi
Trying to call a component hosted in COM+ from my SQL CLR function. At first it seams System.EnterpriseServices is not deployed in sql so I used the CREATE ASSEMBLY command to add it, and redeployd my function.
 
Then it complains it can€™t load System.EnterpriseServices.Wrapper.dll, so I tried creating this one as well, the same way. I then get an exception that sais:
 
€œFailed to open assembly €˜SystemEnterpriseServiceWrapper€™€¦€?
 
Does any one have a clue, to what I should do to call a Serviced Component?

View Replies !   View Related

---

Error: CREATE ASSEMBLY For Assembly
I am trying to deploy a Database Project with Visual Studio 2005 and SQL Server 2005 Standard.
I import €œSystem.IO€? and have therefore set the permission levels to EXTERNAL_ACCESS.
 
I am receiving the same error message that many folks have received.
 
CREATE ASSEMBLY for assembly 'Images' failed because assembly 'Images' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS. 
The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. If you have restored or attached this database, make sure the database owner is mapped to the correct login on this server. If not, use sp_changedbowner to fix the problem. Images.
 
My CLR access is €œon€?
 
I have tried
 
1)       From master run: GRANT EXTERNAL ACCESS ASSEMBLY to [BuiltinAdministrators].
2)       From master run: GRANT EXTERNAL ACCESS ASSEMBLY to  €œMy Windows Authentication ID€?.
3)       Run ALTER DATABASE MYDATABASE SET TRUSTWORTHY ON
4)       In Visual Studio .NET 2005 Set the permission levels to €˜external€™
5)       Tried BuiltinAdministrators and my SQL Server Windows Authenticated Login ID  for the ASSEMBLY OWNER.
 
I can compile BUT NOT DEPLOY
 
Any help would be greatly appreciated.
Regards Steve

View Replies !   View Related

---

Sp Giving Error
i have to get the maximum into a output parameter. its giving error. whats the problem with this code

SET @supplier_code as EXECUTE (SELECT MAX(supplier_code)+1 AS Supp_Id FROM supplier)

suji

View Replies !   View Related

---

BCP Giving Error &#34;unexpected Eof&#34;
Hi ,

I am trying to import a .csv file to SQL server 6.5, I get the db library error "Unexpected EOF encountered in BCP data-file"

What can be the problem with the file ?
Its very important to load this data.

Any help is appreciated.

Thanks
Ajay

View Replies !   View Related

---

My DTS Package Is Giving An Error When Trying Run From The JOB
Hi,
 
I have imported a DTS package to sql 2005. I am trying to run this DTS package from the JOB using DTSRun. and i am getting the following error. I thought it was some issue with the SQL Agent serivice account which this is running, i have created a proxy which has super privilages.. but still the job is failing. When i run the DTS package directly it's running fine.
 
I am confused !!!!!
 
 
Message
Executed as user: AMRsql_seasdv. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnError:  DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005)      Error string:  Login failed for user ''. The user is not associated with a trusted SQL Server connection.      Error source:  Microsoft OLE DB Provider for SQL Server      Help file:        Help context:  0      Error Detail Records:      Error:  -2147467259 (80004005); Provider Error:  18452 (4814)      Error string:  Login failed for user ''. The user is not associated with a trusted SQL Server connection.      Error source:  Microsoft OLE DB Provider for SQL Server      Help file:        Help context:  0      DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun:  Package execution complete.  Process Exit Code 1.  The step failed.
Dev

View Replies !   View Related

---

Check This With It Is Giving An Error.
 

WITH ProccessedYesNO AS

(

select ClaimNumber, Surname, FirstName,  CASE WHEN New= 0 THEN 'Yes' ELSE 'No' END AS Processed

from EntryTable)
Select * from ProcessedYesNo Where Ignore_dupe='Yes';

 
 
why I am getting an syntex error I check the query it is ok atleast the inner query is running but when I apply the with
than I am getting Syntax error near 'WITH'

View Replies !   View Related

---

Union Giving Me Error Msg About Distinct Use
when i try to run this following query, i get an error message:


Microsoft OLE DB Provider for SQL Server error '80040e14'

The ntext data type cannot be selected as DISTINCT because it is not comparable.

/resultados_termo.asp, line 176


the query:

select * from view_veiculos where ativo='1' and ( nome_marc like
'%fiat%' or nome_mod like '%fiat%' or estado like '%fiat%' or cidade
like '%fiat%' or ano like '%fiat%' ) and ( nome_marc like '%brava%' or
nome_mod like '%brava%' or estado like '%brava%' or cidade like
'%brava%' or ano like '%brava%' ) and ( nome_marc like '%2004%' or
nome_mod like '%2004%' or estado like '%2004%' or cidade like '%2004%'
or ano like '%2004%' ) union
select * from view_veiculos where ativo='1' and ( nome_marc like
'%fiat%' or nome_mod like '%fiat%' or estado like '%fiat%' or cidade
like '%fiat%' or ano like '%fiat%' ) and ( nome_marc like '%brava%' or
nome_mod like '%brava%' or estado like '%brava%' or cidade like
'%brava%' or ano like '%brava%' ) union
select * from view_veiculos where ativo='1' and ( nome_marc like
'%fiat%' or nome_mod like '%fiat%' or estado like '%fiat%' or cidade
like '%fiat%' or ano like '%fiat%' ) union
select * from view_veiculos where ativo='1' and ( nome_marc like
'%brava%' or nome_mod like '%brava%' or estado like '%brava%' or cidade
like '%brava%' or ano like '%brava%' ) and ( nome_marc like '%2004%' or
nome_mod like '%2004%' or estado like '%2004%' or cidade like '%2004%'
or ano like '%2004%' ) union
select * from view_veiculos where ativo='1' and ( nome_marc like
'%brava%' or nome_mod like '%brava%' or estado like '%brava%' or cidade
like '%brava%' or ano like '%brava%' ) union
select * from view_veiculos where ativo='1' and ( nome_marc like
'%2004%' or nome_mod like '%2004%' or estado like '%2004%' or cidade
like '%2004%' or ano like '%2004%' )


when i use UNION ALL, i get repeated rows. i need the select distinct on it.

please, help.

thanks in advance.

View Replies !   View Related

---

Select Row_Number() Giving Me An Error
here it is:
 
SELECT * FROM (    SELECT        ROW_NUMBER() Over (Order By LastActivity ASC) As rn        UserName)    FROM aspnet_usersWhere rn = 1
 
 
it's saying: "Incorrect syntax near UserName"
all column/table names are correct

View Replies !   View Related

---

Distinct Count With Over Giving An Error
We have a table of students with fields for the ID of the school district and their school name.  For example:



DistrictID
StudentName
SchoolName

10001
John Smith
Washington Elementary

10001
Jane Smith
Lincoln Middle

10002
David White
Hill High

...
...
...
 
 
I want is a listing with the school district ID, the student name, and the number of schools in the district.
 
I believe the following statement should give me what I want:

SELECT DistrictID, StudentName, COUNT(DISTINCT SchoolName) OVER (PARTITION BY DistrictID)

FROM StudentData

 
However, I get the error:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'distinct'.
 
If I take out the DISTINCT it runs fine, however it counts all the rows as expected, which is not what I want.
If I remove the OVER clause it runs fine, however, it counds the schools across all the districts, which is not what I want.
I can remove the OVER clause and use GROUP BY, but not while also retrieving StudentName.

 
The SQL 2005 Online Books don't seem to indicate that my statement is invalid.  Here are the links just for reference:
Count: http://msdn2.microsoft.com/en-us/library/ms175997.aspx
Over: http://msdn2.microsoft.com/en-us/library/ms189461.aspx
 
Anyone have an idea one what I'm doing wrong or how to go about getting this information?
Thanks!
Matt Penner

View Replies !   View Related

---

SQL Sever Not Installing - Giving Error - Plz Help
Hi,

I'm trying to install Sql Server 2005 Express Edition making it as one of the pre-requisities of an windows app using click once deployment tech and in one system every time i'm getting an error that "An error occured attempting to install myappname". Here its pointing to an log file called install.log which is as follows-

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package 'Microsoft Data Access Components 2.8', phase BuildList
Reading value 'FullInstallVer' of registry key 'HKLMSoftwareMicrosoftDataAccess'
Read string value '2.81.1117.0'
Setting value '2.81.1117.0 {string}' for property 'MDACVersion'
The following properties have been set for package 'Microsoft Data Access Components 2.8':
Property: [MDACVersion] = 2.81.1117.0 {string}
Running checks for command 'MDAC28mdac_typ.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'MDACVersion' and value '2.80': true
Result of checks for command 'MDAC28mdac_typ.exe' is 'Bypass'
'Microsoft Data Access Components 2.8' RunCheck result: No Install Needed
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:DOCUME~1JOEMER~1LOCALS~1TempVSD567.tmpdotnetfxdotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLMSoftwareMicrosoftInternet Explorer'
Read string value '7.0.5730.11'
Setting value '7.0.5730.11 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 7.0.5730.11 {string}
Running checks for command 'dotnetfxinstmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfxinstmsia.exe' is 'Bypass'
Running checks for command 'dotnetfxWindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfxWindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfxdotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfxdotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'Windows Installer 3.1', phase BuildList
The following properties have been set for package 'Windows Installer 3.1':
Running checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true
Result of checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
'Windows Installer 3.1' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:DOCUME~1JOEMER~1LOCALS~1TempVSD567.tmpSqlExpressSqlExpressChk.exe"
Process exited with code 0
Setting value '0 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 0 {int}
Running checks for command 'SqlExpresssqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': true
Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpresssqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': true
Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Bypass'
'SQL Server 2005 Express Edition' RunCheck result: No Install Needed
Launching Application.
Running command 'http://reporterapp.stats.com/reporter/BasketballDataCollection.application' with arguments ''
ShellExecuteEx failed with error code 1155
Error: The following error occurred attempting to install 'http://reporterapp.stats.com/reporter/BasketballDataCollection.application':
"No application is associated with the specified file for this operation. "

View Replies !   View Related

---

Database Keeps Giving Timeout Error
Hi All,

since the last upgrade SQL 2000 --> 2005, the biggest database I am working on (1.4 GB, with loads of binary data) keeps freezin at least one time per week. When I say 'freezin' I mean that you cannot query some of the tables as it gives a timeout error when trying.

I am not a DBA and I don't have any idea of what to do, the only thing which comes to my mind is that this database is too big, as if I go to the preperties window it says Space Available: 38 MB (what's that? there's really only 38 MB on this DB?).
I tried re-writing all mainteinment plans (full backup every night, log backup every hour), but I realized that the database keeps freezing (and the backup jobs keep running untill you stop them).

anyone could give any hint?

Thanks in advance,

Giovanni Idili

View Replies !   View Related

---

Exit Activex Script Without Giving An Error?
I am using ActiveX Script tasks to branch out on the different tasks that I have within the DTS. When I want a particular branch of tasks not to be executed, I give a "Main = DTSStepScriptResult_DontExecuteTask"

This seems to be working fine in terms of functionality, but there is an error that is displayed saying "Task reported failure on execution".

How do I get rid of this? I need to exit the task, and still just get one message box at the end of it all that happily reads "Succesfully completed tasks"

View Replies !   View Related

---

Please Help! Sql Server 7.0 Crashes Giving A NT Event Log Error.
When I try to manually run one of my scheduled job, DR. Watson comes up and SQL Server crashes. the following error message is received in the NT event log. "Unable to read local Event log, reason the data area passed to a system call is too small". I am new to SQL and this is causing me some degree of stress!!!! Also please recommend a good book for a newbie like me.

Thanks in advance.

View Replies !   View Related

---

Running ActiveX Script Giving Error
Hi,

We are moving our maintenance jobs from SQL Server 2000 to SQL Server 2005 and getting following error when it tried to run ActiveX script at 1 of the steps:
"error creating security descriptor for shared objects(reason: No mapping between account names and security IDs was done)
I tried running the job as "SA" user and "Windows Admin" user but still the same issue, What need to be done to fix this issue?

Thanks
--rubs

View Replies !   View Related

---

Calling COM Component In SQl Server 2005 (Visual Basic 2005).
 

Hi,
 
I have created a class library in VB.NET 2005 - (Project name is - MySample):

ISample.vb
=========

Public Interface ISample
    Function getSum(ByVal a As Integer, ByVal b As Integer) As Integer
End Interface

CSample.vb
========

Public Class CSample
    Implements ISample
    Public Function getSum(ByVal a As Integer, ByVal b As Integer) As Integer Implements ISample.getSum
        Return a + b
    End Function
End Class

I have registered the assembly in GAC as well as I have used REGASM tool to register it as COM component.

In SQL Server 2005 I have used the following script to call the COM component:

USE Sample
GO

-- Declare the variables

DECLARE @executionResult int
DECLARE @result varchar(200)
DECLARE @hnd int

-- Execute the COM component

EXEC @executionResult = sp_OACreate 'MySample.CSample', @hnd OUTPUT
EXEC @executionResult = sp_OAMethod @hnd, 'getSum', @result OUTPUT, 10, 20
EXEC @executionResult = sp_OADestroy @hnd

-- Display the result

SELECT @result

I have got NULL as result (Expected result is : 30). Can you please FIX my code and let me know where i am missing ?

Thanks
 
 

View Replies !   View Related

---

SQL Agent Jobs Giving General Network Error
transferred datbases and SQLagentjobs to a new server. Trying to execute sqlagent jobs
gives

ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message 258) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.

External Comminications seem OK

Any ideas what to do about this

Thanks

View Replies !   View Related

---

NEED HELP With Windows Installer GIVING ERROR: 1067 When INSTALLING
I know this problem has been resolved, but it sure as hell hasn't for me.  For whatever reason, the operation aborts every time I try to install or uninstall something.  The same thing occurs whether installing software or using Add/Remove Programs.  I've tried everything and read everything for the last 6 hours.  It's 2:45am where I live.  I'm pist.  Someone, please, help me...


It gives be Error: 1067 for operation aborted.  I've messed with every nook and cranny, even to teh point of almost adding a new string to the operation so as to bypass it.  It didn't work by the way, because there was another file that was still there and had the intended name.  I've checked teh settings as well.  All is good.  Tell me what I am doing wrong!!??

View Replies !   View Related

---

Why Is SQL 2005 Giving A Msg 511, Exceeded Max Row Size Of 8060 Error?
A simple alter statement to populate a column is giving the error below.
 UPDATE AM_PROFILE_4101_0 SET _92284 = CONVERT(varchar(1000),fv.varcharValue)
    FROM AM_PROFILE_4101_0 pt
    INNER JOIN cyfield_value fv ON fv.fieldID = 92284 AND pt.AM_PROFILE_ID = fv.AMid


Cannot create a row of size 8125 which is greater than the allowable maximum of 8060.
The table as many varchar(max) columns such as _92284, and many are populated with around 1000 bytes of data. Everything I'm reading tells me SQL 2005 supports large row sizes. But why is this error still coming up.

Other usage info: These numbered columns (i.e. _92284) are dropped, added, and repopulated with data every night.

Any ideas would be appreciated.

Thank you!

View Replies !   View Related

---

Function Returing As Double But When Called Giving An Error
Hello all,

      This is the Function:

 Public Dim GrossValue As double = 0.00

 Public Function GetGrossValue(ByVal dPymt as Double,ByVal dFlag as Boolean) As Double
         If(dFlag = False) Then
                GrossValue = GrossValue + dPymt
                Return GrossValue
         Else
                Return 0.00
          End If     
 End Function

 Public Function ResetValue()
          GrossValue = 0.00
 End Function


    I am calling this function in a textbox

=IIF(Fields!IsEarnCancelled.Value,
          Nothing,
          (Code.GetGrossValue(Fields!Gross.Value,Fields!IsEarnCancelled.Value)))

   I DO NOT KNOW where I am doing wrong. But it is giving me "The Value expression for the textbox ''textbox200" contains an error: Input string was not in correct format.

   Please help

View Replies !   View Related

---

Enable Error Handling When Writing Custom Source Component /custom Error Handling Component.
1) We are  writing a custome Source component for Oracle with OCI calls, Could some one please let me know how to Enable Error Handling for the Same,

2) Is it possible to write Custome Error Handeling Component for SSIS? if yes could you please help me on how to write it.

Thanks in advance.

 

View Replies !   View Related

---

Stored Procedure Giving Error When Searching On Date Range
I've  a report whose columns are returned from a stored procedure. Now I want to display the report based on a date range. The date field is Received. It's in dbo.master. I added 2 parameters start date and end date. When I check the condition if dbo.master.Received>StartDate and dbo.master.Received < EndDate directly I'm getting error. Could someone tell me what mistake I'm doing? Thanks for your help!ALTER Procedure [dbo].[USP_Reports_NewTier1]
 
@ClientCode VARCHAR(7) = '',@UserID INT = 0
,@OrderID INT =0
,@StartDate datetime,@EndDate datetime
 
IF @ClientCode <> '' and dbo.master.Received > StartDate and dbo.master.Received<EndDateBEGIN SELECT --Root Select --ClientName @ClientName = (Select Name  FROM dbo.customer c     WHERE   c.Customer = @ClientCode)     ,@TotalDollarValue = (SELECT SUM(m.current1-m.paid1)     FROM dbo.master m     WHERE phase=1     AND m.Customer = @ClientCode    AND M.Status <> 'PIE')
 ,@AverageAge = ISNULL((select avg(age) from    (select datediff(day,Received,CASE WHEN clidlp>clidlc then clidlp else clidlc END)* -1 as age    from dbo. master M    WHERE phase=1 AND customer = @ClientCode AND M.Status <> 'PIE') x),0)END

View Replies !   View Related

---

OLEDB Command Giving Error For Decalre And Set Statements At The Top Of The SQL Script
Hi All,
 
I have an OLEDB command in my package that has to execute some SQL script.
But when I declare and set a variable at the top of all code, The OLEDB gives an error in column mappings tab.
 
My DQL script is as shown below
DECLARE  @Cost AS  money
SET @Cost=?
--Some update statements a table
OLEDB Command works if write the declare and set statements after update statements. Like below. But I don€™t need it.
 
--Some update statements a table
DECLARE  @Cost AS  money
SET @Cost=?
 
I also observer that,Oledb Command  gives error for the code given below.
Just paste the following Script in OLEDB command, it gives error in column mapping tab  
DECLARE  @Cost AS  money
SET @Cost=?
Any Idea on this behaviour?

Thanks in advance..

View Replies !   View Related

---

Msg 6573 Method, Property Or Field In Assembly Is Not Static. VB.Net Assembly In SQL Server Problem
 

I am trying to get a function I created in VB 5 for Access and Excel to work in SQL 2005. I was able to update the old VB code to work in VB 2005. I compiled and made a .dll, and I was able to register the new Assembly in SQL Server. When I try to create the Function, I get an error:
 

CREATE FUNCTION dbo.Temperature(@FluidName char, @InpCode Char, @Units Char, @Prop1 varchar, @Prop2 varChar)

RETURNS VarChar

AS EXTERNAL NAME FluidProps.[FluidProps.FluidProperties.Fluids].Temperature

 
Error returned:
 

Msg 6573, Level 16, State 1, Procedure Temperature, Line 21

Method, property or field 'Temperature' of class 'FluidProps.FluidProperties.Fluids' in assembly 'FluidProps' is not static.

 
 
Here is the code (part of it) in the VB class:
 
Header:
 

Imports Microsoft.SqlServer.Server

Imports System.Data.SqlClient

Imports System.Runtime.InteropServices

Imports System.Security

Imports System.Security.Permissions

 

 

Namespace FluidProperties



'Option Strict Off

'Option Explicit On

Public Partial Class Fluids
 
Function:
 

Function Temperature(ByRef FluidName As Object, ByRef InpCode As Object, ByRef Units As Object, ByRef Prop1 As Object, Optional ByRef Prop2 As Object = Nothing) As Object

Call CalcProp(FluidName, InpCode, Units, Prop1, Prop2)

Temperature = ConvertUnits("-T", Units, T, 0)

End Function
 

If I change the Function Temperature to Static, I get an error that functions cannot be Static. Its been a long time since I created the code and am having a hard time in my older age of getting the cobwebs out to make it work.
 
I have no problem getting the function to work if I call it from a VB form....so what do I need to do to get it to work on data in my SQL server?
 
Thanks
 
Buck

View Replies !   View Related

---

Creating A System.Management Assembly In Order For My Own Assembly To Work?
Hi

I am a bit paranoid about what I just did to my SQL Server 2005 with this CLR experiment.

I created a Class Lib in C# called inLineLib that has a class Queue which represents an object  with an ID field.

in another separate namespace called inLineCLRsql, I created a class called test which will hold the function to be accessed from DB,  I referenced and created an instances of the Queue class, and retrieve it's ID in a function called PrintMessage.

namespace inlineCLRsql{


public static class test{


public static void PrintMessage(){



inLineLib.Queue q = new inLineLib.Queue();

int i = q.queueId ;

Microsoft.SqlServer.Server.SqlContext.Pipe.Send(i.ToString());



}

}

}

to access this from the db, I attempted to create an assembley referencing inLineCLRsql.dll. This didn't work as it complained about inLineLib assembly not existing in the db. I then attempted to create an assembley for  inLineLib but it barfed saying  System.Management assembly not created.

so what I did is (and this is where I need to know if I just ruined sql server or not):

1- ALTER DATABASE myDB SET TRUSTWORTHY ON;.

2- CREATE ASSEMBLY SystemManagement

FROM 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727System.Management.dll'

WITH PERMISSION_SET = UNSAFE

3- CREATE ASSEMBLY inLineLibMaster

FROM 'D:inLineServerinLineLibinDebuginLineLib.dll'

WITH PERMISSION_SET = unsafe

4- and finally

CREATE ASSEMBLY inLineLib

FROM 'D:inLineServerCLRSQLinlineCLRsqlinDebuginlineCLRsql.dll'

WITH PERMISSION_SET = SAFE

 

Everything works after those steps (which took some trial and error). I can create a sproc like:

CREATE PROC sp_test AS

EXTERNAL NAME inLineLib.[inlineCLRsql.test].PrintMessage

and it returns the Queue ID

Is there anything unadvisable about the steps above?

 

Thanks for your help

 

M

 

 

View Replies !   View Related

---

Error While Creating Assembly
I am trying to create an assembly on a sql server 2005 machine but it gives me following error:


Msg 33009, Level 16, State 2, Line 2
The database owner SID recorded in the master database differs from the database owner SID recorded in database 'XYZ'. You should correct this situation by resetting the owner of database 'XYZ' using the ALTER AUTHORIZATION statement.



I tried using the alter authorization statement to change the owner.
It did not work.

I am able to create same assembly on another test database but can not create it on this database.

Is this because of orphan logins?

Thanks for the help.

Harshal.

View Replies !   View Related

---

Error Creating Assembly
 

I encountered something strange, deploying the following assemblies
 

CREATE ASSEMBLY [Sentry]

AUTHORIZATION [dbo]

FROM 'c:clrSentry.dll'

WITH PERMISSION_SET = EXTERNAL_ACCESS;

GO
 

CREATE ASSEMBLY [Sentry.XmlSerializers]

AUTHORIZATION [dbo]

FROM 'C:clrSentry.XmlSerializers.dll'

WITH PERMISSION_SET = SAFE;

GO

 
 
Sentry.XmlSerializers errored out with:
Msg 6218, Level 16, State 2, Line 2
CREATE ASSEMBLY for assembly 'Sentry.XmlSerializers' failed because assembly 'Sentry.XmlSerializers' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
[ : Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializerContract::CanSerialize][mdToken=0x600006e][offset 0x00000001][token  0x01000019]System.TypeLoadException: Could not load type 'Sentry.SentryDataService.SentryDataService' from assembly 'Sentry, Version=1.0.2764.18017, Culture=neutral, PublicKeyToken=null'. Type load failed.
 
 
The interesting thing is that when I deploy this locally on my machine, there are no problems whatsoever. Using sp_configure the servers appear to be set up the same way. The database also has trustworthy set on for both.
 
Anything, I could be missing? Thanks
 

View Replies !   View Related

---

Error When Loading Assembly
Hi,
 
i have sql server 2005.i have one assembly which created using  VS 2005 (c#).
i want to load this assembly on server from management studio.
 
sql statements are
 

CREATE ASSEMBLY [AMEX]

FROM 'C:Documents and SettingschrautMy DocumentsVisual Studio 2005ProjectsSqlServerProject1SqlServerProject1inDebugSqlServerProject1.dll'

WITH PERMISSION_SET = EXTERNAL_ACCESS

GO
 
after that i am getting error.
 

CREATE ASSEMBLY for assembly 'SqlServerProject1' failed because assembly 'SqlServerProject1' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS. The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. If you have restored or attached this database, make sure the database owner is mapped to the correct login on this server. If not, use sp_changedbowner to fix the problem.
 
can anyone help me out regarding to this.
 
thanks,
 
Chetan S. Raut.

View Replies !   View Related

---

CREATE ASSEMBLY ERROR: Msg 701
Hello there,
 
i have the following problem.
 
I need to get some .dll's into MS SQL-Server 2005, that i need to get a own made .dll installed.
 
When i try to:



Code Block
CREATE ASSEMBLY SystemWeb
FROM 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727System.Web.dll'
WITH PERMISSION_SET = UNSAFE;
 
 


i get the following message:
 



Code Block
Warning: The Microsoft .Net frameworks assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=x86.' you are registering is not fully tested in SQL Server hosted environment.
Warning: The Microsoft .Net frameworks assembly 'system.enterpriseservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=x86.' you are registering is not fully tested in SQL Server hosted environment.
Warning: The Microsoft .Net frameworks assembly 'system.runtime.remoting, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
Warning: The Microsoft .Net frameworks assembly 'system.design, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
Msg 701, Level 17, State 13, Line 1
There is insufficient system memory to run this query.
 
 


 
When i try to create one of the another assemblies ( system.enterpriseservices, system.runtime.remoting, system.design ) i get the same message.
 
I looked for this Error and found only this BUG-report:
BUG#: 58267 (SQLBUG_70)
Article ID: 274030
http://support.microsoft.com/kb/274030/en-us
 
But this does not solve my problem.
 
As far as i know we use MS SQL-Server 2005 without any Service-Packs.
 
Question:

is there any Table/View to find out the Versionnumber/Service-Pack
 
In the moment i am waiting for our admin to install SP2 for SQL-Server,
hoping that this will fix the problem.
 
Greetings
 

 

View Replies !   View Related

---

CREATE ASSEMBLY ERROR
I am using this code to create dll : Execute.cs
 
using System;
using Microsoft.SqlServer.Dts.Runtime;
public class Execute
{
        public static void Package(string dtsxPath)
        {
            try
            {
                Package pkg;
                Application app;
                DTSExecResult pkgResults;
                app = new Application();
                pkg = app.LoadPackage(dtsxPath, null);
                pkgResults = pkg.Execute();
            }
            catch (System.Exception ex)
            {
                throw ex;
            }
        }
}

 
Then this
c:Program FilesMicrosoft Visual Studio 8VC>csc /target:library C:SSISSSISE
xecute.cs /reference:C:SSISSSISMicrosoft.SqlServer.ManagedDTS.dll

 
It creates Execute.dll
 
but when I run this is sql server

CREATE ASSEMBLY ssid from 'c:Program FilesMicrosoft Visual Studio 8VCExecute.dll'

WITH PERMISSION_SET = UNSAFE

 
I am getting Error

Warning: The SQL Server client assembly 'microsoft.sqlserver.manageddts, version=9.0.242.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.

Warning: The SQL Server client assembly 'microsoft.sqlserver.dtsruntimewrap, version=9.0.242.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.

Msg 10301, Level 16, State 1, Line 1

Assembly 'Execute' references assembly 'system.windows.forms, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.

 
I don't see any place I am using System.window.forms
 
Any idea why? Thanks - Ashok
 
---------------------------------------------------------
I changed my location to to CSC 
C:WINNTMicrosoft.NETFrameworkv2.0.50727>
 
Now I get this error
 

Warning: The SQL Server client assembly 'microsoft.sqlserver.manageddts, version=9.0.242.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.

Warning: The SQL Server client assembly 'microsoft.sqlserver.dtsruntimewrap, version=9.0.242.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.

Warning: The Microsoft .Net frameworks assembly 'system.windows.forms, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.

Warning: The Microsoft .Net frameworks assembly 'system.drawing, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.

Warning: The Microsoft .Net frameworks assembly 'accessibility, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.

Warning: The Microsoft .Net frameworks assembly 'system.runtime.serialization.formatters.soap, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.

Msg 10301, Level 16, State 1, Line 1

Assembly 'Execute1' references assembly 'microsoft.sqlserver.msxml6_interop, version=6.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.

---------------------------------------------
 I managed to found this DLL Microsoft.SQLServer.msxml6_interop.dll so I copied to same location
Now It's looking for
 

microsoft.sqlserver.sqltdiagm  - Which I am not able to find any place .......................

View Replies !   View Related

---

Error While Trying To Load Assembly
 

Hi,

 

I have created an assembly in my database with permission set unsafe and created a function that uses a method defined inside the assembly. In my test environment everything went smooth, both creation of the assembly as well as the actual execution of the stored procedure that uses the method.

 

Now, moving to  production, the creation part all went fine too. But whenever I try to execute the stored procedure that uses the method I get this annoying error:

 

"An error occurred in the Microsoft .NET framework while trying to load assembly id 65538. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE."

 

The server resources are fine, and the assembly has been succesfully created with permission set unsafe.

 

I have tried deleting the method/assembly and creting them again a couple of times without any success.

The permissions for the .dll are Unrestricted for all levels before being created in the database. I don't know if this matter at all, but since its permissions unrestricted it should not be the problem anyway. The .dll is signed before being created in the database.

 

I have read this article http://support.microsoft.com/default.aspx/kb/918040 and even though the attach/detach is not the scenario here, I've tried to the process of creating the assembly with different dbo's.

 

I have also tried the solution found at http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1724171&SiteID=17 and executed sn.exe -Vr <assembly>,<publictoken> followed by a restart of the SQL Server but the error is still there.

 

Some suggestions on how to go on from here will be very helpful.

View Replies !   View Related

---

Error: OdbcPermission In Assembly
Hello, I have an assembly used in a report (.rdl). The assembly enables to connect to Database via ODBC. Also, it had been signed (.snk) using the VS designer. In development platform, the following error was outputted when RUN the report (** PREVIEW is no error ** )

 

Error:

============================================================

 'RSReportHost.exe' (Managed): Loaded 'C:WINDOWSassemblyGAC_32mscorlib2.0.0.0__b77a5c561934e089mscorlib.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesRSReportHost.exe', No symbols loaded.
'RSReportHost.exe' (Managed): Loaded

'C:WINDOWSassemblyGAC_MSILSystem.Windows.Forms2.0.0.0__b77a5c561934e089System.Windows.Forms.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'RSReportHost.exe' (Managed): Loaded

'C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll', Skipped loading symbols. Module is optimized and the debugger option

'Just My Code' is enabled.

'RSReportHost.exe' (Managed): Loaded

'C:WINDOWSassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesReportingServicesLibrary.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.Diagnostics.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded

'C:WINDOWSassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'RSReportHost.exe' (Managed): Loaded

'C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll', Skipped loading symbols. Module is optimized and the debugger option

'Just My Code' is enabled.

'RSReportHost.exe' (Managed): Loaded 'C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.Interfaces.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesReportingServicesNativeClient.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded

'C:WINDOWSWinSxSx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700msvcm80.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.Designer.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.ReportPreview.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.ProcessingCore.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded

'C:WINDOWSassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'RSReportHost.exe' (Managed): Loaded 'C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.ProcessingObjectModel.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.XmlRendering.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.CsvRendering.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.ImageRendering.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.HtmlRendering.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesMicrosoft.ReportingServices.ExcelRendering.dll', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesConnDB.dll', Symbols loaded.
'RSReportHost.exe' (Managed): Loaded

'expression_host_58bcf01c1a8442c3bbe45e4c4847f210', No symbols loaded.

'RSReportHost.exe' (Managed): Loaded 'C:WINDOWSassemblyGAC_32System.Transactions2.0.0.0__b77a5c561934e089System.Transactions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
Connection Failure.
Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
A first chance exception of type 'System.Security.SecurityException' occurred in System.Data.dll
A first chance exception of type 'System.NullReferenceException' occurred in ConnDB.dll
A first chance exception of type 'System.Security.SecurityException' occurred in System.Data.dll
Error: Failed to retrieve the required data from the DataBase.
Object reference not set to an instance of an object.
Connection Failure.
Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
The thread 0x12c8 has exited with code 0 (0x0).
The program '[3388] RSReportHost.exe: Managed' has exited with code 0 (0x0).

============================================================

Any idea for me? thanks a lot!

 

View Replies !   View Related

---

Error In Custom Assembly
When I add a custom assembly
 
I am trying to pass certain fields in dataset I am getting the following error
 
 

invalid fields i.e. that is fields that I passed are invalid.
 
It also says multi path identifier for microsft.reportingservices.reportobjectmodel.fieldimpl cud not be found.
 
Thanks
 
Sai

View Replies !   View Related

---

Error When Trying To Create Assembly
Hi,

I ran the following in the management studio:

CREATE ASSEMBLY MyCLRAssembly from 'c: empMyCLRAssembly.dll'
WITH PERMISSION_SET = SAFE
Go

For some reason I get the following error:

Msg 6517, Level 16, State 1, Line 1
Failed to create AppDomain 'AdventureWorks.dbo[ddl].22'.

I tried to google this error, but couldn't find it...
I would appreciate it if someone can tell me what I'm doing wrong.

Ohad.

View Replies !   View Related

---

Error While Creating Assembly
I am trying to create an assembly on a sql server 2005 machine but it gives me following error:


Msg 33009, Level 16, State 2, Line 2
The database owner SID recorded in the master database differs from the database owner SID recorded in database 'XYZ'. You should correct this situation by resetting the owner of database 'XYZ' using the ALTER AUTHORIZATION statement.



I tried using the alter authorization statement to change the owner.
It did not work.

The same assembly is created on another test database but can not create it on this database.

Is this because of orphan logins?

Thanks for the help.

Harshal.

View Replies !   View Related

---

CREATE ASSEMBLY Gets Msg 6513 Error
I have an issue where we went to enable CLR in our production system this morning and ran into some trouble.  The actual enabling went fine but when we ran the assembly code we got the following:

.Net SqlClient Data Provider: Msg 6513, Level 16, State 27, Line 10
Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. Please restart SQL server in Address Windowing Extensions (AWE) mode to use CLR integration features.

We're running 32 bit SQL2005 SP2 and Windows Server 2003, and AWE is already enabled (using 29 GB out of the 32 GB total).  I looked at another thread that somewhat covered this (http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1178135&SiteID=17), unfortunately there wasn't a post about how things worked out.  That post suggested that the virtual address space was too fragmented for SQLCLR to load.  I have about a week before we hit our maintenance window and reboot the server and I'm hoping that if the first thing we do when the box comes back up is create the assembly, we'll solve our issue.

As far as the inevitable comment that we should go to x64: I realize that would probably solve my problem but it's not going to happen in the next 6 months, much less 6 days.

Any insight into this would be greatly appreciated.

View Replies !   View Related

---

Stored Procedure Assembly Error
Hello there,

I am having trouble with the following and appreciate any help.Thanks in advanced.

I have created an assembly to delete records in exchange (which works fine when testing it in debug mode). I then create the assembly in SQL server 2005(tried both unsafe and external access btw), and then i create a stored procedure calling the assembly.

Now my error occurs when i try to execute this stored procedure in SQL Server. I get the following...

Msg 6522, Level 16, State 1, Procedure sp_DeleteExchApp, Line 0A .NET Framework error occurred during execution of user defined routine or aggregate 'sp_DeleteExchApp': System.Security.SecurityException: System.Security.Permissions.SecurityPermissionSystem.Security.SecurityException: at App_Delete.eSay.AppointmentDelete.DeleteAppointment(Guid GUID).(1 row(s) affected)

Now when i have looked around the web, i have come accross people saying that it is to do with the assembly trying to access something it does not have permission for. But i cant figure out what that is or why it is throwing an error.

The code for the assembly is as follows:




 Public Shared Sub DeleteAppointment(ByVal GUID As System.Guid)            Dim CalendarURL As String            Dim ItemURL As String            Dim Rs As New ADODB.Recordset            Dim Rec As New ADODB.Record            Dim Conn As New ADODB.Connection            Dim iAppt As New Appointment            Dim Target As String            Dim strCRMGUID As String            Dim strGUID As String            Dim sSQL As String            Dim Check As String            strCRMGUID = GUID.ToString            'Using the Exchange OLE DB provider            CalendarURL = "file://./backofficestorage/esay-solutions.co.uk/public folders/Office Diary"            'Open a recordset for the items in the calendar folder            Rec.Open(CalendarURL)            Rs.ActiveConnection = Rec.ActiveConnection            sSQL = "SELECT ""DAV:href"", " & _                   " ""urn:schemas:calendar:location"", " & _                   " ""urn:schemas:calendar:dtstart"", " & _                   " ""urn:schemas:calendar:dtend"", " & _                   " ""urn:schemas:httpmail:textdescription"" " & _                   "from scope('shallow traversal of """ & CalendarURL & """')"            Rs.Open(sSQL, Rec.ActiveConnection, CursorTypeEnum.adOpenUnspecified, LockTypeEnum.adLockOptimistic, 1)            'Enumerate the recordset, checking each item's location            If Rs.RecordCount > 0 Then                Rs.MoveFirst()                Do Until Rs.EOF                    'get the location of each item                    Check = Rs.Fields(CdoHTTPMail.cdoTextDescription).Value                    strGUID = StripGUID(Check)                    'test for desired location                    If (strGUID = strCRMGUID) Then                        Rs.Delete()                    End If                    Rs.MoveNext()                Loop            End If        End Sub
        Private Shared Function StripGUID(ByVal i_strAppDescription As String) As       String
'Function to strip the GUID from the message field            Dim r As Integer            Dim SearchChar As String            Dim testPos As Integer            Dim GUID As String            SearchChar = "**¦"            testPos = InStr(i_strAppDescription, SearchChar)            testPos = testPos + 3            If testPos > 0 Then                GUID = Mid(i_strAppDescription, testPos)            End If            StripGUID = GUID        End Function    End ClassEnd Namespace




Thanks again for any help.

View Replies !   View Related

---

Error Adding Assembly To SQL 2005
I have a clr assembly that access the internet via Sockets and file access. This require me to set the Assembly permissions level to External.

There are lots of messages on the net regarding this issue. none have worked for me.

Currently I'm trying to install the assembly with "sign the assembly" checked, createing a strong name key file.

When I run the installation I get the following message from the server

"Create failed for SqlAssembly 'xxx'.(Microsoft.sqlServer.Smo)

an exception occured while executing a Transact-SQL statement or batch

(Microsoft.SqlServer.ConnectionInfo)

A severe error occured in the current command. The results, if any, should be discarded.

This is the messag I get.

The following link does not display any usefull information.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for SqlAssembly 'KBTTriggers'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+SqlAssembly&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

A severe error occurred on the current command.  The results, if any, should be discarded.
A severe error occurred on the current command.  The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

View Replies !   View Related

---