The Type Or Namespace Name 'SqlServer' Does Not Exist In The Namespace 'System.Data'

Jun 9, 2006


I have created a .net class library and i include the namespace :

using System.Data.SqlServer

but when i build my .net class library i get the folowing error:

The type or namespace name 'SqlServer' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) 


your help is highly appreciated

Best regards

View 6 Replies


Error: 'Dts' Does Not Exist In The Namespace 'Microsoft.Sqlserver'

Jul 1, 2005

I tried to create a package from a C# program, and I copied this from SQL server online book:

View 13 Replies View Related

SQL XML :: Handling Namespace In XQuery - Declaring A Namespace - What Is AWMI

Aug 4, 2015

After I learned the XML Schemas Collection, Using XML Data and 5 XML data type methods : query(), valuse(), exist(), modify(), and node(), I just started to do XQuery by using the Microsoft XQuery Language Reference - SQL Server 2012 Books Online and Handling Namespaces in XQuery of [URL]. I copied the following code:

-- Handlimng Namespace in Xquery (Page 6 of XQuery Languge Reference & Examples of msdn library)

-- Example A. Declaring a namespace

-- saved as MicrosoftXQueryPage6 in C:DocumentsXquery-SQLServer2012

-- 4 Aug 2015 10:55 AM

SELECT Instructions.query('
declare namespace AWMI="";
') as Result
FROM Production.ProductModel
WHERE ProductModelID=7

I executed the code in my Microsoft SQL Server 2012 Management Studio (SSMS2012). It worked nicely.

<AWMI:step xmlns:AWMI="">
Insert <AWMI:material>aluminum sheet MS-2341</AWMI:material> into the <AWMI:tool>T-85A framing tool</AWMI:tool>.
<AWMI:step xmlns:AWMI="">


But, I don't know what AWMI means and what the results of SELECT Instructions.query(' declare namespace...  are. 

View 3 Replies View Related

Articles About Data Access Using System.Data.SqlClient Namespace?

Mar 20, 2004

Aaarrgghhhhhhh, still searchin' for a nice step-by-step article to learn data access (all insert delete update commands) with the SQL Server .NET Data Provider found in [System.Data.SqlClient] namespace....

Can anyone plz help me to find it?

View 1 Replies View Related

How To Get System.Query Namespace

Sep 26, 2007

 Hi all,   I tried to do the Linq sample program,  Already i have added System.Query namespace.   But I am getting some errorlike No reference to System.Query. In my system , i have installed VS 2005 and .Net Framework 3.0. Apart from the this, please tell me , whether any software are required Regards and ThanksThirumurugan      

View 5 Replies View Related

Why Do I Need Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace

Jul 18, 2006


It states pretty clearly in the documentation for the Microsoft.SqlServer.Dts.Runtime.Wrapper namespace that "This assembly is a Primary Interop Assembly (PIA) for the namespace Microsoft.SqlServer.Dts.Runtime, which is the assembly Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll). The classes in this namespace should not be instantiated. Instead, use the classes found in the Microsoft.SqlServer.Dts.Runtime. "


And yet as I have found out earlier today and talked about here, sometimes it is absolutely necassary to use Microsoft.SqlServer.Dts.Runtime.Wrapper. Why is this? Why is there no class in Microsoft.SqlServer.Dts.Runtime that allows me to access the specific connection managers rather than using the generic ConnectionManager class?






View 3 Replies View Related

Where Can I Find Microsoft.SqlServer.Management.Smo Namespace?

Mar 2, 2008


Where can I find the reference to Microsoft.SqlServer.Management.Smo in SQL Server 2005?

I currently have Microsoft SQL Server 2005, Microsoft SQL Native Client and Server VSS writer installed. (and ran the Service Pack 2 installer, but it doesn't want to update 'Database Services')

Thanks in advance,

Ruben Pieters

View 6 Replies View Related

The Type Or Namespace Name 'SqlDataReader' Could Not Be Found

Mar 6, 2006

    public static DataReader GetPhotoById(int pPhotoId)    {        return MyFile.Providers.SqlFileProvider.Instance.PhotoGetById(pPhotoId);    }That code is throwing me up the following error : Error    1    The type or namespace name 'DataReader' could not be found (are you missing a using directive or an assembly reference?)    D:wwwWebSite1App_CodePhotoManager.cs    18    19    D:wwwWebSite1I'm pretty stuck to whats wrong? Any suggestions?Sorry, i'm really new to all this framework (and even this website);Dougal

View 2 Replies View Related

CLR Function Error 6522 Using System.IO Namespace

Mar 4, 2008

I created a clr proc that gets the most recent file within a directory based on the creation time property, see code below. I have attempted to replicate this within a clr scalar valued function in order to assign the resulting value to a variable within SQL server. I am getting the error message:

Msg 6522, Level 16, State 2, Line 1

A .NET Framework error occurred during execution of user-defined routine or aggregate "clr_fn_recentfile":

System.InvalidOperationException: Data access is not allowed in this context. Either the context is a function or method not marked with DataAccessKind.Read or SystemDataAccessKind.Read, is a callback to obtain data from FillRow method of a Table Valued Function, or is a UDT validation method.


at System.Data.SqlServer.Internal.ClrLevelContext.CheckSqlAccessReturnCode(SqlAccessApiReturnCode eRc)

at System.Data.SqlServer.Internal.ClrLevelContext.GetCurrentContext(SmiEventSink sink, Boolean throwIfNotASqlClrThread, Boolean fAllowImpersonation)

at Microsoft.SqlServer.Server.InProcLink.GetCurrentContext(SmiEventSink eventSink)

at Microsoft.SqlServer.Server.SmiContextFactory.GetCurrentContext()

at Microsoft.SqlServer.Server.SqlContext.get_CurrentContext()

at Microsoft.SqlServer.Server.SqlContext.get_Pipe()

at clr_fn_recentfile.clr_fn_recentfile.clr_fn_recentfile(SqlString Filepath)

After trying to troubleshoot this I am aware that this error is rather generic and have not been able to find any specific documenation regardint the use of file system objects with clr functions. I am at a loss. Any help would be appreciated!

Code Snippet
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports System.IO

Partial Public Class clr_recentfile

Public Shared Sub clr_recentfile(ByVal Filepath As SqlString)
Dim strFile As String
Dim sp As SqlPipe = SqlContext.Pipe()
Dim maxDate As Date
Dim fil As String
Dim qry As New SqlCommand()
If Directory.Exists(Filepath.ToString) Then

For Each strFile In Directory.GetFiles(Filepath.ToString)
fil = Path.GetFileName(strFile).ToString
Dim fi As New FileInfo(strFile)
If maxDate = Nothing Then
maxDate = fi.CreationTime
fil = fi.FullName.ToString
If maxDate < fi.CreationTime Then
maxDate = fi.CreationTime
End If
End If

sp.Send("Directory does not exist")
End If
If fil <> Nothing Then
qry.CommandText = " SELECT '" & fil & "'"
'Execute the query and pass the result set back to SQL
End If
Catch ex As Exception
End Try
End Sub
End Class


Code Snippet
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports System.IO

Partial Public Class clr_fn_recentfile
<Microsoft.SqlServer.Server.SqlFunction()> _
Public Shared Function clr_fn_recentfile(ByVal Filepath As SqlString) As SqlString
Dim strFile As String
Dim sp As SqlPipe = SqlContext.Pipe()
Dim maxDate As Date
Dim fil As String
Dim qry As New SqlCommand()
If Directory.Exists(Filepath.ToString) Then

For Each strFile In Directory.GetFiles(Filepath.ToString)
fil = Path.GetFileName(strFile).ToString
Dim fi As New FileInfo(strFile)
If maxDate = Nothing Then
maxDate = fi.CreationTime
fil = fi.FullName.ToString
If maxDate < fi.CreationTime Then
maxDate = fi.CreationTime
End If
End If

sp.Send("Directory does not exist")
Exit Function
End If
If fil <> Nothing Then
Return fil
End If
Catch ex As Exception
End Try

End Function
End Class

View 3 Replies View Related

Error: The Type Or Namespace Name 'DataReader' Could Not Be Found

Aug 1, 2006

In my DAL:using System;using System.Collections;using System.Data;using System.Data.SqlClient;using System.Configuration;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;public DataReader getPersonList2() {        using (SqlConnection conn = getConnection())        {            SqlCommand cmd = new SqlCommand("PERSON_SP_getPersonList", conn);            cmd.CommandType = CommandType.StoredProcedure;            conn.Open();            return cmd.ExecuteReader();        }    }In my BLL:using System;using System.Collections;using System.Data;using System.Data.SqlClient;using System.Configuration;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;DAL d = new DAL();public DataReader getPersonList2(){        return d.getPersonList2();    }I get the following error in my BLL: Compiler Error Message: CS0246: The type or namespace name 'DataReader' could not be found (are you missing a using directive or an assembly reference?)
Source Error:

Line 34: }Line 35: Line 36: public DataReader getPersonList2(){Line 37: return d.getPersonList2();Line 38: }

Source File: c:InetpubwwwrootstudyApp_CodeBLL.cs
   Line: 36
Just wondering if someone could tell me why this is happening? I have the same namespaces that I have in the DAL in my BLL.Puzzled.

View 2 Replies View Related

Problem Sending 32KB Message Using ServiceBrokerInterface Example From Microsoft.Samples.SqlServer Namespace.

Jan 25, 2008

I have been using the ServiceBrokerInterface example for a project of mine and so far it has been very successfull. However , I recently attempted to use it to send a large-ish message (32K xml file from MS Word) to SQL. The message is recieved but the Body member of the message is null when I try to retrieve the data from within my stored procedure CLR method.

The only differences I can see between the message that does not work and those that do are that the one that doesn't is large and it is XML data that I read from a .xml file produced by MS Word as opposed to internally generated strings in the other working messages.

Does anybody have any suggestions as to why the body of the message is not being sent in this case?
Is there something about the example code that precludes sending this type of message?

This is the code that sends the message (extracted from Conversation.cs in ServiceBrokerExample)

string query = "SEND ON CONVERSATION @ch MESSAGE TYPE @mt ";
param = cmd.Parameters.Add("@ch", SqlDbType.UniqueIdentifier);
param.Value = m_handle;
param = cmd.Parameters.Add("@mt", SqlDbType.NVarChar, 255);
param.Value = message.Type;

if (message.Body != null)
query += " (@msg)";
param = cmd.Parameters.Add("@msg", SqlDbType.VarBinary);
param.Value = new SqlBytes(message.Body);
param.Size = -1;
cmd.CommandText = query;

This is the code that reads the message from the SQL queue (extracted from Message.cs in ServiceBrokerExample)

m_reader = reader;
m_convGroupId = reader.GetGuid(0);
m_conv = new Conversation(service, reader.GetGuid(1));
m_sequenceNumber = reader.GetInt64(2);
m_serviceName = reader.GetString(3);
m_contractName = reader.GetString(4);
m_type = reader.GetString(5);
m_validation = reader.GetString(6);
if (!reader.IsDBNull(7))
SqlBytes sb = reader.GetSqlBytes(7);
Body = sb.Stream;
Body = null;

This is the MESSAGE TYPE used by this message.


Here is the code where msgReceived.Body == null in the SQL CLR method invoked by this message.

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Design", "CA1062:ValidateArgumentsOfPublicMethods"), System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Performance", "CA1822:MarkMembersAsStatic"), BrokerMethod("AssessmentContract", "CreateReport_Command")]
public void CreateReport_Command(
Message msgReceived,
SqlConnection connection,
SqlTransaction transaction)
StreamReader reader = null;

reader = new StreamReader(msgReceived.Body);

And finally here is the code snippet that creates the stream that gets loaded into the message to be sent.

if (Report != null && ReportName != null)
MemoryStream ReportBody = new MemoryStream();

if (ReportID == null)
ReportID = Guid.NewGuid().ToString();

ReportBody.Write(Encoding.ASCII.GetBytes(ReportID), 0, ReportID.Length);
ReportBody.Write(Encoding.ASCII.GetBytes("|".ToCharArray()), 0, 1);
ReportBody.Write(Encoding.ASCII.GetBytes(ReportName), 0, ReportName.Length);
ReportBody.Write(Encoding.ASCII.GetBytes("|".ToCharArray()), 0, 1);
ReportBody.Write(Encoding.ASCII.GetBytes(Report), 0, Report.Length);

Microsoft.Samples.SqlServer.Message request = new Microsoft.Samples.SqlServer.Message("CreateAssessmentReport_Command", ReportBody);

// Send the message to the service
dialog.Send(request, conn, tran);

View 1 Replies View Related

CS0246: The Type Or Namespace Name 'SqlConnection' Could Not Be Found (are You Missing A Using Directive Or An Assembly Reference?)

Jan 20, 2008

Hello,I just lost all my data doing a system restore and now trying to rebuild my web project.However, Am getting the error below, trying to use a class to run my Stored procedure.What is wrong herethanksEhiCompiler Error Message: CS0246: The type or namespace name 'SqlConnection' could not be found (are you missing a using directive or an assembly reference?)Source Error:Line 22: //SqlConnection con = new SqlConnection("cellulant_ConnectionString");
Line 23: //SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cellulant_ConnectionString"].ToString());
Line 24: SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["cellulant_ConnectionString"].ToString());
Line 25:
Line 26: Source File: c:inetpubwwwrootcellulant1App_Codesignup_data-entry.cs    Line: 24   using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public class signup_data_entry
public signup_data_entry(DateTime dob1)

