Reference Error

Jun 14, 2006

i have this code,


CREATE TABLE s
(sno VARCHAR(5) NOT NULL PRIMARY KEY,
name VARCHAR(16),
city VARCHAR(16)
)

CREATE TABLE p
(pno VARCHAR(5) NOT NULL PRIMARY KEY,
descr VARCHAR(16),
color VARCHAR(8)
)

CREATE TABLE sp
(sno VARCHAR(5) NOT NULL REFERENCES s,
pno VARCHAR(5) NOT NULL REFERENCES p,
qty INT CHECK (qty>=0),
PRIMARY KEY (sno, pno)
)


when i run this query i get an error saying:

Column 's.sno' is not the same length as referencing column 'sp.sno' in foreign key 'FK__sp__sno__5EBF139D'. Columns participating in a foreign key relationship must be defined with the same length.


can anyone assist me what to be done?

View 6 Replies


ADVERTISEMENT

SQL 2012 :: DTSX Giving Errors - Object Reference Not Set To Instance Reference

Sep 10, 2014

I am using vs 2010 to write my dtsx import scripts.I use a script component as a source to create a flat file destination file.Everything have been working fine,but then my development machine crashed and we have to install everything again.Now when i use the execute package utility to test my scripts i get the following error:

Error system.NullReferenceException: Object refrence not set to an instance reference.

In PreExecute section
TextReader = new system.io.streamreader(" file name")
In the CreateNewOutputRows:
dim nextLine as string
nextLine = textReader.ReadLine

[code]...

is there something which i did not install or what can be the error?

View 0 Replies View Related

Object Reference Not Set Error?

Nov 8, 2007

Hi,I have an update command to update a column by '1' on click. I am getting the error: Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.It doesnt give which code it reffers to but the stack trace is:[NullReferenceException: Object reference not set to an instance of an object.] Buyers_MyPurchases.Button1_Command(Object sender, CommandEventArgs e) +63 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +75 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4886 My code behind is: private bool ExecuteClickin(int quantity) { SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"; con.Open(); SqlCommand command = new SqlCommand(); command.Connection = con; TextBox TextBox1 = (TextBox)DataList1.FindControl("TextBox1") as TextBox; command.CommandText = "UPDATE Items SET numberclickedin = numberclickedin + 1 WHERE productID=@productID"; command.Parameters.AddWithValue("@productID", TextBox1.Text); command.ExecuteNonQuery(); con.Close(); command.Dispose(); return true; } protected void Button1_Command(object sender, CommandEventArgs e) { if (e.CommandName == "Clickin") { TextBox TextBox1 = DataList1.FindControl("TextBox1") as TextBox; bool retVal = ExecuteClickin(Int32.Parse(TextBox1.Text)); if (retVal) Response.Redirect("~/Buyers/inbox.aspx"); } }} Thanks if anyone can work this out. I am sure that no label is null.. Jon   

View 8 Replies View Related

Object Reference Error

May 3, 2008

  
Hi i create detailsview that connects to a database that have a foreign key(UserID) to asp.net membership table but when i loadthe page in browser it shows the error: 
Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set to an instance of an object.Source Error:



Line 9:
Line 10: ' Determine the currently logged on user's UserId value
Line 11: Dim currentUserId As Guid = CType(currentUser.ProviderUserKey, Guid)
Line 12:
Line 13: ' Assign the currently logged on user's UserId to the @UserId parameter
 
My sql connection is:<asp:SqlDataSource ID="EditProfileDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:SecurityTutorialsConnectionString %>"
SelectCommand="SELECT [BookID], [BookTitle], [BookType], [BookDescription], [DownloadUrl], [UserId] FROM [EditProfile] WHERE ([UserId] = @UserId)">
<SelectParameters>
<asp:Parameter Name="UserId" Type="Object" /></SelectParameters>
</asp:SqlDataSource>
please help me to solve this problem.
thank you
saquib 

View 2 Replies View Related

Error Message: Object Reference Not Set To An Instance.........

Aug 22, 2006

I have migrated an existing ASP.net 1.1 application into ASP.net 2.0. After correcting the reported errors and warnings the application builds without any errors. I have a login page for users (AuthorLogin.aspx) that receives input from the user and checks the database to determine if the user is valid. If the user is in the database they are directed to a navigation page. The SqlDataAdapter used to access the SQL 2000 database causes the above error when I try to pass parameters to it using the input by the user. The dataadapter was added on the using the component designer for the AuthorLogin.aspx page. The parameters are the user's email address and a password. The dataadapter fills a dataset. If the dataset's rows are >0 then the user is redirected. The dataadapter and dataset are declare on the.vb code behind page as "protected with events...." Here is the code I am using.
Public Sub AuthorLoginValidate()
'use the email and password text values as parameters
DA_AuthorLogin.SelectCommand.Parameters.Item("@AuthorEmail").Value = AuthorLoginEmail.Text
DA_AuthorLogin.SelectCommand.Parameters.Item("@AuthorPassword").Value = AuthorLoginPassword.Text
MDData.Open()
DA_AuthorLogin.Fill(DS_AuthorLogin, "T_Author")
MDData.Close()
'if the database has an existing record then add session objects and redirect
If DS_AuthorLogin.T_Author.Rows.Count > 0 Then
Session.Add("AuthorAlias", DS_AuthorLogin.T_Author.Rows(0).Item("AuthorAlias"))
Session.Add("PreferredName", DS_AuthorLogin.T_Author.Rows(0).Item("PreferredName"))
Session.Add("LastName", DS_AuthorLogin.T_Author.Rows(0).Item("LastName"))
Response.Redirect("AuthorPaths.aspx")
Else : AuthorLoginNotValid.Visible = True
Exit Sub
End If
End Sub
Steps I have taken.

Reordered the parameters. Whichever parameter occurs first in the code throws the error
Set the parameters to a string instead of the user's input. The error still occurs.
Previewed the data to make sure the dataadapter and dataset are working correctly. They are.
Double-clicked the dataadapter and dataset to determine if the .vb code page will open with a new sub for the dataadapter or datatable. It does.
Declared the dataadapter explicitly at the beginning of the code. "Dim DA_AuthorLogin as new system.data.sqlclient......... You get the idea. This causes a warning that the dataadapter has not been assigned a value. I don't want to assign a value. I want to retrieve data.
I have tried to use the datasource control but this seems designed specifically for the datagrid, datalist, etc and it must be assigned a value
I have tried to use a dataset designed to use a datatableadapter and a datatable. This throws the same error.
I found a MSDN KB article that said to register the adodb file in the configured assemblies. I ran this command line as stated. It did not help.
This code worked well in my .net 1.1 application. I know other data adapters work in the application. Help please. What will work? I am about to go back to my .net 1.1 application and forget Visual Studio.net 2005 simply because I cannot access the data.
Thanks, David

View 6 Replies View Related

System.Data.SqlServerCE.dll Reference Causes Error ...

Feb 15, 2007

Hello All ...

I
am attempting to create a program that will run on the PocketPC 2003
environment. I have upgraded Visual Studio to SP1, I have installed SQL
Server Compact Edition on my development machine and I have installed
SQL Server Compact Edition Tools For Visual Studio on the development
machine.

I have created a new project Visual Basic - Smart
Device - Pocket PC 2003. I have created a form for user input. I build
and deploy the form to the Symbol Pocket PC to test - no connection to
data and it works.

I then add a reference to
System.Data.SqlServerCE.dll and rebuild and redeploy the application to
the handheld. When I attempt to open the form I receive the following
error:

psmPocket.exe
NotSupportedException
System.Drawing.Bitmap

at
System.Resources.ResourceReader.LoadObjectV2() at
System.Resources.ResourceReader.LoadObject() at
System.Resources.RuntimeResourceSet.GetObject() at
System.Resources.ResourceManager.GetObject() at
System.Resources.ResourceManager.GetObject() at
pmsPocket.frmSetSOPType.InitializeComponent() at
psmPocket.frmSetSOPType..ctor() at
System.Reflection.RuntimeContructorInfo.InternalInvoke() at
System.Reflection.RuntimeContructorInfo.InternalInvoke() at
System.Reflection.ContrcutorInfo.Invoke() at
System.Activator.CreateInstance() at MyForms.Create__Instance__() at
MyForms.get_frmSetSOPType() at psmPocket.SetSOPType.Main()

Now
the confusing part is that I haven't changed any of the forms or the
code behind the forms, I have simply added the reference to the project.

Any idea why adding the reference to System.Data.SqlServerCE.dll would cause the system to start generating these errors?

I've
checked, the install process has loaded the .NET 2 framework to the
handheld. And as indicated at the beginning of this message, the
application showed the form prior to my adding the reference.

Thoughts?

Thanks ...

View 3 Replies View Related

Cyclical Reference Error With Foreign Keys

Oct 26, 2007

The following SQL statements give me an error on the last line:

CREATE TABLE Employees (id int PRIMARY KEY NOT NULL, name nvarchar(50));
CREATE TABLE RandomTable (uniq int PRIMARY KEY NOT NULL, empid1 int NOT NULL, empid2 int NOT NULL);
ALTER TABLE RandomTable ADD CONSTRAINT RandomTable_FKey_1 FOREIGN KEY (empid1) REFERENCES Employees (id) ON DELETE CASCADE;
ALTER TABLE RandomTable ADD CONSTRAINT RandomTable_FKey_2 FOREIGN KEY (empid2) REFERENCES Employees (id) ON DELETE CASCADE;

The error is:

"The referential relationship will result in a cyclical reference that is not allowed."

Um...how is this cyclical? Is it because I have multiple cascade paths? If so, how do I go about doing the same thing?

Thanks,
Jeff

View 5 Replies View Related

System.Data.SQLServerCE.dll Reference Generates Error

Feb 14, 2007

Hello All ...I
am attempting to create a program that will run on the PocketPC 2003
environment. I have upgraded Visual Studio to SP1, I have installed SQL
Server Compact Edition on my development machine and I have installed
SQL Server Compact Edition Tools For Visual Studio on the development
machine.I have created a new project Visual Basic - Smart
Device - Pocket PC 2003. I have created a form for user input. I build
and deploy the form to the Symbol Pocket PC to test - no connection to
data and it works.I then add a reference to
System.Data.SqlServerCE.dll and rebuild and redeploy the application to
the handheld. When I attempt to open the form I receive the following
error:psmPocket.exeNotSupportedExceptionSystem.Drawing.Bitmapat
System.Resources.ResourceReader.LoadObjectV2() at
System.Resources.ResourceReader.LoadObject() at
System.Resources.RuntimeResourceSet.GetObject() at
System.Resources.ResourceManager.GetObject() at
System.Resources.ResourceManager.GetObject() at
pmsPocket.frmSetSOPType.InitializeComponent() at
psmPocket.frmSetSOPType..ctor() at
System.Reflection.RuntimeContructorInfo.InternalInvoke() at
System.Reflection.RuntimeContructorInfo.InternalInvoke() at
System.Reflection.ContrcutorInfo.Invoke() at
System.Activator.CreateInstance() at MyForms.Create__Instance__() at
MyForms.get_frmSetSOPType() at psmPocket.SetSOPType.Main()Now
the confusing part is that I haven't changed any of the forms or the
code behind the forms, I have simply added the reference to the project.Any idea why adding the reference to System.Data.SqlServerCE.dll would cause the system to start generating these errors?I've
checked, the install process has loaded the .NET 2 framework to the
handheld. And as indicated at the beginning of this message, the
application showed the form prior to my adding the reference.Thoughts?Thanks ...

View 1 Replies View Related

Connecting To Database - Object Reference Not Set Error Message

Feb 11, 2005

I've got code that on my own machine (visual studio .net 2003 and iis and sql server all exist on this box) works great. I display my test page, which loads a dropdownlist on page_load. This works great on my own machine.

When I move the code to our dev environment. Web server and database servers on separate boxes. I get the error "Object reference not set to an instance of an object" when i try to open the connection to the database. I thought it had to do with permissions and I check all through sql server and everything looks great. I then thought it was the connection string. I still haven't ruled this out, but I wrote a quick vbscript app to attach to the database and try to pull a record. The vbscript worked fine. So, the code works fine on my computer, but not on the web server. The connection does work with vbscript, but through my asp.net web app I get the "object reference" error.

All code below...

ASP.NET webpage:
private void Page_Load(object sender, System.EventArgs e)
{

if( !IsPostBack )
{
// Create a command object for the query
string mySelectQuery = "select id from vw_abcd order by ID";

SqlCommand myCommand = new SqlCommand(mySelectQuery,sqlConnection1);
sqlConnection1.Open();

DropDownList1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DropDownList1.DataBind();
sqlConnection1.Close();

RangeValidator1.MinimumValue = "1";
RangeValidator1.MaximumValue = DropDownList1.Items.Count.ToString();
}
}

Connection string on my machine:
workstation id=wXXXXXX01;packet size=4096;user id=testuser;password=testpass;integrated security=SSPI;data source=wXXXXXX01;persist security info=False;initial catalog=TestDB"/>

Connection string on web server:
network library=DBMSSOCN;data source=xxx.xx.xxx.xxxinstance1;user id=testuser;password=testpass;initial catalog=TestDB


vbscript:
Dim connConnection, rstresultset
strConnectionString = "driver={Sql Server};server=xxx.xx.xxx.xxxinstance1;user id=testuser;password=testpass;database=TestDB"

Set connConnection = CreateObject("ADODB.Connection")

connConnection.Open strConnectionString
Set rstresultset = createobject("ADODB.Recordset")

rstresultset.ActiveConnection = connConnection

rstresultset.Open "select id, comment from testtable", connConnection

msgbox rstresultset(0)
msgbox rstresultset.Fields(0).Value



Error message and stack trace:
Object reference not set to an instance of an object.

at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Web2.Drilldown.Page_Load(object sender, System.EventArgs e)




Any ideas what's going on?????

View 1 Replies View Related

SQL 2012 :: Suppress SSDT Database Reference Error

Aug 21, 2015

In database projects, VS2015, I want to create some views for me database that will reference another database table using 3 part naming reference.

Works fine in SSMS but when I try and build me project I is throwing up a reference error.

I can't import the other database into this project, so is there a way to suppress the error? I don't really want to exclude these view from the project.

View 5 Replies View Related

Microsoft.SQLServer.ManagedDTS.dll Reference Error In VB.Net 2002

Dec 19, 2006

I am using VB.NET 2002 and we have set up a test environment running SQL Server 2005.

I am trying to add a reference to Microsoft.SQLServer.ManagedDTS.dll which is required to run a DTS/SSIS package from VB.NET.

However the dll does not show in my add reference listing so when I select BROWSE and select the actual DLL I get a rather long error message telling me that only 'dll' and COM components can be referenced.

The exact message is:

A reference to 'C:Programs FilesMicrosoft SQL Server90SDKAssembliesMicrosoft.SQLServer.ManagedDTS.dll' could not be added. This is not a valid assembly or COM component. Only assemblies with extension 'dll' and COM components can be referenced. Please make sure that the file is accessible, and that it is a valid assembly or COM component.



Any suggestions?

thanks

View 3 Replies View Related

CREATE ASSEMBLY ERROR -- An Implicit Reference Of Some Kind ???

Jun 28, 2006

When I run this ...

CREATE ASSEMBLY asmRANDRTCalendaringGateway FROM 'E:sqlRANDRTCalendaringGateway.dll' WITH PERMISSION_SET = UNSAFE

I get this error ...

Msg 10301, Level 16, State 1, Line 1
Assembly 'RANDRTCalendaringGateway' references assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', 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.

Even though I do not explicity refer to system.web in the DLL's code ...

using Microsoft.Win32;
using System;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Configuration;
using System.Text;
using log4net;
using ADODB;
using MAPI;
using CDO;
using System.Runtime.InteropServices;

Is the problem just staring me in the face ?

cheers

View 14 Replies View Related

Getting An Error The DELETE Statement Conflicted With The REFERENCE Constraint FK_Detail_Header

May 14, 2008

Hello All, i have 2 files in excel which i am uploading them to a folder which is located in the root directory. then i am importing these two files into a sqldatabase. i needed some help in importing them and i got it from my previous post at http://forums.asp.net/t/1261155.aspx but now i have a problem. the import works perfectly first time but when i do it the second time i am getting an error on of the file (header). to explain clearly, what i am doing is , every time i upload a new file , i am deleting the data from the tables, so the new data can be inserted (  basically trying to achieve overwirting the existing data). now this technique works fine with the Detail table but not with the Header table. i think the reason is the header table has a primary key on OrderID and a relationship does exists between the Header and Detail. now how would i overcome this error. can some one please guide me. I really appreciate it.here is my code:  // connection for header file
protected OleDbCommand headExcelConnection() { // Connect to the Excel Spreadsheet
string headConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/imports/headerorder.xls") + ";" + "Extended Properties=Excel 8.0;"; // create your excel connection object using the connection string
OleDbConnection headXConn = new OleDbConnection(headConnStr); headXConn.Open(); // use a SQL Select command to retrieve the data from the Excel Spreadsheet // the "table name" is the name of the worksheet within the spreadsheet // in this case, the worksheet name is "Sheet1" and is expressed as: [Sheet1$]

OleDbCommand headCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", headXConn); return headCommand; } // importing header information


protected void BtnImpHeader_Click(object sender, EventArgs e) { PanelUpload.Visible = false; PanelView.Visible = false; PanelImport.Visible = true; LabelImport.Text = ""; // reset to blank // Create a new Adapter
OleDbDataAdapter objDataAdapter = new OleDbDataAdapter(); // retrieve the Select command for the Spreadsheet
objDataAdapter.SelectCommand = headExcelConnection();

// Create a DataSet
DataSet objDataSet = new DataSet(); // Populate the DataSet with the spreadsheet worksheet data
objDataAdapter.Fill(objDataSet);

// deleting the exisitng table before copy
SqlConnection mycon = new SqlConnection(ConfigurationManager.ConnectionStrings["ImportexcelConnectionString"].ConnectionString); SqlCommand SqlCmd = null; mycon.Open(); SqlCmd = mycon.CreateCommand(); SqlCmd.CommandText = "DELETE FROM Header"; ---- showing error over on second time SqlCmd.ExecuteNonQuery(); mycon.Close(); // entering the newer header information

SqlConnection mysqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ImportexcelConnectionString"].ConnectionString); mysqlcon.Open(); foreach (DataRow dr in objDataSet.Tables[0].Rows) { String sqlinsert = "insert into Header values(@param1,@param2,@param3,@param4,@param5,@param6,@param7,@param8,@param9,@param10,@param11,@param12,@param13,@param14,@param15,@param16,@param17,@param18,@param19,@param20,@param21,@param22,@param23,@param24,@param25,@param26,@param27,@param28,@param29,@param30,@param31,@param32)"; SqlCommand cmd = new SqlCommand(sqlinsert, mysqlcon); cmd.Parameters.AddWithValue("@param1", dr[0].ToString()); cmd.Parameters.AddWithValue("@param2", dr[1].ToString()); cmd.Parameters.AddWithValue("@param3", dr[2].ToString()); cmd.Parameters.AddWithValue("@param4", dr[3].ToString()); cmd.Parameters.AddWithValue("@param5", dr[4].ToString()); cmd.Parameters.AddWithValue("@param6", dr[5].ToString()); cmd.Parameters.AddWithValue("@param7", dr[6].ToString()); cmd.Parameters.AddWithValue("@param8", dr[7].ToString()); cmd.Parameters.AddWithValue("@param9", dr[8].ToString()); cmd.Parameters.AddWithValue("@param10", dr[9].ToString()); cmd.Parameters.AddWithValue("@param11", dr[10].ToString()); cmd.Parameters.AddWithValue("@param12", dr[11].ToString()); cmd.Parameters.AddWithValue("@param13", dr[12].ToString()); cmd.Parameters.AddWithValue("@param14", dr[13].ToString()); cmd.Parameters.AddWithValue("@param15", dr[14].ToString()); cmd.Parameters.AddWithValue("@param16", dr[15].ToString()); cmd.Parameters.AddWithValue("@param17", dr[16].ToString()); cmd.Parameters.AddWithValue("@param18", dr[17].ToString()); cmd.Parameters.AddWithValue("@param19", dr[18].ToString()); cmd.Parameters.AddWithValue("@param20", dr[19].ToString()); cmd.Parameters.AddWithValue("@param21", dr[20].ToString()); cmd.Parameters.AddWithValue("@param22", dr[21].ToString()); cmd.Parameters.AddWithValue("@param23", dr[22].ToString()); cmd.Parameters.AddWithValue("@param24", dr[23].ToString()); cmd.Parameters.AddWithValue("@param25", dr[24].ToString()); cmd.Parameters.AddWithValue("@param26", dr[25].ToString()); cmd.Parameters.AddWithValue("@param27", Convert.ToDecimal(dr[26].ToString())); cmd.Parameters.AddWithValue("@param28", Convert.ToDecimal(dr[27].ToString())); cmd.Parameters.AddWithValue("@param29", Convert.ToDecimal(dr[28].ToString())); cmd.Parameters.AddWithValue("@param30", Convert.ToDecimal(dr[29].ToString())); cmd.Parameters.AddWithValue("@param31", Convert.ToDecimal(dr[30].ToString())); cmd.Parameters.AddWithValue("@param32", dr[31].ToString()); cmd.ExecuteNonQuery(); // new SqlCommand (stmt, mysqlcon).ExecuteNonQuery();
LabelImport.Text = "Rows Inserted"; } mysqlcon.Close(); }// connection for detail file

protected OleDbCommand detExcelConnection() { // Connect to the Excel Spreadsheet
string detConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/imports/detailorder.xls") + ";" + "Extended Properties=Excel 8.0;"; // create your excel connection object using the connection string
OleDbConnection detXConn = new OleDbConnection(detConnStr); detXConn.Open(); // create your excel connection object using the connection string // use a SQL Select command to retrieve the data from the Excel Spreadsheet // the "table name" is the name of the worksheet within the spreadsheet // in this case, the worksheet name is "Sheet1" and is expressed as: [Sheet1$]
OleDbCommand detCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", detXConn); return detCommand; }// importing detail information

protected void ButtonImport_Click(object sender, EventArgs e) { PanelUpload.Visible = false; PanelView.Visible = false; PanelImport.Visible = true; LabelImport.Text = ""; // reset to blank // Create a new Adapter
OleDbDataAdapter objDataAdapter = new OleDbDataAdapter(); // retrieve the Select command for the Spreadsheet
objDataAdapter.SelectCommand = detExcelConnection();

// Create a DataSet
DataSet objDataSet = new DataSet(); // Populate the DataSet with the spreadsheet worksheet data
objDataAdapter.Fill(objDataSet);

// deleting the exisitng table before copy
SqlConnection mycon = new SqlConnection(ConfigurationManager.ConnectionStrings["ImportexcelConnectionString"].ConnectionString); SqlCommand SqlCmd = null; mycon.Open(); SqlCmd = mycon.CreateCommand(); SqlCmd.CommandText = "DELETE FROM Detail"; SqlCmd.ExecuteNonQuery(); mycon.Close(); // entering newer detail information
SqlConnection mysqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ImportexcelConnectionString"].ConnectionString); mysqlcon.Open(); foreach (DataRow dr1 in objDataSet.Tables[0].Rows) { String sqlinsert = "insert into Detail values(@param1,@param2,@param3,@param4,@param5,@param6,@param7,@param8,@param9,@param10,@param11,@param12,@param13)"; SqlCommand cmd = new SqlCommand(sqlinsert, mysqlcon); cmd.Parameters.AddWithValue("@param1", dr1[0].ToString()); cmd.Parameters.AddWithValue("@param2", dr1[1].ToString()); cmd.Parameters.AddWithValue("@param3", dr1[2].ToString()); cmd.Parameters.AddWithValue("@param4", dr1[3].ToString()); cmd.Parameters.AddWithValue("@param5", dr1[4].ToString()); cmd.Parameters.AddWithValue("@param6", dr1[5].ToString()); cmd.Parameters.AddWithValue("@param7", dr1[6].ToString()); cmd.Parameters.AddWithValue("@param8", Convert.ToDecimal(dr1[7].ToString())); cmd.Parameters.AddWithValue("@param9", Convert.ToDecimal(dr1[8].ToString())); cmd.Parameters.AddWithValue("@param10", dr1[9].ToString()); cmd.Parameters.AddWithValue("@param11", dr1[10].ToString()); cmd.Parameters.AddWithValue("@param12", dr1[11].ToString()); cmd.Parameters.AddWithValue("@param13", dr1[12].ToString()); cmd.ExecuteNonQuery(); LabelImport.Text = "Rows Inserted"; } mysqlcon.Close(); } the error is as follows:
Server Error in '/WebSite6' Application.


The DELETE statement conflicted with the REFERENCE constraint
"FK_Detail_Header". The conflict occurred in database "C:DOCUMENTS AND
SETTINGSMEMY DOCUMENTSVISUAL STUDIO
2005WEBSITESWEBSITE6APP_DATADATABASE.MDF", table "dbo.Detail", column
'OrderID'.The statement has been terminated. 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.Data.SqlClient.SqlException: The DELETE statement conflicted with the
REFERENCE constraint "FK_Detail_Header". The conflict occurred in database
"C:DOCUMENTS AND SETTINGSMEMY DOCUMENTSVISUAL STUDIO
2005WEBSITESWEBSITE6APP_DATADATABASE.MDF", table "dbo.Detail", column
'OrderID'.The statement has been terminated.Source Error:




Line 176: SqlCmd = mycon.CreateCommand();Line 177: SqlCmd.CommandText = "DELETE FROM Header";Line 178: SqlCmd.ExecuteNonQuery();Line 179: mycon.Close();Line 180:  again i really appreciate.Thanks 

View 1 Replies View Related

Null Reference Error When Using A Custom Assembly That Uses An App.config File

Apr 7, 2008

I have a custom assembly that uses a config file to obtain database connection settings. This dll is then used by my sql report. I have added refrerenced to all the required dll's in my report and added the required code groups to all the necessary files. I have also placed my app.config file in C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer and C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies
However when I actually run the report in the designer (vs2005) I am receiving Null reference exceptions when my code tries to read my config file because it is reading the machine.config file and not my app.config file. If I hard code my connection string everything works fine.

Can anyone tell me why the machine.config file would be referenced instead of my app.config file and how I can stop it from doing this?

View 6 Replies View Related

Error Object Reference Not Set To An Instance On SQL 2005 Reporting Services

Aug 8, 2007

Reporting Services on my production server stopped working. If I try to open it from Management studio, I get the error below.

Already tried installing patch 07-040, re-registering asp.net, and a few other stuff. Can you guys help me?

TITLE: Connect to Server
------------------------------
Cannot connect to GRUMIUM.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.2047.00" target="_blank">Get Online Help</a></li><ul>
<li>Object reference not set to an instance of an object.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------

View 2 Replies View Related

How To Trap DELETE Statement Conflicted With COLUMN REFERENCE Constraint Error

Oct 26, 2004

Hi,

On my aspx Web page, I want to delete a member from database table 'tblMember', but if this MemberID is used as FK in another table, I want to display a user friendlier message like "You cannot delete this member, ....." I am using Try, Catch blocks in my Web Page.

Currently it display this message:
"DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_..._....' The conflict occurred in database '...', table 'tblMembers', column 'MemberID'. The statement has been terminated. "

So how should I precisely trap this error? Does anybody know what Exception is it? or what error number in SQL server?


Thanks

View 2 Replies View Related

Executing A Sp Via ADO Which Makes A Reference To Linked Server Table Results In Error

Oct 17, 1999

Greetings,

Facing a strange problem, but obviously not expected earlier on, I am trying to execute a stored procedure via ADO which refrences a linked server table and I get an error specifying
"
OLEDB provider SQLOLEDB does not contain table "<DatabaseName>"."<owner>"."<tableName>"
"

Has any one else encountered this problem before ?
regards
Govind

View 1 Replies View Related

How To Solve :Error: 0xC0047062 At CTPKPF, DataReader Source [1]: System.NullReferenceException: Object Reference Not Set To An

Apr 7, 2007

hi

i need help to solve following error in ssis package when i aun ::



Error: 0xC0047062 at CTPKPF, DataReader Source [1]: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket) Error: 0xC0047038 at CTPKPF, DTS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "DataReader Source" (1) returned error code 0x80004003. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. Error: 0xC0047021 at CTPKPF, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. Information: 0x40043008 at CTPKPF, DTS.Pipeline: Post Execute phase is beginning. Information: 0x40043009 at CTPKPF, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at CTPKPF, DTS.Pipeline: "component "OLE DB Destination" (1993)" wrote 0 rows. Task failed: CTPKPF

View 11 Replies View Related

Server Error: Object Reference Not Set To An Instance Of An Object. Trying To Upload Image In Database

Dec 17, 2007

Does any one has any clue for this error ? I did went through a lot of articles on this error but none helped . I am working in Visual studie 2005 and trying to upload image in sql database through a simple form. Here is the code
 
using System;
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 System.Data.SqlClient;
using System.Web.Configuration;
using System.IO;
public partial class Binary_frmUpload : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e)
{
}protected void btnUpload_Click(object sender, EventArgs e)
{if (FileUpload.HasFile == false)
{
// No file uploaded!lblUploadDetails.Text = "Please first select a file to upload...";
}
else
{string str1 = FileUpload.PostedFile.FileName;
 string str2 = FileUpload.PostedFile.ContentType; string connectionString = WebConfigurationManager.ConnectionStrings["GSGA"].ConnectionString;
//Initialize SQL Server Connection SqlConnection con = new SqlConnection(connectionString);
//Set insert query string qry = "insert into Officers (Picture,PictureType ,PicttureTitle) values(@ImageData, @PictureType, @PictureTitle)";
//Initialize SqlCommand object for insert. SqlCommand cmd = new SqlCommand(qry, con);
//We are passing Original Image Path and Image byte data as sql parameters. cmd.Parameters.Add(new SqlParameter("@PictureTitle", str1));
cmd.Parameters.Add(new SqlParameter("@PictureType", str2));Stream imgStream = FileUpload.PostedFile.InputStream;
int imgLen = FileUpload.PostedFile.ContentLength;byte[] ImageBytes = new byte[imgLen]; cmd.Parameters.Add(new SqlParameter("@ImageData", ImageBytes));
//Open connection and execute insert query.
con.Open();
cmd.ExecuteNonQuery();
con.Close(); //Close form and return to list or images.
 
}
}
}
 
Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set to an instance of an object.Source Error:



