Insert An Image In SQL Server With Stored Prcedure In ADO With C++

Oct 18, 2007

Hello.
I have a SQL table with one column that has the type = image.
I have a Stored procedure that inserts an image into that table.
CREATE PROCEDURE [dbo].[Test]
@test image
AS
BEGIN
insert into Table_1(test)values(@test)
END

I am using ADO in C++ for creating a connection,command, and parameters.



Code Block
VARIANT par;
par.vt = VT_ARRAY;
par.pbVal = (BYTE*)pBuffer;

pCommand->Parameters->Append(pCommand->CreateParameter("test",DataTypeEnum::adArray, ParameterDirectionEnum::adParamInput,strlen(pBuffer),par));
pCommand->Execute(NULL,NULL,CommandTypeEnum::adCmdStoredProc);



where



Code Block
_CommandPtr pCommand;
pCommand->CommandText = (_bstr_t)procedureName;
pCommand->CommandType = CommandTypeEnum::adCmdStoredProc;

//When I append the created parameter, in comutil.h, at these lines :
namespace _com_util {
inline void CheckError(HRESULT hr) throw(...)
{
if (FAILED(hr)) {
_com_issue_error(hr);
}
}

}






I get an exception : m_hresult 0x80020008 Bad variable type.


If I try to insert a string or an number, it works. But with BYTE* it dosen't.


Can someone help me?
Thanks

View 7 Replies


ADVERTISEMENT

Stored Prcedure And @@indentity

Jul 12, 2005

I'm trying something new, and have hit a snag.

basically, I'm attempting to use two INSERT commands in a single SP. I want to use the PK from the new entry and apply that to the second.

here's the code;

:::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::
CREATE PROCEDURE spInsertNewUser
@fn varchar(50),
@ln varchar(50),
@add varchar(50),
@add2 varchar(50),
@ct varchar(50),
@cty varchar(50),
@st varchar(4),
@pc varchar(50),
@ph varchar(50),
@cp varchar(50),
@fx varchar(50),
@em varchar(50),
@pw varchar(50),
@uid varchar(50),
@rc bit,
--@indentity int OUTPUT,
@cid int

AS

SET NOCOUNT ON

INSERT INTO tblUserInfo
(
firstName,
lastName,
address,
address2,
city,
county,
state,
postalCode,
phone,
cellPhone,
fax,
email,
pword,
userUID,
regConfirmed
)
VALUES (
@fn,
@ln,
@add,
@add2,
@ct,
@cty,
@st,
@pc,
@ph,
@cp,
@fx,
@em,
@pw,
@uid,
@rc
)


SELECT @@IDENTITY FROM tblUserInfo

--SET @indentity = @@IDENTITY

INSERT INTO tblUserToCountySubscribedLKP (
UserID, CountyID
) VALUES(
@@indentity, @cid
)
:::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::

I'm sure the problem is largely due to the fact that I am close to completely clueless on such things, but a bit of timely advice from the sage sql wizards here would be most welcome and greatly appreciated.

View 5 Replies View Related

How To Run The Package Trough The Stored Prcedure

Aug 3, 2007

hi focks;

through the jobs is possible it s working fine but

is it possible to run the packages through the stired procedure 2005

ok if possible how please help me

regards
koti




View 1 Replies View Related

Insert Image Using Clr Stored Procedure

Sep 1, 2006

I tried to insert a row using a clr stored procedure where a field was a varbinary(max) and the data was a jpg file. The data was truncated to 8000 bytes. A similar T-SQL sp did not truncate the data even though the parameters were identical. With the clr sp I tried varbinary, variant and image for the parameter type. The variant gave an exception. The others worked but the data was truncated.

I used sqlpipe.executeandsend. Someone asked elsewhere if the pipe had an 8000 byte limit but was told it had not.

Any ideas?

Thanks, John

View 5 Replies View Related

Error Handling In MSSQL - If Error During Call Remote Stored Prcedure I Need SQL Code To Continue...

Jul 20, 2005