//SqlConnection con = new SqlConnection("cellulant_ConnectionString");
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cellulant_ConnectionString"].ToString());
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["cellulant_ConnectionString"].ToString());

SqlCommand command = new SqlCommand("Cellulant_Users_registration", con);
command.CommandType = CommandType.StoredProcedure;


View 2 Replies View Related

Data Access :: How To Get Column Datatype Using Namespace

Jan 2, 2013

which is to parse a create table script using Microsoft.SqlServer.TransactSql.ScriptDom namespace..I get a list of statements : StatementList SQLStatement = parser.ParseStatementList(StreamReader, out errors);then I cast a relevant statement to the CreateTableStatement type which gives me access to the ColumnDefinition class.

foreach (TSqlStatement T in SQLStatement.Statements)
{ if (T is CreateTableStatement) { CreateTableStatement  TC= (CreateTableStatement)T}}
with foreach (ColumnDefinition CD in TC.Definition.ColumnDefinitions)

I am ready to loop through the columns so far so good. I can get to the column name using CD.ColumnIdetifier.Value, to the data type using CD.DataType.Name.BaseIdentifier.Value, but can't seem to get to the length definition. Meaning, I can get column1 , varchar; but I need column1, varchar(40). where do I get (40) from?I tried using ScriptTokenStream under C.DataType, but it seems to iterate through all tokens not just ones relevant to that fragment.

