Hi folks,
Is it possible to store Binary Files in MS SQL 2000 ??? Say I have a
100K PDF or a 150K word document. Is it possible to store this in a
field in MS SQL and pull it out somehow? We're using ColdFusion on the
server on Apache.
Thanks,
Ringo 3 6038
Ringo Langly (rl*****@gmail. com) writes: Is it possible to store Binary Files in MS SQL 2000 ??? Say I have a 100K PDF or a 150K word document. Is it possible to store this in a field in MS SQL and pull it out somehow? We're using ColdFusion on the server on Apache.
Yes, it's possible. You would use the image data type for this.
Unfortunately, I no nothing about ColdFusion, so I cannot give any
example of how to this in Cold Fusion. Working with image is however
more complex than other data types in SQL Server.
I should also add that there is a second alternative recommended by
many: store only the file path in SQL Server, and the file on disk.
I'm been proposing this myself at times. The main advantange is that
development becomes a lot simler. These days, however, I lean towards
storing the files in the database, as this is more robust and easier
to maintain. One single backup gets it all.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Doesn't that have performance implications?
Erland Sommarskog wrote: Ringo Langly (rl*****@gmail. com) writes: Is it possible to store Binary Files in MS SQL 2000 ??? Say I have
a 100K PDF or a 150K word document. Is it possible to store this in
a field in MS SQL and pull it out somehow? We're using ColdFusion on
the server on Apache.
Yes, it's possible. You would use the image data type for this. Unfortunately, I no nothing about ColdFusion, so I cannot give any example of how to this in Cold Fusion. Working with image is however more complex than other data types in SQL Server.
I should also add that there is a second alternative recommended by many: store only the file path in SQL Server, and the file on disk. I'm been proposing this myself at times. The main advantange is that development becomes a lot simler. These days, however, I lean towards storing the files in the database, as this is more robust and easier to maintain. One single backup gets it all.
-- Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
pb648174 (go****@webpaul .net) writes: Doesn't that have performance implications?
To store the documents in the database? Sure, it's more expensive than
to store the documents on disk. Then again, there is some network time
here, and file or database, you need to transfer the file over the
network.
In any case, sacrifcing database consistency for increased performance
is rarely a good trade-off.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: dave |
last post by:
Hello there,
I am at my wit's end ! I have used the following script succesfully to
upload an image to my web space. But what I really want to be able to do is
to update an existing record in a table in MySQL with the path & filename to
the image.
I have successfully uploaded and performed an update query on the database,
but the problem I have is I cannot retain the primary key field in a
variable which is then used in a SQL update...
|
by: Dave Smithz |
last post by:
Hi There,
Being quite new to MS-SQL I would like to ask if there is a general opinion
of what approach should be taken to storing things like external documents
and images in databases.
Should the actual files be stored within the database, or instead should
links to the files on a file server or something similar be stored instead.
For the end user I imagine it is easier to have everything stored within the
|
by: Dave |
last post by:
I have a system that basically stores a database within a database (I'm
sure lots have you have done this before in some form or another).
At the end of the day, I'm storing the actual data generically in a
column of type nvarchar(4000), but I want to add support for unlimited
text. I want to do this in a smart fashion. Right now I am leaning
towards putting 2 nullable Value fields:
ValueLong ntext nullable
ValueShort nvarchar(4000)...
|
by: hamvil79 |
last post by:
I'm implementig a java web application using MySQL as database.
The main function of the application is basically to redistribuite
documents. Those documents (PDF, DOC with an average size around 2Mb)
are stored in BLOB column.
The amount of documents for the first year should not exceed 5/6 Giga,
but I cannot make prevision for the next years.
Those documents are mainly just accessed (update and delete are not so
|
by: Arnold |
last post by:
I need to read a binary file and store it into a buffer in memory (system
has large amount of RAM, 2GB+) then pass it to a function. The function
accepts input as 32 bit unsigned longs (DWORD). I can pass a max of 512
words to it at a time. So I would pass them in chunks of 512 words until the
whole file has been processed. I haven't worked with binary files before so
I'm confused with how to store the binary file into memory. What sort of...
| |
by: Dave |
last post by:
Hello,
I am wondering about including binary files in my MS Access database
application. I want to keep my application as just a single MDE or MDB
file, but the users of the app may need some additional files. One file
is an ODBC driver for connecting to an external database, this is a 120
kb DLL. The other is a 20 kb PDF help document for using the database
application. I am wondering if it is possible to store these files
within...
|
by: (PeteCresswell) |
last post by:
User wants to go this route instead of storing pointers in the DB and the
documents outside.
Only time I tried it was with only MS Word docs - and that was a loooong time
ago - and it seemed to me like there were performance issues at the time.
How about the different types? The MS docs I would expect Access to
differentiate and handle appropriately (i.e. .DOC and .XLS).. but how about
..PDF? and can I stash a .TXT document in the...
|
by: AlekseyUS |
last post by:
Hi, I'm a little stuck,
I basically need to copy all the information within a specific file in Temp and append it to a file in another location.
I'm not having any problems with smaller size log files stored within temp foldier and everything reads and appends perfectly, however when i try to read and append from IS12Install.log file in Temp all it appends to my destination file is:
ÿþ=
and a whole bunch of empty lines
I believe...
|
by: RN |
last post by:
Hi everyone,
First please let me explain. I am attempting to store pdf files in an MS
Access DB (2000) and I have written a subroutine to do this. My code seems
to work perfectly (see code below).
Imports System.IO
Imports System.Data.OleDb
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |