🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: alt.lang.basic
Article #582

Re: Storing JPEGs in a SQL Server database

#582
From: Pete Nelson
Date: Tue, 26 Nov 1996 00:00
20 lines
1861 bytes
On Tue, 26 Nov 96 15:01:52 GMT, jsimpson@i1.net (John A. Simpson) wrote:

>I need some code or information on how to store JPEG graphic files in a SQL 
>Server database.  Any help would be greatly appreciated.

I've done it through Microsoft Access.  Create a table with an image
datatyped field, then through a linked table in Access, insert an
object.

Now, how would I go about adding JPEGs through some sort of batch
process (BCP, etc)?


====================================================================
 Pete Nelson <weasel@ecis.com>                  "My knees are cold."
 PGP 0x734EF061 FP: 91 C8 14 9D B5 2F AE 0A  69 DA E0 CE 5D C6 41 B1
 http://www.ecis.com/~weasel - Home of the Tech's Support Page, A-10
 Warthog Territory, Glocks in Movies & TV, Weasel's wcCODE Archive
====================================================================
Technical Details
Message-ID: <329f5c7d.12840812@gateway>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <57eup0$ist@twain.mo.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10c949,8d045e4ddf7c3eaf
X-Google-Attributes: gid10c949,public
X-Google-Thread: 11355a,8d045e4ddf7c3eaf
X-Google-Attributes: gid11355a,public
X-Google-Thread: 104de1,8d045e4ddf7c3eaf
X-Google-Attributes: gid104de1,public
X-Google-Thread: 10ab99,8d045e4ddf7c3eaf
X-Google-Attributes: gid10ab99,public
X-Google-Thread: 110e3b,8d045e4ddf7c3eaf
X-Google-Attributes: gid110e3b,public
X-Google-Thread: f6611,8d045e4ddf7c3eaf
X-Google-Attributes: gidf6611,public
From: weasel@ecis.com (Pete Nelson)
Subject: Re: Storing JPEGs in a SQL Server database
Date: 1996/11/26
Message-ID: <329f5c7d.12840812@gateway>
X-Deja-AN: 200909488
references: <57eup0$ist@twain.mo.net>
content-type: text/plain; charset=us-ascii
organization: Trinity Partners, Inc.
mime-version: 1.0
newsgroups: alt.lang.basic,bit.databases.mssql-l,bit.listserv.sqlinfo,comp.lang.basic.misc,comp.lang.basic.visual.misc,comp.databases.ms-sqlserver