View 6 Replies View Related

Where's The Namespace?

Jul 25, 2007

I'm trying to write my first sql server compact edition program. When I try to add a SqlCeConnection object to my .cs file, I need to add the namespace "using" reference. the online docs say it's System.Data.SqlServerCe, but my IDE won't find it. I've tried adding the reference, but neither System.Data.SqlServerCe nor is on the .NET list. Where do I go from here?

View 1 Replies View Related

The SQL Namespace Has Already Been Initialized.

Jan 12, 2004

I am trying to build a SQL Server 2000 (sp3) admin app in VB.NET that gives the users targeted access to EM functions without having to search through EM. At any rate, I cannot seem to re-initialize the SQL namespace, even after setting it to nothing (I want to enable a user to do work with one server, pop into another, etc). Here is a sample of what I am doing, stripped to its essentials. This code fails with the error in the subject line. Thanks in advance.

Dim NS As New SQLNS.SQLNamespace, Str as String

Str = "Server=SQLTEST;Trusted_Connection=Yes;"
NS.Initialize("Application; ", SQLNS.SQLNSRootType.SQLNSRootType_Server, _
Str, Handle.ToInt32)
NS = Nothing
NS = New SQLNS.SQLNamespace
Str = "Server=SQLPROXY;Trusted_Connection=Yes;"
NS.Initialize("Application; ", SQLNS.SQLNSRootType.SQLNSRootType_Server, _
Str, Handle.ToInt32)
NS = Nothing

View 13 Replies View Related

WMI Connection To SQL Namespace

May 13, 2008

I'm trying to use WMI query to fetch events from alter_table class of SQL 2005, but the WMI script is reporting an error 0x80070005 while executing query "Select * from Alter_Table". The Connection to the namespace is successfull.

I've tried all Security settings via "CoSetProxyBlanket" but without success. Can anybody help me sort out this issue.

Thanks and regards
Mittal Vinay

View 1 Replies View Related

Invalid Namespace

Dec 21, 2006

I'm getting the following error message when I tried to configure Reporting Services in 2005 SQL:

"No report servers were found on the specified machine.

Invalid namespace" Any assistance to get over this hurdle will be appreciated!

View 3 Replies View Related

Can You Rename A Namespace?

Apr 13, 2007

I recently restored an entire database hosted on a remote server onto my local PC. These are tables I created for an ASP.NET project I'm working on. Unfortunately, the tables are restored with a different namespace (I think that's what it's called).

So, dbo.Authors restored as dbo19738468.Authors. The 19738468 is the customer number that was assigned to me by my Web host, where I backed up the data I restored. Is there anyway to rename the dbo19738468 to simply dbo?

View 4 Replies View Related

NameSpace Of ReportingService Class

Nov 29, 2005

I can't find the ReportingService's namespace... i see ReportingService inerhits from System.Web.Services.Protocols.SoapHttpClientProtoco but any code what i found its impossible to compile, i need the namespace...

View 3 Replies View Related

Change Table From Namespace

Jan 18, 2007

I have a table like this : dbo.Table, and I recently create a namespace, and that table belongs there. So I want the table to be created on the new namespace, Namespace.Table, which is not big deal because I can script the table as a Create, and changes the [dbo].[table] to [Namespace].[Table]. But I need to import all the rows already on the old table. How can I achieve that?

View 3 Replies View Related

How To Assign ConnectionString To A SqlDataSource Within The Namespace?

Apr 16, 2007

i am trying to assign ConnectionString to a SqlDataSource   within the namespace but i am getting this error
plz advise
Object reference not set to an instance of an object. 
namespace myNameSpace{   
    public partial class NRP : System.Web.UI.Page    {            SqlDataSource sds1;
        protected void Page_PreInit(object sender, EventArgs e)        {            sds1= new SqlDataSource();            sds1.ID = "sds1";            this.Controls.Add(sds1);
            sds1.ConnectionString = ConfigurationManager.ConnectionStrings["my_conn_str"].ToString();
        }    }}

View 1 Replies View Related

How To Remove Namespace From Existing XML Subtr

Jun 20, 2014

I'm facing an issue with removing namespace from existing xml subtree.

For Example: I have a table with 1 field - data type xmltype. One entry is holding this xml:

<Item xmlns="">

I would like to remove the namespace - i.e.:


I tried using the UPDATE() function with no luck.

View 5 Replies View Related

Namespace For DataTransformationServices.Tasks.DTSProcessingTask

Apr 10, 2008

When compiling my c#-program with the line:

using Microsoft.DataTransformationServices.Tasks.DTSProcessingTask;
I get the following message:

Namespacename "Microsoft.DataTransformationServices.Tasks.DTSProcessingTask" not found. (Original in german:
Fehler 6 Der Typ- oder Namespacename DataTransformationServices ist im Namespace Microsoft nicht vorhanden. (Fehlt ein Assemblyverweis?) )

I have now to include a reference on it, but I cant find the file, belonging to this namespace. Somebody knows, where this namespace is included, or where can I find it?



View 1 Replies View Related

Setup Failing Due To Security Issue With WMI Namespace

Nov 16, 2006

I'm installing SQL Server Express SP1 on a new Windows XP Pro SP2 laptop that is part of a corporate network. The last item in the Setup Progress dialog box says:

Workstation Components, Books Online and Development Tools....Setup failed. Refer to log file.

C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt looks fine except for the last few lines:

Machine : ROVER
Product : Microsoft SQL Server 2005 Tools
Product Version : 9.1.2047.00
Install : Failed
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_ROVER_Tools.log
Last Action : InstallFinalize
Error String : SQL Server Setup failed to modify security permissions on WMI namespace \.
ootMicrosoftSqlServerComputerManagement. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the WMI namespace exists on the destination drive.
Error Number : 29516

Is this a common error when installing on a PC that is part of a corporate network? I didn't dig too far into SQLSetup0004_ROVER_Tools.log; however, it contains a few references to "SOFTWARE RESTRICTION POLICY".

Other than this error, SQL Server Express seems to be working ok. Is this anything to be concerned about?

View 3 Replies View Related

Invalid Namespace Error While Login Report Manager

Mar 15, 2007

I am using Custom Security Extension DLL for implementing Forms Authentication in Reporting Service 2005. While Login I am getting an "Invalid Namespace" error. After debugging it, i found below lines in the AuthenticationUtilities.cs page of the Custom DLL which is giving error.

const string WmiNamespace = @"\localhost
const string WmiRSClass = @"MSReportServerReportManager_ConfigurationSetting";

scope = new ManagementScope(WmiNamespace);

// Connect to the Reporting Services namespace.
scope.Connect(); //This is the line where the error is coming. It is trying to conenct WMI provider

Can anyone help me in figuring out What is wrong with the WmiNamespace ???????


View 15 Replies View Related

Reporting Services :: Defining Element-path Using Namespace Prefix?

Sep 28, 2015

I have an XML file that some of the nodes are represented with a namespace prefix. I have found the "msdn" page where shows the possibility to filter using the Namespace Prefix, but I have not been successful at it.

View 4 Replies View Related

SqlDataSource.Select Error: Unable To Cast Object Of Type 'System.Data.DataView' To Type 'System.String'.

Oct 19, 2006

I am trying to put the data from a field in my database into a row in a table using the SQLDataSource.Select statement. I am using the following code: FileBase.SelectCommand = "SELECT Username FROM Files WHERE Filename = '" & myFileInfo.FullName & "'" myDataRow("Username") = CType(FileBase.Select(New DataSourceSelectArguments()), String)But when I run the code, I get the following error:Server Error in '/YorZap' Application. Unable to cast object of type 'System.Data.DataView' to type 'System.String'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidCastException: Unable to cast object of type 'System.Data.DataView' to type 'System.String'.Source Error: Line 54: FileBase.SelectCommand = "SELECT Username FROM Files WHERE Filename = '" & myFileInfo.FullName & "'"
Line 55: 'myDataRow("Username") = CType(FileBase.Select(New DataSourceSelectArguments).GetEnumerator.Current, String)
Line 56: myDataRow("Username") = CType(FileBase.Select(New DataSourceSelectArguments()), String)
Line 57:
Line 58: filesTable.Rows.Add(myDataRow)Source File: D:YorZapdir_list_sort.aspx    Line: 56 Stack Trace: [InvalidCastException: Unable to cast object of type 'System.Data.DataView' to type 'System.String'.]
ASP.dir_list_sort_aspx.BindFileDataToGrid(String strSortField) in D:YorZapdir_list_sort.aspx:56
ASP.dir_list_sort_aspx.Page_Load(Object sender, EventArgs e) in D:YorZapdir_list_sort.aspx:7
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3743
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 Please help me!

View 3 Replies View Related

Unable To Cast COM Object Of Type 'System.__ComObject' To Class Type 'System.Data.SqlClient.SqlConn

May 17, 2006

Dear all,

I am stuck with a SSIS package and I cant work out. Let me know what steps are the correct in order to solve this.
At first I have just a Flat File Source and then Script Component, nothing else.


[Script Component [516]] Error: System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to class type 'System.Data.SqlClient.SqlConnection'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface. at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)

Script Code (from Script Component):

' Microsoft SQL Server Integration Services user script component
' This is your new script component in Microsoft Visual Basic .NET
' ScriptMain is the entrypoint class for script components

Imports System
Imports System.Data.SqlClient
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class ScriptMain
Inherits UserComponent

Dim nDTS As IDTSConnectionManager90
Dim sqlConnecta As SqlConnection
Dim sqlComm As SqlCommand
Dim sqlParam As SqlParameter

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Dim valorColumna As String
Dim valorColumna10 As Double