Hi All,I want to catch the next MSSQL error in my SQL code with following continuecalculationsServer: Msg 17, Level 16, State 1, Line 1SQL Server does not exist or access denied.If REMOTE_SERVER_1 is inaccessible (as in (a) below) the executing of SQLwill not continue with (b) - I need the code in (b) to run despite whetherthe previous exec was successful or not - Any ideas?begin transaction(a) exec REMOTE_SERVER_1...bankinsert '1' , '1' , 1 , 0 , 0(b) print @@errorcommit transactionwhere REMOTE_SERVER_1 is link to server created byEXEC sp_addlinkedserver @server = 'REMOTE_SERVER_1', @srvproduct = '',@provider = 'SQLOLEDB', @datasrc = 'MYCOMP1', @catalog = 'mirror2'EXEC sp_addlinkedsrvlogin @rmtsrvname = 'REMOTE_SERVER_1', .....Exec sp_serveroption 'REMOTE_SERVER_1', 'data access', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc out', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'collation compatible', 'true'Any help will be greatly appreciated

View 1 Replies View Related

Insert Image Into SQL Server In Asp.net

Mar 30, 2005

help me;
i want to insert image into SQL server

View 1 Replies View Related

How To Load/Insert Image Into SQL SERVER

Mar 14, 2006

hi gurus,

im sure someone may have already posted this thread once before, but i cant seem find any topics using the search engines.

could some one point me in the right direction when it comes to inserting images into the databases. i.e. how to load/insert images into SQLSERVER2K

thanks in advance

View 3 Replies View Related

Insert Image Into Table SQL Server 2005

Jun 27, 2007

I have a table tblImage with column ImageName as varchar(50)  and picture as Image
 I am trying to Insert picture I have in C: drive into table using the following code
Insert into tblImage (ImageName, Picture)
Select 'Dog' as ImageName, Bulkcolumn from OPENROWSET(BULK N'C:dog1.jpg', SINGLE_BLOB) as picture
 I am getting error message.
Can I insert image into table through query.
Thanks in advance.
 
 

View 3 Replies View Related

Insert Image Into SQL Server (MSDE) Database

Feb 25, 2005

Dim con As New SqlConnection(ConfigurationSettings.AppSettings("con"))
con.Open()


Dim info= "this is a des."

Dim fs As New FileStream _
("C:Inetpubwwwrootimages est.jpeg", FileMode.OpenOrCreate, _
FileAccess.Read)
lblInfo.Text = "filestream created"
strInsert = "INSERT INTO image ( image, text ) VALUES ( 'fs' ,'" & info& "');"
lblInfo.Text = "Insert complete"
cmdInsert = New SqlCommand(strInsert, con)
cmdInsert.ExecuteNonQuery()
con.Close()

- Why is'nt the image inserted, only the text / info?

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

Is There Any Way To Insert Picture To Image Datatype In Sql Server 2000 Without Using Front End

Nov 12, 2007

Sir,  Is there any way to insert picture to image datatype in sql server 2000 without using front end. If so please let me know.  Thanks in Advance,Arun. 

View 3 Replies View Related

How To Retrieve Image Stored In SQL Server From My VB Project

Nov 29, 2001

Hi anyone can help me? i would like to retrieve an image stored in my SQL server from my VB project using ADO... anyone familiarise in it? pls help me... i need it urgently..... tks...

View 1 Replies View Related

Sending Uploaded Image To Data Access Class When Storing Image In SQL Server 2005

Apr 20, 2007

I am using the 3-tiered architecture design (presentation, business laws, and data acess layers). I am stuck on how to send the image the user selects in the upload file control to the BLL and then to the DAL because the DAL does all the inserts into the database. I would like to be able to check the file type in the BLL to make sure the file being uploaded is indeed a picture. Is there a way I can send the location of the file to the BLL, check the filetype, then upload the file and have the DAL insert the image into the database? I have seen examples where people use streams to upload the file directly from their presentation layer, but I would like to keep everything seperated in the three classes if possible. I also wasn't sure what variable type the image would be in the function in the BLL that receive the image from the PL. If there are any examples or tips anyone can give me that would be appreciated.

View 2 Replies View Related

Confuse On Stred Prcedure

Mar 16, 2007

Hi everyone.
What is meant by stored procedure?

DECLARE @newyear int ]
set @newyear = 2007 ]----> is it a stored procedure?

