Re: Storing and Retreiving RichTextBox Image Objects in SQL Server Database

From: oj (nospam_ojngo_at_home.com)
Date: 04/07/04 

Date: Tue, 6 Apr 2004 17:16:11 -0700

Access (Jet) allows embed OLE. Sqlserver doesn't support such. The best you
can do is to store the binaries in an Image column.

See if this helps:
http://support.microsoft.com/?Id=258038 

-- 
-oj
http://www.rac4sql.net
"rhutchinson" <anonymous@discussions.microsoft.com> wrote in message
news:27EDB9B0-A6DE-4C79-8DEB-03649F7795E8@microsoft.com...
> Background: I developed a VB6.0 Application which allows a user, via a
RichTextBox, to Paste an image (from MS Paint) and store it as part of a
record stored in an MS Access Database - in a Memo Field
(rs.Fields("fldImage").Value = rtf.object).  This also works in the reverse,
when retrieving records: "rtf.object = rs.Fields("fldImage").Value" displays
the image in the RichTextBox.
>
> Current problem: Now we want to use a SQL Server Database for the
application.  EVERYTHING I read about "handling" images refers to the use of
FILES but, obviously, we don't have files.
>
> My question is: Does anyone know what/how the RichTextBox.object is
"handled", and how I can emulate the same behavior in our SQL Server
Database as I obtain in Access?  I have tried every datatype including IMAGE
with no luck.  I am suspecting that Access is storing something - ?binary
file? - and using a pointer, but this is over my head.  (I'd like to avoid
my user or my code having to create temporary files to Stream in and out of
the db - the only option I could think of).
>
> I'm a bit of a newbie and will need help at a fairly basic level, but ANY
feedback is appreciated.
> Thanks, Rex

Relevant Pages

  • Re: meta data & full text search
    ... There are more issues (transaction control, change control, audit of ... storing the files in a SQL Server table's column defined with an IMAGE ... if you store the files ... consistency of the database, indices, backup, restore, etc. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Database options
    ... > be able synchronize the Pocket PC database with its PC counterpart. ... > app to be a stand-alone app not needing an MS SQL server. ... we supply an object database engine that allows you to store C# ... objects directly: db4o. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Database options
    ... > be able synchronize the Pocket PC database with its PC counterpart. ... > app to be a stand-alone app not needing an MS SQL server. ... we supply an object database engine that allows you to store C# ... objects directly: db4o. ...
    (microsoft.public.pocketpc.developer)
  • Re: Storing Negative vs. Positive Values in DB
    ... I would store the ... > Thanks, Tom, but are you suggesting that maybe Access does have problems? ... > We give our users the option of using either Access or SQL Server. ... >> Perhaps a stupid database design question, ...
    (microsoft.public.vb.database.ado)
  • Re: public and private mailboxes randomly dismounting
    ... When posting logs an important piece is the Event ID and Source. ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)
Loading