INSERT INTO of IMAGE in SQL-script

Posted by HomeSen on 09/22/2006 06:32am

Hi There, I need to know, how to write the INSERT-statement into a SQL-Script file. When using the Query Analyzer from Microsoft's SQL Server 2000, I get an hex-formatted string as value of this image-column. When reading the value using VB6 and ADO, then it's returned as bytearray. I already tried to write the raw data (bytearray) into script, but then it will be corrupted. And when I write the hex-fomatted string (I converted the bytearray to hex-string) it doesn't work either. I also tried it with and without singlequotes. But when I use the hex-string, I get an error from the SQL-Server, saying, that TEXT- is incompatible to IMAGE-datatype. So what can I do to fix this problem. I don't have the choice to directly import the data into the database. Except using a new import-tool, but this is pretty too mch work for the time I have for fixing the bug. Thx, Patrick

Reply

Slight improvements

Posted by jmcilhinney on 04/28/2006 10:36pm

You've closed your MemoryStreams but not Disposed them.  Also you can replace this:

Dim strFilename As String = _
    lblFilePath.Text.Substring(lblFilePath.Text.LastIndexOf("\")"+"1)

with this:

Dim strFilename As String = IO.Path.GetFileName(lblFilePath.Text)

Reply

reading a tiff image

Posted by pradhi on 04/27/2006 06:45am

how can i get the Length and Width of an .prt or .TIFF file

Reply

Can I store acquired images into a table of MS SQL server? Using Visual C++

Posted by Ranganadh on 02/16/2006 05:29am

I want urgent code for that

Reply

Exception Thrown while runtime

Posted by shafiulla on 08/14/2004 02:14pm

An unhandled exception of type 'System.InvalidCastException' occurred in system.data.dll Additional information: Object must implement IConvertible.

Can i store images in to the database using Visual c++ 6.0
Posted by Ranganadh on 02/16/2006 05:31am

i want it
Reply
.net behavour changed post
Posted by JenasysDesign on 01/24/2006 05:50pm

This code doesn't work. We had a unit test that was testing the code and it has started to fail post 13th July 2005. I suspect a service pack installation or security change in .net imaging. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=57655&SiteID=1
Reply

Reply

Comments