Line 32:
Line 33: string str2 = FileUpload.PostedFile.ContentType;
Line 34: string connectionString = WebConfigurationManager.ConnectionStrings["GSGA"].ConnectionString;
Line 35:
Line 36: //Initialize SQL Server Connection Source File: c:UsersManojDocumentsVisual Studio 2005WebSitesGSGABinaryfrmUpload.aspx.cs    Line: 34  
Stack Trace:




[NullReferenceException: Object reference not set to an instance of an object.]
Binary_frmUpload.btnUpload_Click(Object sender, EventArgs e) in c:UsersManojDocumentsVisual Studio 2005WebSitesGSGABinaryfrmUpload.aspx.cs:34
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

View 2 Replies View Related

When Using A Sqldataadapter In VS 2005 I Get The Following Error At Runtime. Object Reference Not Set To An Instance Of An Object

Dec 21, 2006

Help! I have posted this before and I had hoped that the VS2005 SP1 would help my problem. It didn't. My code is shown below. I have dropped a sqlconnection, sqldataadapter and a strongly-typed dataset from the toolbox onto the component designer for my page and written my code. It compiles without any errors but at runtine I receive the system error "Object reference not set to an instance of an object." The error occurs at the first line where the sqldataadapter is mentioned. I have shufflled the code and the error still occurs at first mention of the dataadapter. I have set parameters to a simple string such as "myemail." It hasn't helped. I have used the "Dim" statement as "Dim DaAuthorLogin as System.Data.SqlClient.SqlDataadapter and Dim DaAuthorLogin as New ......) at the start of the private sub generated by the event requiring the data. Nothing helps. Here is my simple code to select data from a sqlserver 2000 database. Why do I continue to get this error?
Partial Class AuthorLogin
Inherits System.Web.UI.Page
Protected WithEvents AuthorInformation As System.Web.UI.Page
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.SqlSelectCommand1 = New System.Data.SqlClient.SqlCommand
Me.DaAuthorLogin = New System.Data.SqlClient.SqlDataAdapter
Me.MDData = New System.Data.SqlClient.SqlConnection
Me.DsAuthorLogin = New MedicalDecisions.DsAuthorLogin
CType(Me.DsAuthorLogin, System.ComponentModel.ISupportInitialize).BeginInit()
'
'SqlSelectCommand1
'
Me.SqlSelectCommand1.CommandText = "SELECT AuthorAlias, AuthorEmail, AuthorPassword, LastName, PreferredName" & Global.Microsoft.VisualBasic.ChrW(13) & Global.Microsoft.VisualBasic.ChrW(10) & "FRO" & _
"M T_Author" & Global.Microsoft.VisualBasic.ChrW(13) & Global.Microsoft.VisualBasic.ChrW(10) & "WHERE (AuthorEmail = @AuthorEmail) AND (AuthorPassword =" & _
" @AuthorPassword)"
Me.SqlSelectCommand1.Connection = Me.MDData
Me.SqlSelectCommand1.Parameters.AddRange(New System.Data.SqlClient.SqlParameter() {New System.Data.SqlClient.SqlParameter("@AuthorEmail", System.Data.SqlDbType.NVarChar, 50, "AuthorEmail"), New System.Data.SqlClient.SqlParameter("@AuthorPassword", System.Data.SqlDbType.NVarChar, 50, "AuthorPassword")})
'
'DaAuthorLogin
'
Me.DaAuthorLogin.SelectCommand = Me.SqlSelectCommand1
Me.DaAuthorLogin.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "T_Author", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("AuthorAlias", "AuthorAlias"), New System.Data.Common.DataColumnMapping("AuthorEmail", "AuthorEmail"), New System.Data.Common.DataColumnMapping("AuthorPassword", "AuthorPassword"), New System.Data.Common.DataColumnMapping("LastName", "LastName"), New System.Data.Common.DataColumnMapping("PreferredName", "PreferredName")})})
'
'MDData
'
Me.MDData.ConnectionString = "Data Source=CIS1022DAVID;Initial Catalog=CGData;Integrated Security=True;Pooling" & _
"=False"
Me.MDData.FireInfoMessageEventOnUserErrors = False
'
'DsAuthorLogin
'
Me.DsAuthorLogin.DataSetName = "DsAuthorLogin"
Me.DsAuthorLogin.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema
CType(Me.DsAuthorLogin, System.ComponentModel.ISupportInitialize).EndInit()
End Sub
Friend WithEvents SqlSelectCommand1 As System.Data.SqlClient.SqlCommand
Friend WithEvents MDData As System.Data.SqlClient.SqlConnection
Friend WithEvents DaAuthorLogin As System.Data.SqlClient.SqlDataAdapter
Friend WithEvents DsAuthorLogin As MedicalDecisions.DsAuthorLogin
'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs)
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
'no code here
End Sub
Private Sub AuthorLoginRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AuthorLoginRegister.Click
'for new author registration
Response.Redirect("AuthorInformation.aspx")
End Sub
Private Sub AuthorLoginBack_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AuthorLoginBack.Click
'to navigate back
Response.Redirect("MainPaths.aspx")
End Sub
Protected Sub AuthorLoginPassword_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AuthorLoginPassword.TextChanged
'pass the parameters to the dataadapter and return dataset
DaAuthorLogin.SelectCommand.Parameters("@AuthorEmail").Value = AuthorLoginEmail.Text
DaAuthorLogin.SelectCommand.Parameters("@AuthorPassword").Value = AuthorLoginPassword.Text
MDData.Open()
DaAuthorLogin.Fill(DsAuthorLogin, "T_Author")
MDData.Close()
'set session objects
If DsAuthorLogin.T_Author.Rows.Count > 0 Then
Session("AuthorAlias") = DsAuthorLogin.T_Author(0).AuthorAlias
Session("LastName") = DsAuthorLogin.T_Author(0).LastName
Session("PreferredName") = DsAuthorLogin.T_Author(0).PreferredName
Response.Redirect("AuthorPaths.aspx")
Else : AuthorLoginNotValid.Visible = True
AuthorLoginEmail.Text = ""
AuthorLoginPassword.Text = ""
End If
End Sub
End Class
 