valorColumna = Row.Column9.Substring(1, 1)

If valorColumna = "N" Then
valorColumna10 = -1 * CDbl(Row.Column10 / 100)
valorColumna10 = CDbl(Row.Column10 / 100)
End If

Me.Output0Buffer.PORCRETEN = CDbl(Row.Column11 / 100)
Me.Output0Buffer.IMPRETEN = CDbl(Row.Column12 / 100)
Me.Output0Buffer.EJERCICIO = CInt(Row.Column2)
Me.Output0Buffer.CODPROV = CInt(Row.Column7)
Me.Output0Buffer.MODALIDAD = CInt(Row.Column8)
Me.Output0Buffer.NIFPERC = CStr(Row.Column3)
Me.Output0Buffer.NIFREP = CStr(Row.Column4)
Me.Output0Buffer.NOMBRE = CStr(Row.Column6)
Me.Output0Buffer.EJERDEV = CDbl(Row.Column13)

With sqlComm
.Parameters("@Ejercicio").Value = CInt(Row.Column2)
.Parameters("@NIFPerc").Value = CStr(Row.Column3)
.Parameters("@NIFReP").Value = CStr(Row.Column4)
.Parameters("@Nombre").Value = CStr(Row.Column6)
.Parameters("@CodProv").Value = CInt(Row.Column7)
.Parameters("@Modalidad").Value = CInt(Row.Column8)
.Parameters("@ImpBase").Value = valorColumna10
.Parameters("@PorcReten").Value = CDbl(Row.Column11 / 100)
.Parameters("@ImpReten").Value = CDbl(Row.Column12 / 100)
.Parameters("@EjerDev").Value = CDbl(Row.Column13)

End With

End Sub
Public Overrides Sub AcquireConnections(ByVal Transaction As Object)

Dim nDTS As IDTSConnectionManager90 = Me.Connections.TablaMODELO80
sqlConnecta = CType(nDTS.AcquireConnection(Nothing), SqlConnection)

End Sub
Public Overrides Sub PreExecute()

sqlComm = New SqlCommand("INSERT INTO hac_modelo180(Ejercicio,NIFPerc,NIFReP,Nombre,CodProv,Modalidad,ImpBase,PorcReten,ImpReten,EjerDev) " & _
"VALUES(@Ejercicio,@NIFPerc,@NIFReP,@Nombre,@CodProv,@Modalidad,@ImpBase,@PorcReten,@ImpReten,@EjerDev)", sqlConnecta)
sqlParam = New SqlParameter("@Ejercicio", Data.SqlDbType.SmallInt)
sqlParam = New SqlParameter("@NIFPerc", Data.SqlDbType.Char)
sqlParam = New SqlParameter("@NIFReP", Data.SqlDbType.Char)
sqlParam = New SqlParameter("@Nombre", Data.SqlDbType.VarChar)
sqlParam = New SqlParameter("@CodProv", Data.SqlDbType.TinyInt)
sqlParam = New SqlParameter("@Modalidad", Data.SqlDbType.SmallInt)
sqlParam = New SqlParameter("@ImpBase", Data.SqlDbType.Decimal)
sqlParam = New SqlParameter("@PorcReten", Data.SqlDbType.Decimal)
sqlParam = New SqlParameter("@ImpReten", Data.SqlDbType.Decimal)
sqlParam = New SqlParameter("@EjerDev", Data.SqlDbType.Decimal)

End Sub

Public Sub New()

End Sub
Public Overrides Sub ReleaseConnections()
End Sub

Protected Overrides Sub Finalize()
End Sub
End Class

Thanks a lot for your help

View 13 Replies View Related

@PARAM1 : Unable To Cast Object Of Type 'System.Data.SqlTypes.SqlInt32 To Type System.IConvertable

Apr 23, 2007

I get the following message in the vs2005 querybuilder when i do a preview:

SQL Execution Error.

Executed SQL statement: SELECT Schoolindex, Variant, VVSchool, [index], indincl, VVRuimtes, School FROM School WHERE (Schoolindex = @PARAM1)

