|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
View Imagetransferred from Access db awhile ago. In Access there is a way to see the image in OLE Object type column (right click on the field, then Bitmap Image Object, then Open. Paint starts displaying the contents of the field) It worked even when I linked SQL Server table to Access. Unfortunately the images stored in some format, which is not good to retrieve with ADODB.Stream (I don't know why. Although the disk file is created, but it cannot be opened by any graphic editor). I replaced those images in SQL Server with data passed by ADODB.Stream. Now there is no problem with viewing disk files, created by ADODB.Stream. But I cannot see those images via linked tables from Access. I was wondering if there is some tool, approach, way (whatever) to view the image stored in SQL Server table directly from Enterprise Manager? Although I can create a simple VB program to view the images, it would be nice to have the ability to see them from EM. Thank you A SQL Server image data type is nothing more than a byte stream. SQL Server
(and tools) has no knowledge of the binary contents - it could be bmp, jpg, exe, dll. etc. This is in contrast to storing binary data as an OLE Object, which includes additional meta-data about the associated application need to view the embedded data. OLE object-aware apps like Access can recognize an OLE object then use the associated application to view the data. > I was wondering if there is some tool, approach, way (whatever) to view Assuming you store a raw image byte stream, the application that renders the > the image stored in SQL Server table directly from Enterprise Manager? > Although I can create a simple VB program to view the images, it would be > nice to have the ability to see them from EM. image will need to know how to interpret the binary data. EM does not have this functionality since it's more of a DBA tool than a data presentation tool. -- Show quoteHope this helps. Dan Guzman SQL Server MVP "Esha" <a**@optonline.net> wrote in message news:%23AmR5MxDHHA.2328@TK2MSFTNGP02.phx.gbl... >I have a field of Image type in several tables in SQL Server 2000. Data was >transferred from Access db awhile ago. > In Access there is a way to see the image in OLE Object type column (right > click on the field, then Bitmap Image Object, then Open. Paint starts > displaying the contents of the field) > It worked even when I linked SQL Server table to Access. > Unfortunately the images stored in some format, which is not good to > retrieve with ADODB.Stream (I don't know why. Although the disk file is > created, but it cannot be opened by any graphic editor). > I replaced those images in SQL Server with data passed by ADODB.Stream. > Now there is no problem with viewing disk files, created by ADODB.Stream. > But I cannot see those images via linked tables from Access. > > I was wondering if there is some tool, approach, way (whatever) to view > the image stored in SQL Server table directly from Enterprise Manager? > Although I can create a simple VB program to view the images, it would be > nice to have the ability to see them from EM. > > Thank you > > > A more complete explanation than I offered, and next time, I need to refresh
the newsreader before replying... -- Show quoteArnie 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 "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message news:A262EB11-06D6-4602-AC97-293BC4CB8B5E@microsoft.com... >A SQL Server image data type is nothing more than a byte stream. SQL >Server (and tools) has no knowledge of the binary contents - it could be >bmp, jpg, exe, dll. etc. This is in contrast to storing binary data as an >OLE Object, which includes additional meta-data about the associated >application need to view the embedded data. OLE object-aware apps like >Access can recognize an OLE object then use the associated application to >view the data. > >> I was wondering if there is some tool, approach, way (whatever) to view >> the image stored in SQL Server table directly from Enterprise Manager? >> Although I can create a simple VB program to view the images, it would be >> nice to have the ability to see them from EM. > > Assuming you store a raw image byte stream, the application that renders > the image will need to know how to interpret the binary data. EM does not > have this functionality since it's more of a DBA tool than a data > presentation tool. > > -- > Hope this helps. > > Dan Guzman > SQL Server MVP > > "Esha" <a**@optonline.net> wrote in message > news:%23AmR5MxDHHA.2328@TK2MSFTNGP02.phx.gbl... >>I have a field of Image type in several tables in SQL Server 2000. Data >>was transferred from Access db awhile ago. >> In Access there is a way to see the image in OLE Object type column >> (right click on the field, then Bitmap Image Object, then Open. Paint >> starts displaying the contents of the field) >> It worked even when I linked SQL Server table to Access. >> Unfortunately the images stored in some format, which is not good to >> retrieve with ADODB.Stream (I don't know why. Although the disk file is >> created, but it cannot be opened by any graphic editor). >> I replaced those images in SQL Server with data passed by ADODB.Stream. >> Now there is no problem with viewing disk files, created by >> ADODB.Stream. But I cannot see those images via linked tables from >> Access. >> >> I was wondering if there is some tool, approach, way (whatever) to view >> the image stored in SQL Server table directly from Enterprise Manager? >> Although I can create a simple VB program to view the images, it would be >> nice to have the ability to see them from EM. >> >> Thank you >> >> >> > > A SQL Server image data type is nothing more than a byte stream. SQL Our database development tool, Database Workbench ( www.upscene.com )Server > (and tools) has no knowledge of the binary contents - it could be bmp, jpg, > exe, dll. etc. This is in contrast to storing binary data as an OLE Object, > which includes additional meta-data about the associated application need to > view the embedded data. OLE object-aware apps like Access can recognize an > OLE object then use the associated application to view the data. will detect the image type in a blob field, if known. It will display the image just fine. -- Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com Martijn Tonies wrote:
Show quote >> A SQL Server image data type is nothing more than a byte stream. SQL What a small world... I just read about you (Martijn) on the Daily WTF, > Server >> (and tools) has no knowledge of the binary contents - it could be bmp, > jpg, >> exe, dll. etc. This is in contrast to storing binary data as an OLE > Object, >> which includes additional meta-data about the associated application need > to >> view the embedded data. OLE object-aware apps like Access can recognize > an >> OLE object then use the associated application to view the data. > > Our database development tool, Database Workbench ( www.upscene.com ) > will detect the image type in a blob field, if known. It will display the > image > just fine. > > > and then see you posting here... :-) EM is NOT designed as a client 'front end' tool. It does not have the
ability to display images. You will have to have some form of client tool (your simple VB program) in order to view the images. With the image datatype, SQL Server is only storing 'bits', and is not concerned about what kind of image those bits may represent. That interpretation of bits is left to the client applications. -- Show quoteArnie 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 "Esha" <a**@optonline.net> wrote in message news:%23AmR5MxDHHA.2328@TK2MSFTNGP02.phx.gbl... >I have a field of Image type in several tables in SQL Server 2000. Data was >transferred from Access db awhile ago. > In Access there is a way to see the image in OLE Object type column (right > click on the field, then Bitmap Image Object, then Open. Paint starts > displaying the contents of the field) > It worked even when I linked SQL Server table to Access. > Unfortunately the images stored in some format, which is not good to > retrieve with ADODB.Stream (I don't know why. Although the disk file is > created, but it cannot be opened by any graphic editor). > I replaced those images in SQL Server with data passed by ADODB.Stream. > Now there is no problem with viewing disk files, created by ADODB.Stream. > But I cannot see those images via linked tables from Access. > > I was wondering if there is some tool, approach, way (whatever) to view > the image stored in SQL Server table directly from Enterprise Manager? > Although I can create a simple VB program to view the images, it would be > nice to have the ability to see them from EM. > > Thank you > > >  |
|||||||||||||||||||||||
Other interesting topics