Thanks in advance,
David

View 2 Replies View Related

Error: The Script Threw An Exception: Object Reference Not Set To An Instance Of An Object.

Sep 12, 2006



Anyone know what this error means and how to get rid of it?



Public Sub Main()

Dim myMessage As Net.Mail.MailMessage

Dim mySmtpClient As Net.Mail.SmtpClient

myMessage.To(20) = New Net.Mail.MailAddress(me@hotmail.com)

myMessage.From = New Net.Mail.MailAddress(someone@microsoft.com)

myMessage.Subject = "as;dlfjsdf"

myMessage.Priority = Net.Mail.MailPriority.High

mySmtpClient = New Net.Mail.SmtpClient("microsoft.com")

mySmtpClient.Send(myMessage)

Dts.TaskResult = Dts.Results.Success

End Sub



Thanks,

View 4 Replies View Related

Predict Query Gives 'DMPluginWrapper; Object Reference Not Set To An Instance Of An Object' Error

Mar 17, 2008



Hi,

I am trying to develop a custom algorithm. I have implemented and tested training methods, however I fail at prediction phase. When I try to run a prediction query against a model created with my algorithm I get:


Executing the query ...
Obtained object of type: Microsoft.AnalysisServices.AdomdClient.AdomdDataReader
COM error: COM error: DMPluginWrapper; Object reference not set to an instance of an object..
Execution complete