Error Source: SQL Server Compact Edition ADO.NET Data Provider

Error Message: @PARAM1 : Unable to cast object of type 'System.Data.SqlTypes.SqlInt32 to type System.IConvertable'.

The same querypreview works fine without the parameter:

SELECT Schoolindex, Variant, VVSchool, [index], indincl, VVRuimtes, School FROM School WHERE (Schoolindex = 186)

Can anybody tell me why this is?
And tell me a way to get the tableadapter working?

Anne-Jan Tuinstra

View 3 Replies View Related

System.Security.SecurityException: Request For The Permission Of Type 'System.Data.SqlClient.SqlClientPermission, System.Data

Aug 21, 2006

I have created a windows library control that accesses a local sql database

I tried the following strings for connecting

Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Trusted_Connection = true"

Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Integrated Security=SSPI"

I am not running the webpage in a virtual directory but in


and I have a simple index.html that tries to read from an sql db but throws

the error

System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,

etc etc

The action that failed was:
The type of the first permission that failed was:
The Zone of the assembly that failed was:

I looked into the .net config utility but it says unrestricted and I tried adding it to the trusted internet zones in ie options security

I think that a windows form connecting to a sql database running in a webpage should be simple

to configure what am I missing?

View 28 Replies View Related

Request For The Permission Of Type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=, Culture=neutral, Pu

Mar 12, 2008

I created a .net console application within which I connect to a sql server (not local) as follows,

string conn_str = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=QuantEquitySql;Data Source=server name";

SqlConnection conn = new SqlConnection(conn_str);

Everything works fine when I run it from my computer. When I try to run it from a network share I get the following error,

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I am using Visual Studio 2005 and .Net framwork v2.0.50727.

Does anybody know a fix to this problem?


View 3 Replies View Related

A First Chance Exception Of Type 'System.Data.SqlClient.SqlException' Occurred In

Jan 18, 2008

I've written this code multiple times now. But for the first time i get an error at the line underlined. My procedure runs perfectly when i execute it through Sql Query analyzer.
plzz help.. Its urgent and am unable to find the reason for this error "A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in"
Thanks !SqlConnection conn = new SqlConnection(DbConnectionString);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "dbo.rqryTradesPRR";
cmd.Parameters.Add("@COBDate",SqlDbType.DateTime).Value = "2002-10-31 00:00:00.000" ;
SqlDataReader reader = cmd.ExecuteReader();
// have written something here

 Thanks in advance !

View 2 Replies View Related

Unable To Cast Object Of Type 'System.Object' To Type 'System.Data.DataSet'.

Nov 27, 2007

hi i dont know how to do type casting.

this.Variables.ObjVariable this objVariables i have create in variable place below like this

Name:Variable datatype int32 values 0

Name: NumberofRowsdatatype int32 values 10000

Name: ObjVariable datatype Object

My code

public override void CreateNewOutputRows()



Add rows by calling the AddRow method on the member variable named "<Output Name>Buffer".

For example, call MyOutputBuffer.AddRow() if your output was named "MyOutput".


System.Data.OleDb.OleDbDataAdapter oLead = new System.Data.OleDb.OleDbDataAdapter();

//System.Data.Odbc.OdbcDataAdapter oLead = new System.Data.Odbc.OdbcDataAdapter();

//SqlDataAdapter oLead = new SqlDataAdapter();

System.Data.DataTable dt = new System.Data.DataTable();

DataSet ds = (DataSet)this.Variables.ObjVariable; // here i am getting error


ADODB.Record rs = new ADODB.Record();

oLead.Fill(ds, rs, "Variables");

foreach (DataRow row in dt.Rows)




Output0Buffer.Column = (int)row["Column"];

Output0Buffer.Column1 = row["Column1"].ToString();

Output0Buffer.Column2 = row["Column2"].ToString();





This is the error

Unable to cast object of type 'System.Object' to type 'System.Data.DataSet'.

at ScriptMain.CreateNewOutputRows()

at UserComponent.PrimeOutput(Int32 Outputs, Int32[] OutputIDs, PipelineBuffer[] Buffers)

at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)



View 5 Replies View Related

Copyrights 2005-15, All rights reserved