what about the CSVTable? is CSVTable a stored procedure?

Thanks. Im just confused.
-Ron-

View 3 Replies View Related

How To Save Image In Sql Server And Display That Image In Datagrid??

Jun 27, 2007

Hay Friend's
Can u plese send me the way how to save image in sql server and display that images in datagrid or other control also like Image control or Image control Button?? Plese send the coding in C#.
 Thank's
Amit

View 5 Replies View Related

How To Store Image In Image Field In Sql Server 2000

Jul 12, 2007



hi all,

i have created a table with image field in it. Now i just want to store a jpeg file in it but not finding any way to do so.



how can i store any image ? what are the steps???????





thanx in advance



View 5 Replies View Related

HOW To Retrieve An Image From Sql Server And Display It In ASP.net Using Imagemap Or Image ?

Jul 6, 2006

Ok, the problem is that , i have a field called "Attach" in sql of type image, when selecting it , the field is getting data of type BYTE(). which am being unable to display them on an Image on the panel.

using the following vb.net code:

'Dim sel2 As String

'Dim myCom As SqlCommand

'Dim conn As New SqlConnection

'Dim drr As SqlDataReader

'Dim image As System.Drawing.Image

'sel2 = "select * from attach where att_desc = '" & DropDownList1.SelectedItem().Text & "' and doc_code = " & w_doc_code & " and subcode = " & w_doc_subcode & " and doc_num= " & w_doc_num & " "

'conn.ConnectionString = ("server=developer01;uid=sa;password=aims;database=DVPSOC;timeout=45")

'myCom = New SqlCommand(sel2, conn)

'conn.Open()

'drr = myCom.ExecuteReader()

'If drr.Read Then

' Me.ImageMap1.ImageUrl = drr.Item("attach")

'End If

'conn.Close()

Am getting an exeption on the following line Me.ImageMap1.ImageUrl = drr.Item("attach")

saying: Conversion from type 'Byte()' to type 'String' is not valid.

knowing that i tried converting using ToString but it's not getting any output then.

thanks for your help.

View 4 Replies View Related

Report From Prcedure That Return Multiple Recordsets

Feb 11, 2007

Hi there,




I am creating a report from a stored procedure that returns
multiples record sets. For an example, my stored procedure is as follows








CREATE PROCEDURE MYPROCEDURE
AS









BEGIN
SELECT * FROM TABLE1
SELECT * FROM TABLE2
SELECT * FROM TABLE3
END












Now lets say I want to create a report that will display the
result of the query no 2 (which is SELECT * FROM TABLE2 in this example). How
can I do this? Is there any way to bind the second record set to the report
dataset with out changing the stored procedure?
I will appreciate any kind of suggestions on this
Thanks
Moim

View 8 Replies View Related

How To Insert An Image To Sql Db?

Sep 27, 2006

Hi there! how to insert an image to sql db using FileUpload Control? I saw a data type named "image", so it means to say you are able to insert an image and not the path, am I right? I spent a lot of time to do this but still, I don't know how to store the image to the db. Please post your example code if you want... I will appreciate all your suggestions or comments about this. Thanks!

View 2 Replies View Related

Image Insert

Dec 3, 2001

Good Morning to all,
I am new to SQL Server. My problem is I want to insert an image in Image type field. The image is on my local machine on c: drive(c:myphoto.jpg). Can any one help me how to insert this image in to SQL Server DB. If you can show me with syntaxt it will be more helpful.

thanks in advance.

Minesh.

View 1 Replies View Related

Insert Image

Feb 26, 2002

hi,

this may seem like rather a simple question, but can anyone tell me how to insert an image into a column of data type image in sql2000? ...using either vb or t-sql?

thanks,
michelle

View 1 Replies View Related

Insert Image

Jun 7, 2002

I have created a table that contains an image field and inserted 37 images into this table using the writetext method. But when I try to save the image to a file using Visual Basic I get an invalid format error when I open the bmp, gif, jpg file.

I tried doing the exact same thing with the pubs..pub_info table and the bmp, gif, and jpg file all open with no errors.

I then tried to insert one of these files into my table and see if it worked it did not.