I know this is not very descriptive, but I have seen that algorith doesn't even executes my Predict(..) function (I can test this by logging to a text file)
So the problem is this, when I run prediction query DMPluginWrapper gives exception -I think- even before calling my custom method.

As I said it is not a very descriptive message but I hope I have hit a general issue.

Thanks...

View 3 Replies View Related

VS 2005 Error 'Object Reference Not Set To An Instance Of An Object' With Integration Services Project Create Failure

May 22, 2008



Just installed VS 2005 & SQLServer 2005 clients on my workstation. When trying to create a new Integration Services Project and start work in the designer receive the MICROSOFT VISUAL STUDIO 'Object reference not set to an instance of an object.' dialog box with message "Creating project 'Integration Services project1'...project creation failed."

Previously I had SQLServer 2000 client with the little VS tool that came with it installed. Uninstalled these prior to installing the 2005 tools (VS and SQLServer).

I'm not finding any information on corrective action for this error.

Any one have this problem and found the solution?

Thanks,
CLC

View 1 Replies View Related

Script Task Error --Object Reference Not Set To An Instance Of An Object

Sep 13, 2006

I am trying to execute this code feom Script task while excuting its giving me error that "Object reference not set to an instance of an object." The assemblies Iam referening in this code are there in GAC. Any idea abt this.



