Please Correct This Error While I Retriving Image From Database

Sep 4, 2007

private void Page_Load(object sender, System.EventArgs e)
{
    // Put user code to initialize the page here
    MemoryStream stream = new MemoryStream ();
    SqlConnection connection = new
      SqlConnection (@"...");
    try
    {
        connection.Open ();
        SqlCommand command = new
          SqlCommand ("select Picture from Image", connection);
        byte[] image = (byte[]) command.ExecuteScalar ();  
        stream.Write (image, 0, image.Length);
        Bitmap bitmap = new Bitmap (stream);
        Response.ContentType = "image/gif";
        bitmap.Save (Response.OutputStream, ImageFormat.Gif);
    }
    finally
    {
        connection.Close ();
        stream.Close ();
    }

Error:       byte[] image = (byte[]) command.ExecuteScalar ();   

Unable to cast object of type 'System.Int32' to type 'System.Byte[]'.

View 1 Replies


ADVERTISEMENT

Error Retriving Backup Filelistonly

Jan 28, 2008

Hi Guys.

i have write a store procedure which take few input and then backup the database and at the same time it's restore the database with new name, but i m hving a error code.
what this program do in restore section, it's read the backup file and all give me list of all the file with the location and then i can rename them.
actually the purpose of doing this is to create a new database on behalf of old database. plz have alook code
PLZ, PLZ help me, it's really geting headach



USE [master]

GO

/****** Object: StoredProcedure [dbo].[CreateNewDB] Script Date: 01/28/2008 17:13:09 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER proc [dbo].[CreateNewDB]

@ActualDb varchar(128),

@dbname sysname ,

@recipients varchar(128)

AS

SET NOCOUNT ON

Declare @cmd sysname ,

@filename varchar(128) ,

@Backuppath varchar(1000),

@LogicalName varchar(2000),

@ActualPath varchar(2000),

@Aloop int,

@FileID int,

@sql nvarchar(4000)



SET @Backuppath = 'C:' + @dbname

-- TAKE BACKUP



BACKUP DATABASE @ActualDb TO DISK = @Backuppath WITH NOFORMAT, INIT, NAME = 'DBBackup-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10



-- Get files in backup

select @cmd = 'restore filelistonly from disk = ''' + @Backuppath + ''''

CREATE table #RestoreFileListOnly

(

LogicalName sysname,

PhysicalName sysname,

type char(1),

FileGroupName sysname,

[size] bigint,

[MaxSize] bigint,

FileID int

)

INSERT into #RestoreFileListOnly

exec(@cmd)

-- buld the restore command

set @Aloop=1

set @FileID=0

set @sql= ''

set @sql = @sql + 'RESTORE DATABASE ' + @dbname + CHAR(10)

set @sql = @sql + ' FROM DISK = ''' + @Backuppath + '''' + CHAR(10)

set @sql= @sql + ' WITH FILE = 1' + CHAR(10)

WHILE (@aloop <= @@ROWCOUNT)

BEGIN

SELECT @LogicalName = LogicalName , @FileID = FileID, @ActualPath = Left(PhysicalName, len(PhysicalName)-charindex('',reverse(PhysicalName))+1) FROM #RestoreFileListOnly WHERE FILEID > @FileID


SET @sql= @sql + ',' + CHAR(10)

SET @sql= @sql + CHAR(9) + 'MOVE''' + @LogicalName + '''TO''' + @ActualPath + '''' + @dbname + ''''

-- @sql= @sql + 'MOVE '''+ + '' TO N'C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDATAMALIK.mdf'

SET @Aloop=@Aloop+1

END

SET @sql = @sql + ', NOUNLOAD, STATS = 10'

-- Restore the database

print @sql

EXEC (@sql)



Drop table #RestoreFileListOnly



-- send email to the define person.

EXEC master..xp_sendmail @subject = @cmd, @recipients = @recipients, @message = @@servername



ERROR:


Msg 213, Level 16, State 7, Line 1

Insert Error: Column name or number of supplied values does not match table definition.

Msg 3013, Level 16, State 1, Line 1

RESTORE FILELIST is terminating abnormally.

View 5 Replies View Related

Retriving Varchar(max) Value From Database

Jan 22, 2008

Hello,
I am using datareader to retrive the varchar (max) value from the database. But it is reteriving only 8000 why ? I am not using normal varchar datatype.
Below is the sample code.
Convert.ToString(_oDr["MyVar"])
where _oDr is the datareader
MyVar is defined of type varchar (max) in the sql 2005 database.
Any help will be appreciated.

View 3 Replies View Related

Retriving Deleted Record From Database

Aug 2, 2007

Hi friends

I have a bit problem here

Just I want to get back all deleted record of database

How do I perform this task?
If It is possible then plz help me out?

Thanks in Advance

Khan

View 4 Replies View Related

Retriving Gender From Database In A Radio Button

Mar 10, 2006

i am storing gender in the database.i want to retrive it in one of the radiobuttons for male and female already present on the form . how can i?

View 1 Replies View Related

Throwing Error When Querying The Image Of Database In SQL Server 2000.

Oct 3, 2007



I created an Image for the Database in sqlserver 2000. When I am querying directly the database as "Select * from employee", it is returning the result set.

But, when I am querying Database image with same query. It is giving error

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'Employee'

It is expecting the Database Owner. If I do query like "Select * from [Owner].employee", it is working fine.

My requirement is not use owner in queries, it should be simple query ("Select * from employee").


Can any one, help me out.
Thanks in advance.
Bhupesh

View 1 Replies View Related

Inserting And Retriving Datetime Field In Database MSSQL 2000

Jan 10, 2006

Hi, Assume I have a table name "myTime". This table is simply only have 1 (one) DATETIME field "MyTestTime" (also serve as a primary number).Table MyTime- MyTestTime : SQLTYPE DATETIMETo insert a new row into this field, I simply wrote :SqlCommand sqlCommand = new SqlCommand("insert into MyTime values('2006-01-09')", sqlConnection);
I got the value of "2006-01-09" from a textbox or other relevan control.I realize when I try to use "SELECT * FROM MyTime" statement, MSSQL server 2000 automatically convert my date value from "2006-01-09" to "01/09/2006" (from YYYY-MM-DD to MM/DD/YYYY). I don't know why this one must be converted to MM/DD/YYYY automatically (I believe this behavior is depend on some "setting option" in my MSSQL server - but I don't know which one).The challenge is :In my country, the actual date format is like German Date format (DD-MM-YYY). Well I know this is only "Customization" problem. But how insert datetime value given from sql query to a datetime variable?// Connect to database, make a query, get the datareader result, and bla bla blaDateTime aDateTime = new DateTime;aDateTime = Convert.ToDateTime(myDataReader["PostDate"].ToString());// close connectionMy question isHow can I make sure that aDateTime's day is 09 not 01. How my program know that 09 is day not month. I can't use string.split() method because it's possible that my database setting will change from "mm-dd-yyyy" to "dd-mm-yyyy"thanks

View 4 Replies View Related

Retriving Data From A Remote Sql Server Database And Storing It In A Local Sqlserver Db

Aug 1, 2001

Is it possible for retriving data from a remote Sql server database and storing it in a local sqlserver database.

View 1 Replies View Related

Image Located On Web, Url For Image Stored In Database

Aug 17, 2007



Hi,
I have a website and i am uploading the gif image to the database. i have used varchar(500) as the datatype and i am saving the file in the webserver so the path to it c:intepub....a.gif


my upload table has the folliwing feilds
UploadId Int Identity, Description, FileName, DiskPath varchar(500), weblocation varchar(500). I have a main sproc for the report where i am doing a inner join with other table to get the path of the gif..

So my question is how can i get a picture to show up on the report. .
What kinda datatype the gif file should be stored in the database? If it is stored as a varchar how can i access it and what is best way to reference that particular.

any help will appreciated....
Regards
Karen

View 9 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

Correct The Error

May 29, 2008

Hi friends,
I've created one procedure.I'm trying to execute that i got the error message like 'Must declare the scalar variable @series'.
but i declared it already.Table name starts with SI,dont have the fields like series and hono.I dont know how to correct this error.Please help me out.Here is my procedure.

alter proc procinsertAllFields
as
begin
declare @series varchar(10)
declare @hono varchar(5)
declare @tabname varchar(8)
declare @sql nvarchar(500)
if exists (select * from sysobjects where name=ltrim(rtrim('ccno_dir1')))
drop table ccno_dir1
set @sql='create table ccno_dir1(cc_no varchar(20),series varchar(1),
hono varchar(10),denom_code varchar(10),i_date datetime,d_date datetime,
locked varchar(10),csd_no varchar(10),invoice_no int,invoice_date datetime)'--print @sql
exec sp_executesql @sql

declare c cursor
for
select series=substring(name,3,1),hono =substring(name,4,5),name from sysobjects where name like 'si[1-3]_____'
open c
fetch next from c into @series,@hono,@tabname
while @@fetch_status=0
begin
print 'begin'
fetch next from c into @series,@hono,@tabname
set @sql='insert into ccno_dir1(cc_no,series,hono,denom_code,i_date,d_date,locked,csd_no,invoice_no,invoice_date)
select cc_no,series=@series,hono=@hono,denom_code,i_date,d_date,locked,csd_no,invoice_no,
invoice_date from '+@tabname
print @sql
exec sp_executesql @sql

end
close c
deallocate c
end

Thanks in advance!

kiruthika
http://www.ictned.eu

View 3 Replies View Related

How To Get The Correct Error Message

Jan 28, 2004

Hi Everyone!

In my stored procedure I check for any errors during .
If there are any errors I log them. (by checking @@ERROR)

What my problem is, the error message that's been logged contain place holders like %s, %l, %d,etc. along with the error message.

How can I get the full error message, with place holders replaced by real error values/text?

Here is a sample what I get as the error:

* Error ID: 547
* Error Desc: %ls statement conflicted with %ls %ls constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.

using this query
SELECT @errdesc=description FROM master.dbo.sysmessages WHERE error = @errid


When I run the stored proc in Query Analyser it gives the actual error message as:

Server: Msg 547, Level 16, State 1, Procedure sp_register_change, Line 366
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_TBL_EQUIPMENT'. The conflict occurred in database 'EquipManWT', table 'TBL_EQUIPMENT', column 'unitno'.
The statement has been terminated.



Thanks heaps,

rochana

View 6 Replies View Related

Unsure Of Where To Correct Error

Aug 28, 2006

Hi everyone,
I am a relative newbie to SQL and trying to do things via the self-taught method. I really have an issue that I am just unsure of what to do. I am working with a procedure that is for emailing invoices to customers. There can only be one account for a primary email address. From time to time a user will assign a second account to the email address. When the process runs, it sees the error and will not continue processing the remaining records. Any suggestions as to what I might be able to do? I need to have it so that the remaining records will process. (I think it may be important to note this is an application on a company intranet site.)
Thanks for any help you can provide.

View 7 Replies View Related

Input String Was Not In A Correct Format. Error

Apr 16, 2008

I have a page where user can insert a new record, i use stroed procedures:ALTER PROCEDURE [dbo].[sp_InsertTypes]
@Type varchar(10),
@Type_Desc varchar(35),
@Contact_Name varchar(20),
@Contact_Ad1 varchar(25),
@Contact_Ad2 varchar(25),
@Contact_City varchar(10),
@Contact_Phone varchar(12),
@Contact_Fax varchar(12),
@Contact_Email varchar(35)
Insert into dbo.Types (Type,Type_Desc,Contact_Name,Contact_Ad1,Contact_Ad2,Contact_City,Contact_Phone,
Contact_Fax,Contact_Email) values (@Type,@Type_Desc,@Contact_Name,@Contact_Ad1,@Contact_Ad2,@Contact_City,
@Contact_Phone, @Contact_Fax,@Contact_Email)
My code is:Protected Sub InsertButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim myConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString)Dim myCommand As SqlCommand
Dim TypeTxt As TextBox = FormView1.FindControl("TypeTextBox")Dim DescTxt As TextBox = FormView1.FindControl("TypeDescTextBox")
Dim NameTxt As TextBox = FormView1.FindControl("ContactNameTextBox")Dim phoneTxt As TextBox = FormView1.FindControl("ContactPhoneTextBox")
Dim ad1Txt As TextBox = FormView1.FindControl("ContactAd1Textbox")Dim ad2Txt As TextBox = FormView1.FindControl("ContactAd2Textbox")
Dim cityTxt As TextBox = FormView1.FindControl("ContactCityTextbox")Dim faxTxt As TextBox = FormView1.FindControl("ContactFaxTextbox")
Dim emailTxt As TextBox = FormView1.FindControl("ContactEmailTextbox")myCommand = New SqlCommand("[dbo].[sp_Insert_Types]", myConnection)
myCommand.CommandType = CommandType.StoredProcedure
myCommand.Parameters.Add("@Type", SqlDbType.BigInt).Value = TypeTxt.Text
myCommand.Parameters.Add("@Type_Desc", SqlDbType.VarChar).Value = DescTxt.Text
myCommand.Parameters.Add("@Contact_Name", SqlDbType.VarChar).Value =  NameTxt.Text
myCommand.Parameters.Add("@Contact_Phone", SqlDbType.VarChar).Value = phoneTxt.Text
myCommand.Parameters.Add("@Contact_Ad1", SqlDbType.VarChar).Value = ad1Txt.Text
myCommand.Parameters.Add("@Contact_Ad2", SqlDbType.VarChar).Value = ad2Txt.Text
myCommand.Parameters.Add("@Contact_City", SqlDbType.VarChar).Value =  cityTxt.Text
myCommand.Parameters.Add("@Contact_Fax", SqlDbType.VarChar).Value =  faxTxt.Text
myCommand.Parameters.Add("@Contact_Email", SqlDbType.VarChar).Value = emailTxt.Text myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()
End Sub
 I have almost the identical procedure & code for Update command button, and worked well, what am I doing wrong? I even tried adding ' in front and after the texts.
Thank you.

View 5 Replies View Related

Help With Input String Was Not In A Correct Format Error

May 29, 2008

I am trying to execute an SQL update statement as follows:myObj.Query("Update Schedule Set visitorScore=" + t1 + ", homeScore=" + t2 + " where id=" + Convert.ToInt16(HID.Value));However, I'm getting the following error message with regards to this line.: Exception Details: System.FormatException: Input string was not in a correct format.  Could anyone please tell me what is wrong with this line?  I have tried many different versions of this, but keep getting the same error. THANKS IN ADVANCE! 

View 3 Replies View Related

Error: Input String Was Not In A Correct Format?

Oct 20, 2005

Hi experts,  I am working on my asp.net application and received an error message on   dr = cmdGetFile.ExecuteReader:Error: Input string was not in a correct format. Can someone help me out of this?  Thank you in advance.------------------------------------------------------------------------------------ #Region " Web Form Designer Generated Code "
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()        Me.cmdGetFile = New System.Data.SqlClient.SqlCommand        Me.dbHRConn = New System.Data.SqlClient.SqlConnection        '        'cmdGetFile        '        Me.cmdGetFile.CommandText = "SELECT App_Resume_FileSize, App_Resume_FileName, App_Resume, App_Resume_FileType " & _        "FROM Mgmt_App_Resume_Table WHERE (Applicant_ID = @AppID)"        Me.cmdGetFile.Connection = Me.dbHRConn        Me.cmdGetFile.Parameters.Add(New System.Data.SqlClient.SqlParameter("@AppID", System.Data.SqlDbType.SmallInt, 2, "Applicant_ID"))        '        'dbHRConn        '        Me.dbHRConn.ConnectionString = "the connection string"
    End Sub
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load        Dim dr As System.Data.SqlClient.SqlDataReader        cmdGetFile.Parameters("@AppID").Value = Request("Applicant_ID")        dbHRConn.Open()        dr = cmdGetFile.ExecuteReader
        If dr.Read Then            Response.ContentType = dr("App_Resume_FileType").ToString            Response.OutputStream.Write(CType(dr("App_Resume"), _              Byte()), 0, CInt(dr("App_Resume_FileSize")))            Response.AddHeader("Content-Disposition", _              "attachment;filename=" + dr("App_Resume_FileName").ToString())        Else            Response.Write("File Not Found.")        End IfEnd Sub

View 5 Replies View Related

Correct Way To Attach Database When Uploading.

Dec 26, 2007

hello,
After I FTP a ASP.NET website to a webserver,  APP_DATA directory and all,   I then use the SQL publishing wizard to create a script on the local machine and run the script on the webserver/SQL server, it builds ok.  But I get an error "another database with the same name".  Duplicate of the database in APP_DATA directory that is already attached by the connection string.  So this isn't correct.
Second attempt:  I FTP an ASP.NET website up to a server.  Then I open the SQL management studio and attach the database in the website's APP_DATA folder.  (never running a .sql script)The database attaches.  The name of the database is the complete path to the database in the APP_DATA directory by default.  The website functions.  But if I try to look at a table I get an errors.  It gets to the point the database will not even expand.  Then I start getting errors in the browser that NETWORK SERVICE can not open it's default database.  So the website fails also.  So this doesn't work either....
 So I guess my question is, should I remapped the path of |DataDirectory| before I FTP it?  To a path where the other common system databases reside,  (I don't think that would be necessary.)    Then FTP the website without the contents of the app folder(no database).  Then use the script built with the SQL Publishing wizard to build the database,  and attach the database in SQL Management Studio?  ( I'm afraid of over playing and corrupting the server).
If I attach the database to manage it and the connection string attaches the database to run it,  will I always get errors?  What am I missing here?   
Thanks jamesqua for your help so far,  I understood the blog you sent me too.  But how do I modify it so I can use SQL Management studio to manage the database?  
Once again from My Uncle Bob "Things are simply awful,  or awfully simple"
-KK

View 5 Replies View Related

Transact SQL :: Want To Correct Database Design

Apr 29, 2015

I have below database already on one of the environment and its surprisingly designed somewhat in the past.now I want to correct it with one default filegroup with one primary and one log file, same time i am concerned for data as its production and no test environment is there, any way which ensure full consistency and steps i need to do...

CREATE
DATABASE [Sample]
ONĀ 
PRIMARY
(
NAME =
N'Sample_Data',

[code]....

View 11 Replies View Related

Reporting Services :: Error Showing Correct Month And Day

Nov 17, 2015

My laptop date format is mm/dd/yyyy.

In the report, I am using Format(field,"dd-MMM-yyyy"), but somehow the result comes out recognizing my month as day and my day as month. How do I fix this?

ie. my report date is 11/06/2015, the result shows 11-Jun-2015 instead of 06-Nov-2015.

View 2 Replies View Related

SQL 2005: Creating Correct And Incorrect Versions Of A Database

Jun 20, 2006

I work at a place which is currently running SQL 2000, but they areplanning to migrate to 2k5. I was thinking that this is the perfectopportunity to fix all the weaknesses we have had in our data model forthe longest: primary keys and foreign keys with different names, use ofcharacter columns for boolean fields, use of integer columns fortoggles, no referential integrity, etc.So, even if I create my Utopian perfect data model and modify all ofour data loaders to use it, our live website must use the old incorrectversion because there is way too much work involved in redoing thecode.My question then becomes: if I have a correct version, how easy andwith what approach would one take the data in the correct one andmirror it to the poorly designed schema?

View 4 Replies View Related

Error Handling Prevents Control Flow From Stopping. Is This Correct Behavior?

Dec 20, 2007



I have two tasks on a control flow. First task is Execute SQL task which drop an index. Second one is a Data Flow task. I also have an error handler for packcage_onerror. Because there is no index in the database, the first task rasies an error and package on error catches the error. The precedence constraint for the Data Flow task in "success". I don't expect the data flow task to execute because of the error. But it does. Is this the right behavior because I have already handle the error? I don't want the the job to continue if there is any error. I believe I should raise error in the error handler. Pleae help me how to do this. Thanks

View 12 Replies View Related

How To Troubleshoot/correct An Excel Destination - Opening A Rowset For &&<sheetname) Failed Error?

Apr 18, 2008

I have 2 Excel sheets ( Sheet1 and Summary) in an excel output file.
Sheet1 is created and loaded with data fine.
Summary sheet is getting the following error:
Error: 0xC0202009 at Write Counts and Percentages to Summary Sheet, Excel Destination [337]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.

Error: 0xC02020E8 at Write Counts and Percentages to Summary Sheet, Excel Destination [337]: Opening a rowset for "Summary" failed. Check that the object exists in the database.

I do have an execute SQL task to create the summary sheet before the data flow task.
The execute SQL task has
CREATE TABLE `Summary` (
`Counts_and_Percentages` LongText
)

Please advise on what I can do to troubleshoot/correct the error. Thanks

More details on the error
DTS.Pipeline] Error: "component "Excel Destination" (337)" failed validation and returned validation status "VS_ISBROKEN".
My Excel file name is an expression

@[User::FullFilePath] + (DT_STR, 4, 1252)DATEPART("yyyy", @[System::ContainerStartTime]) + "-" +
RIGHT("0" + (DT_STR, 2, 1252)DATEPART("mm", @[System::ContainerStartTime]), 2) + "-" +
RIGHT("0" + (DT_STR, 2, 1252)DATEPART("dd", @[System::ContainerStartTime]), 2) + " " +
RIGHT("0" + (DT_STR, 2, 1252)DATEPART("hh", @[System::ContainerStartTime]), 2) +
RIGHT("0" + (DT_STR, 2, 1252)DATEPART("mi", @[System::ContainerStartTime]), 2) +
RIGHT("0" + (DT_STR, 2, 1252)DATEPART("ss", @[System::ContainerStartTime]), 2) + " CLIENT=" +
@[User::ACCOUNT_NAME] + " output.xls"

View 4 Replies View Related

Getting Image From DB Error?

Mar 30, 2006

Unsure why I am getting such an error when the image is there and the
search feature for the site is not working so that doesn't help so I'm
hoping some out there can offer why I maybe getting this and help me
with getting the image from the DB.

I use the code from the starter app for retrieving an image from the DB and I get the error message:
Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'

Here is the code and I am getting the error on the red line (Return New MemoryStream(CType(result, Byte()))):

Public Overloads Function GetPhoto(ByVal UserName As String) As Stream
        command.CommandText = "sp_Themes_GetUserThemeImage"
        command.Parameters.Add("@UserName", SqlDbType.VarChar, 50)
        command.Parameters(0).Value = UserName

        Dim result As Object = command.ExecuteScalar
        Try
            If result Is Nothing Then
               
Dim path As String =
HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings("siteImageDirectory"))
                path = (path + "noimageav.gif")

               
Return New FileStream(path, FileMode.Open, FileAccess.Read,
FileShare.Read)
            Else
                Return New MemoryStream(CType(result, Byte()))
            End If
        Catch e As ArgumentNullException
            Return Nothing
        End Try
    End Function

---this is the code from the imagehandler.ashx page----
Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest
       
        Dim userName As String
        Dim stream As IO.Stream = Nothing
        If ((Not (context.Request.QueryString("UserName")) Is Nothing) _
           AndAlso (context.Request.QueryString("UserName") <> "")) Then
           
userName = [Convert].ToString(context.Request.QueryString("UserName"))
            stream = (New PhotoManager).GetPhoto(userName)
       
            '
Get the photo from the database, if nothing is returned, get the
default "placeholder" photo
            'If (stream Is Nothing) Then
           
'    stream = (New PhotoManager).GetDefaultPhoto()
            'End If
            ' Write image stream to the response stream
            Dim buffersize As Integer = (1024 * 16)
            Dim buffer() As Byte = New Byte((buffersize) - 1) {}
            Dim count As Integer = stream.Read(buffer, 0, buffersize)
       
            Do While (count > 0)
               
context.Response.OutputStream.Write(buffer, 0, count)
               
count = stream.Read(buffer, 0, buffersize)
            Loop
        End If
    End Sub

---this is how I call it from the image.aspx page----

<img src='imageHandler.ashx?username=<%# Eval("UserName") %>'
style="border:2px solid white;height:40px;" alt='Thumbnail.' />

Thanks for all your help.

View 6 Replies View Related

Image Error In SQL

Sep 1, 2006

I have a seperate table that holds employees pictures in it and for some reason I am getting an error all the sudden when I try to insert a picture. I never got that before.. Can anyone help please??

View 2 Replies View Related

Image Replication Error . Please Help !!

May 16, 2002

Hello ,

I have configured a transactional replication from SQL 7.0 to SQL server 2000 .SQL 7.0 server is a publisher and SQL 2000 server is a subscriber .
When i try to insert image greater than 64 KB it gives me an error message that replication supports only 64 KB .
This specific replication works over the firewall . So i really don't know whether its a problem of the firewall or the SQL Server configuration at both the ends .

Any help would be appreciated .

Thank you very much .

Regards,
Jerry .

View 1 Replies View Related

Retriving The ID Of The Last Record Inserted

Apr 23, 2006

 I would appreciate help with retriving the ID of the last record inserted. Have spent considerable time in forums and google but can't find anything that works for me.
Here is my VB Code
   Dim queryString As String = "INSERT INTO [DUALML] ([UseriD], [Company]) VALUES (@UseriD, @Company)"        Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand        dbCommand.CommandText = queryString        dbCommand.Connection = dbConnection
        Dim dbParam_useriD As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter        dbParam_useriD.ParameterName = "@UseriD"        dbParam_useriD.Value = useriD        dbParam_useriD.DbType = System.Data.DbType.Int32        dbCommand.Parameters.Add(dbParam_useriD)        Dim dbParam_company As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter        dbParam_company.ParameterName = "@Company"        dbParam_company.Value = company        dbParam_company.DbType = System.Data.DbType.[String]        dbCommand.Parameters.Add(dbParam_company)            
        Dim rowsAffected As Integer = 0        dbConnection.Open        Try            rowsAffected = dbCommand.ExecuteNonQuery        Finally            dbConnection.Close        End Try
        Return rowsAffected    End Function
 

View 4 Replies View Related

Retriving Data Fromsql Using Asp.net

Mar 26, 2005

every time i try to get data of a student stored in SQL server 2000 in the student table it gives me an error

Login failed for user '???????????ASPNET'

Exception Details: System.Data.SqlClient.SqlException: Login failed for user '??????????ASPNET'.


works fine normally its only when i try to reteive actuall data stored on the server. theres obviously something wrong the server side.


help help help

View 2 Replies View Related

Retriving Position In A Field

Aug 5, 2004

Hi All.

Is there a way to retrieve the position of a word, phrase or sign in a field?

For example, Field content is ABCDEFG1239/1002STJ

I would like to get the exact position of / which will be position 12.


Thank you.

Best regards

View 5 Replies View Related

Retriving Data From More Then Two Table

Aug 9, 2006

Baby writes "how to retrive data from four table
four tables have same column number and name
i am trying to retrive one column data from all the table
i am trying these :- to get the result

select mutual_fund.customer_id,insurance.customer_id,fixed_dep.customer_id,home_loan.customer_id from mutual_fund,insurance,fixed_dep,home_loan where (mutual_fund.customer_id=fixed_dep.customer_id and mutual_fund.customer_id=home_loan.customer_id and fixed_dep.customer_id=home_loan.customer_id) or (mutual_fund.customer_id=fixed_dep.customer_id and mutual_fund.customer_id=insurance.customer_id and fixed_dep.customer_id=insurance.customer_id) or (mutual_fund.customer_id=home_loan.customer_id and mutual_fund.customer_id=insurance.customer_id and home_loan.customer_id=insurance.customer_id) or (fixed_dep.customer_id=home_loan.customer_id and fixed_dep.customer_id=insurance.customer_id and home_loan.customer_id=insurance.customer_id)

the comparision working in the query
please help me tell me how to solve my problem"

View 1 Replies View Related

Retriving Data From Table In SQL CE

May 28, 2008



Hi
I am trying to retrive data from table store in .sdf database file
but not able to do it.
where i will use select * from xyz in project. I am developing it on desktop
using vc++ 2005 in SQL server compact edition.

am using

hr = pICmdText->Execute(NULL, IID_NULL, param, NULL, NULL);
It is not easy for me to see data of table from sdf file

so plz reply

View 9 Replies View Related

How To Add Image Into Sql Database

Feb 14, 2005

hi, friends

i need your help.
i want to add image into sql database.
how can i do this?

plz give any solution.

thank in advance.

it's urgent.

View 1 Replies View Related

Getting Image Into Database

Jun 7, 2006

Hey all, I have a table that i would like to be able to store images in but dont know how i can ge them in there.  How can i put the image in the database?  (sql express 2005, VS 2005 Pro) vbThanks!

View 1 Replies View Related

Sql Image Database

Aug 2, 2007

hi,
please help me about
how can I make a database containing image
I mean I want to make a database recording the date field and the image specified
how would it be possible the database show the image in records

View 1 Replies View Related







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