So my question is how do I insert an image into a table correctly? Is there another way other then writetext?

View 2 Replies View Related

How To Insert Image

Jan 8, 2007

hi,
i want to insert image which is in my c directory to the database table, i have a table named as img which has the columns as id,picture.i want to insert image which is in my c:/hi.jpg,please give me query for this

View 1 Replies View Related

Insert A Image Into A Sql Database

Nov 27, 2007

Hello All,
I want to insert a images into a database and these images save into a one perticular folder.
and i want to use these Images into some Diffrent Diffrent area
 
please help me
ashwani

View 1 Replies View Related

Image.imageurl And Insert ? Can You Help Me ?

May 7, 2008

hello friends
can you help me ?
i know how textbox.text is inserted to colum of table(data type is char)
but i dont know how image.imageurl is inserted to column of table (data type is picture)..
can you write to me as source ? :)
my code is belowDim SglDataSource2, yeni As New SqlDataSource() SglDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings("ConnectionString").ToString
SglDataSource2.InsertCommandType = SqlDataSourceCommandType.Text
SglDataSource2.InsertCommand = "INSERT INTO table1 (product, user, imagex) VALUES (@product, @user, @imagex)"SglDataSource2.InsertParameters.Add("product", Textbox1.Text)
SglDataSource2.InsertParameters.Add("user", Textbox2.Text)SglDataSource2.InsertParameters.Add("imagex", image.imageurl)    this code line doesnt work ... what should i do ?
Dim rowsaffected As Integer = 0
Try
rowsaffected = SglDataSource2.Insert()Catch ex As Exception Server.Transfer("help.aspx")
Finally
SglDataSource2 = Nothing
End Try
If rowsaffected <> 1 ThenServer.Transfer("help.aspx")
ElseServer.Transfer("ok.aspx")
End If

View 1 Replies View Related

How Do I Insert Image Files?

Feb 6, 2001

How do I insert images, specifically small .jpg and .gif files, to a remote SQL Server 7.0 database?

Thanks,

Greg

View 2 Replies View Related

How I Can Insert A Value On A Image Datatype??

Sep 1, 2005

Hi!! Im psyche34. :confused:
I was confused on what to do on a Image datatype.
I had created a dummy database name "DUMMY_DB"
On that database I created a table name TB1 having a fields name: Picture as image
Text as text
through queries I insert a value to each field but the problem I can't insert a value on column Picture.

What value would I insert on the field "Picture"
Is it the directory where the picture was stored??

Please help Im badly needed to know. Thank you

View 1 Replies View Related

Is There Any Way To Insert Image Into DB Without Coding ??

May 25, 2007

I need just testing function that retreive image from SQL SERVER 2005 with data type "image" so i need to know another way to insert image into SQL SERVER2005 without coding. Because In MICROSOFT ACCESS, I just copy image and then, paste into column.

View 3 Replies View Related

Is There Any Way To Insert Image Into DB Without Coding ??

May 25, 2007

I need just testing function that retreive image from SQL SERVER 2005 with data type "image" so i need to know another way to insert image into SQL SERVER2005. Because In MICROSOFT ACCESS, I just copy image and then, paste into column.

View 1 Replies View Related

Insert Image Into Database

Dec 8, 2006

how to insert n image.jpg into the database? what should be insert query?

View 6 Replies View Related

How Can I Insert An Image Into A SQLServer Database?

Aug 23, 2005

How can I insert an Image into a SQLServer database?

View 1 Replies View Related

How To Insert A Value In Image Column Of A Table ?

Nov 15, 1999

Dear all,

In SQL server 6.5/7.0

I have bitmap file called pic123.bmp. it is available in c:pic123.bmp.

I have a table called pictb -- columns picid int, picval image.

How i insert the c:pic123.bmp file into picval column of pictb table.

Image columns only takes value of varbinary.....


How can i do that....? Please give your suggestions.....

Wincy

View 2 Replies View Related

How To Insert IMAGE Datatype In SQL Table

May 15, 2002

How do I add a row with a column of type IMAGE?

IMAGE column will hold a PDF file.
INSERT INTO Table (Image_Col) VALUES (....?)

View 2 Replies View Related







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