Thanks,

Public Sub Main()

Dim remoteUri As String

Dim fireAgain As Boolean

Dim uriVarName As String

Dim fileVarName As String

Dim httpConnection As Microsoft.SqlServer.Dts.Runtime.HttpClientConnection

Dim emptyBytes(0) As Byte

Dim SessionID As String

Dim CusAuth As CustomAuth

Try

' Determine the correct variables to read for URI and filename

uriVarName = "vsReportUri"

fileVarName = "vsReportDownloadFilename"

' create SessionID for use with HD Custom authentication

CusAuth = New CustomAuth(ASCIIEncoding.ASCII.GetBytes(Dts.Variables("in_vsBatchKey").Value.ToString()))



Dts.Variables(uriVarName).Value = Dts.Variables(uriVarName).Value.ToString() + "&" + _

"BeginDate=" + Dts.Variables("in_vsBeginDate").Value.ToString() + "&" + _

"EndDate=" + Dts.Variables("in_vsEndDate").Value.ToString()

Dim request As HttpWebRequest = CType(WebRequest.Create(Dts.Variables(uriVarName).Value.ToString()), HttpWebRequest)

'Set credentials based on the credentials found in the variables

request.Credentials = New NetworkCredential(Dts.Variables("in_vsReportUsername").Value.ToString(), _

Dts.Variables("in_vsReportPassword").Value.ToString(), _

Dts.Variables("in_vsReportDomain").Value.ToString())

