MS Service Pack frustrations: field

Showing posts with label field. Show all posts

Monday, March 12, 2012

ms sql image data from my-sql

hi people

I have imported "blob" data from mysql to an ms-sql 2000 "Image" field, using ms- sql enterprise manager. However my c# image veiwer does not work on the imported blob data (it does work on data I add to ms-sql via my web application).

Is there any way I can check that the blob data creates a valid image? If anyone has any ideas of how I can debug the data coming out that would be great. Or perhaps someone can point me to somewhere I can get some help?

any pointers are much appreciated!

Greg

There is an article on migration data from Oracle Unix to SQL you might find useful http://technet.microsoft.com/en-us/library/bb497067.aspx|||

Hi,

Here's one more idea: using ADO and simple vbscript/jscript you could save the blob to a file (using the chunk or stream model for BLOBs). Then simply open the file in an image viewer.

In addition, you could use similar approach and do byte-comparison with the data from the MySQL source.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

ok thanks guys, however I think my image data was simply corrupt after all of our efforts :-)

ms sql image + vb.net

Hi,

could anyone help me how to get the images from ms sql database with asp.net (visual basic)?

I have a field in the database with datatype image, and there are a couple of images in this table.

Now I am wondering how to get this images and view them on my .aspx page?

Thank you.I've have solved it.

<%@. Page Language="vb" debug="true" %>
<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>
<script runat="server">

Dim u As String

Sub Page_load
u = Request.QueryString("u")
getImage(u)
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<script runat=server
Public Sub getImage(ByVal u)

' Create Instance of Connection and Command Object

Dim myConnection As New SqlConnection("Server=localhost;uid=xx;pwd=xx;database=xx")

Dim myCommand As New SqlCommand("Select avatarImage from yaf_user where Name = @.u", myConnection)
myCommand.Parameters.AddWithValue("@.u", u)

Try

myConnection.Open()

Dim myDataReader As SqlDataReader

myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

Do While (myDataReader.Read())

'Response.ContentType = myDataReader.Item("avatar")
Response.ContentType = "image/gif"
Response.BinaryWrite(myDataReader.Item("avatarImage"))

Loop

myConnection.Close()

Response.Write("Person info successfully retrieved!")

Catch SQLexc As SqlException

Response.Write("Read Failed : " & SQLexc.ToString())

End Try

End Sub

</script>
</body>
</html

Friday, March 9, 2012

ms sql data tool

hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
appliactionName field
Thanks,Enterprise Mangler...
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
> appliactionName field
> Thanks,
>|||how could Enterprise Mangler...do the select * from a table?
Thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> Enterprise Mangler...
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
>> appliactionName field
>> Thanks,
>|||Some uses it to open a table. (Behind the scenes it executes the query
"SELECT * FROM table"
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
> how could Enterprise Mangler...do the select * from a table?
>
> Thanks
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> Enterprise Mangler...
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "mecn" <mecn2002@.yahoo.com> wrote in message
>> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
>> appliactionName field
>> Thanks,
>>
>|||> how could Enterprise Mangler...do the select * from a table?
By right-clicking a table name and selecting "open table"|||Got it, Thanks,
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23hq%23fhf$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> Some uses it to open a table. (Behind the scenes it executes the query
> "SELECT * FROM table"
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
>> how could Enterprise Mangler...do the select * from a table?
>>
>> Thanks
>> "Arnie Rowland" <arnie@.1568.com> wrote in message
>> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> Enterprise Mangler...
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "mecn" <mecn2002@.yahoo.com> wrote in message
>> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
>> appliactionName field
>> Thanks,
>>
>>
>

Monday, February 20, 2012

MS SQL 2000 and MS Word Document

I need one information. Is any possible to import word document into table
field ?
thnx
borisDo you want to insert the whole document into SQL Server or do you want to
extract information from the document and insert into SQL Server.
If you want to insert the document as a binary object I would recommend that
you look at the following section in Books Online:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_md_03_07zo.asp
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Boris" <boris@.osijek.hr> wrote in message
news:ehKokfXJFHA.2640@.TK2MSFTNGP09.phx.gbl...
>I need one information. Is any possible to import word document into table
>field ?
> thnx
> boris
>