'Place the custom authentication session ID in a cookie called BatchSession

request.CookieContainer.Add(New Cookie("BatchSession", CusAuth.GenerateSession("EmailAlertingSSIS"), "/", Dts.Variables("in_vsReportDomain").Value.ToString()))

' Set some reasonable limits on resources used by this request

request.MaximumAutomaticRedirections = 4

request.MaximumResponseHeadersLength = 4

' Prepare to download, write messages indicating download start

Dts.Events.FireInformation(0, String.Empty, String.Format("Downloading '{0}' from '{1}'", _

Dts.Variables(fileVarName).Value.ToString(), Dts.Variables(uriVarName).Value.ToString()), String.Empty, 0, fireAgain)

Dts.Log(String.Format("Downloading '{0}' from '{1}'", Dts.Variables(fileVarName).Value.ToString(), Dts.Variables(uriVarName).Value.ToString()), 0, emptyBytes)

' Download data

Dim response As HttpWebResponse = CType(request.GetResponse(), HttpWebResponse)

' Get the stream associated with the response.

Dim receiveStream As Stream = response.GetResponseStream()

' Pipes the stream to a higher level stream reader with the required encoding format.

Dim readStream As New StreamReader(receiveStream, Encoding.UTF8)

Dim fileStream As New StreamWriter(Dts.Variables(fileVarName).Value.ToString())

fileStream.Write(readStream.ReadToEnd())

fileStream.Flush()

fileStream.Close()

readStream.Close()

fileStream.Dispose()

readStream.Dispose()



'Download the file and report success

Dts.TaskResult = Dts.Results.Success

Catch ex As Exception

' post the error message we got back.

Dts.Events.FireError(0, String.Empty, ex.Message, String.Empty, 0)

Dts.TaskResult = Dts.Results.Failure

End Try

End Sub

View 1 Replies View Related

Reporting Services Error - Object Reference Not Set To An Instance Of An Object

Jan 14, 2008

Hello -

For the life of me I cannot figure out why i'm getting the "Object Refence Not Set To an Instance of An Object" error after I try and create a Report Services project in Business Intelligence Studio. I've followed all of the steps in similar posts such as checking the ReportServer/web.config file but everything checks out.

Does anyone have any other ideas as to how I can get rid of this annoying error and start creating some reports?

Thanks!!!







View 3 Replies View Related

Add New Database Error Object Reference Not Set To An Instance Of An Object

Oct 18, 2006

Hi,

I'm new to SQL database.

When I add a new item to project in VS2005: Project-->Add New Item --> Sql Database I got a error msg "object reference not set to an instance of an object" after click "Add" button. The SQL Server Express is running. How do I fix this problem?

Any help would be appreceiated.

CO22006

View 4 Replies View Related

Error: Object Reference Not Set To An Instance Of Object

Nov 22, 2005

When I operate like this: "Select APP_DATA node -> Add New Item -> Sql Database ->create a new aspnet.mdf file .However ,I get a error dialogbox like this :: object reference not set to an instance of object .Can someone who know how to solve this problem help me ?Thanks a lot !

View 1 Replies View Related

Object Reference Not Set To An Instance Of An Object Error

Apr 13, 2006

I'm new to ASP.Net and am trying to pull data from the db and populate an excel spreadsheet. I kget this error:Object reference not set to an instance of an object.on this:line 55: For i = 0 To dr.FieldCount - 1Here is my code:Protected Sub On_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Submit.Click        Dim i As Integer        Dim strLine As String, filePath, fileName, fileExcel        Dim objFileStream As FileStream        Dim objStreamWriter As StreamWriter        Dim nRandom As Random = New Random(DateTime.Now.Millisecond)        Dim Location As String        Dim SDate As String        Dim EDate As String        Location = Request.QueryString("Location")        SDate = Request.QueryString("StartDate")        EDate = Request.QueryString("EndDate")        'Dim fs As Object, myFile As Object        Dim cnn As SqlConnection = New SqlConnection("server=**.**.**.**;uid=******;pwd=******database=***")        'Create a pseudo-random file name.        fileExcel = "NR_Report" & nRandom.Next().ToString() & ".xls"        'Set a virtual folder to save the file.        'Make sure that you change the application name to match your folder.        filePath = "********"        fileName = filePath & "" & fileExcel        'Use FileStream to create the .xls file.        objFileStream = New FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write)        objStreamWriter = New StreamWriter(objFileStream)        'Use a DataReader to connect to the Pubs database.        cnn.Open()        Dim sql As String = "select [Tech Number] = u.user_techNo, Team = u.user_team, Name = upper(u.user_firstName) + ' ' + upper(u.user_lastName), [Total Jobs] = SUM(nr.nr_totaljobs), [Total IRDs] = SUM(nr.nr_totalirds), [IRDs Connected] = SUM(nr.nr_irdsConnected), [IRDs Non-Responding] = SUM(nr.nr_irdsNonResponding), [Percent Non-Responding] = case when SUM(nr.nr_irdsNonResponding) = 0 then 0.00 else round(SUM(cast(nr.nr_irdsNonResponding as decimal) ) / SUM(cast(nr.nr_irdsConnected as decimal)) * 100.00, 2) end from tblUsers u , tblNonResponders nr where u.user_techNo = nr.nr_irtech and u.user_techNo is not null and u.user_team is not null and u.user_office = " & Location & " and u.user_fireDate is null and u.user_suspend is null and nr.nr_reportweek between " & SDate & " and " & EDate & " group by u.user_techno, u.user_firstName, u.user_lastName, u.user_team order by u.user_team"        Dim cmd As SqlCommand = New SqlCommand(sql, cnn)        Dim dr As SqlDataReader        'Try        'dr = cmd.ExecuteReader()        'Catch ex As SqlException        'Response.Write(ex.Message)        'End Try        'Enumerate the field names and records that are used to build the file.        For i = 0 To dr.FieldCount - 1            strLine = strLine & dr.GetName(i).ToString & Chr(9)        Next        'Write the field name information to file.        objStreamWriter.WriteLine(strLine)        'Reinitialize the string for data.        strLine = ""        'Enumerate the database that is used to populate the file.        While dr.Read()            For i = 0 To dr.FieldCount - 1                strLine = strLine & dr.GetValue(i) & Chr(9)            Next            objStreamWriter.WriteLine(strLine)            strLine = ""        End While        'Clean up.        dr.Close()        cnn.Close()        objStreamWriter.Close()        objFileStream.Close()    End SubThanks in advance for any help.

View 6 Replies View Related

ERROR [42000] [Lotus][ODBC Lotus Notes]Table Reference Has To Be A Table Name Or An Outer Join Escape Clause In A FROM Clause

May 27, 2008

I am using web developer 2008, while connecting to I wanted to fetch data from Lotus notes database file, for this i used notesql connector, while connectiong to notes database i am fetting error


ERROR [42000] [Lotus][ODBC Lotus Notes]Table reference has to be a table name or an outer join escape clause in a FROM clause


I have already checked that database & table name are correct, please help me out
How i can fetch the lotus notes data in my asp.net pages.

View 1 Replies View Related

ERROR [42000] [Lotus][ODBC Lotus Notes]Table Reference Has To Be A Table Name Or An Outer Join Escape Clause In A FROM Clause

May 27, 2008

I am using web developer 2008, while connecting to I wanted to fetch data from Lotus notes database file, for this i used notesql connector, while connectiong to notes database i am fetting error


ERROR [42000] [Lotus][ODBC Lotus Notes]Table reference has to be a table name or an outer join escape clause in a FROM clause


I have already checked that database & table name are correct, please help me out
How i can fetch the lotus notes data in my asp.net pages.

View 1 Replies View Related

T-SQL Reference?

Feb 6, 2004

Hi y'all

Does anybody know reference or pdf file or free e-learning on the web?

View 1 Replies View Related

Reference

Jun 18, 2001

DECLARE Loan_cursor CURSOR FOR
SELECT Loan_No,store
FROM loan
WHERE maturity_date > '2001-04-30' and loan_no like 'ABL%'

OPEN Loan_cursor

-- Perform the first fetch.
FETCH NEXT FROM Loan_cursor

-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
Declare @LoanNo varchar(12)
** Set @LoanNo = Loan_No

-- This is executed as long as the previous fetch succeeds.
FETCH NEXT FROM Loan_cursor
END

CLOSE Loan_cursor
DEALLOCATE Loan_cursor


when l run the cursor l get the error
Server: Msg 207, Level 16, State 3, Line 15
Invalid column name 'Loan_No'.
.
If l reference it as Set @LoanNo = LoanTable.Loan_No l get the error

Server: Msg 107, Level 16, State 3, Line 15
The column prefix 'loan' does not match with a table name or alias name used in the query.
All l'm trying to do is to compare the loan number that l get from the cursor to the value in the loans table. Maybe reference is a better word

View 1 Replies View Related

Old Sp Reference

Jun 6, 2008

Hi friends,

Just i modified one sub stored procedures which is not getting affected in the main stored procedures

Create procedure main
as
begin
set nocount on

--First sp
exec Data_transfer_sp

--Second sp
Exec Clearance_sp

set nocount off
end

In data_transfer_sp,i have commented the select statement
but still iam use to the select result while execution the main sp.
Note:I have compiled the data_transfer_sp after making comment
.Txs in advance

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved