Solved

Transfer BLOB Data from SQL Server 2000 in LAN to Web Server in DMZ

Posted on 2006-07-13
2
309 Views
Last Modified: 2013-12-16
Here is the schema:

1. Coldfusion web server in DMZ.
2. SQL Server 2000 with local X:/  drive in LAN. And files such as PDF and MP3 are stored on X:/ drive.

The scenario is that when user sends request and Coldfusion web server needs to display PDF or MP3 to user. Therefore, I need to:

1. By user's request, a stored procedure on SQL Server gets corresponding PDF or MP3 from X:/ driver to a temporary table.
2. The stored procedure returns PDF or MP3 as BOLB IMAGE from the temporary table to ColdFusion server.
3. ColdFusion web server displays PDF or MP3.

My question is that is my idea doable? Any comments are welcome!

Thanks!

yl

0
Comment
Question by:yanglin
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 17101430
X:\ drive being mapped needs to be replaced by \\SERVERNAME\SHARENAME

but for the rest, it is "doable". however, I would not do it like that (for performance reasons):
  * file needs to go over the network from X:\ to the server (temp table), and from there to web server, and from there to client browser. also, this will be quite slow.

 if really you want the sql server in between, you should store the files directly in the database
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
coldfusion upload spreadsheet into the databse 2 44
SSRS 2012 r2 - Parm Drop Down has Date/Time 12 32
SSRS 2013 - Overlapping reports 2 21
Sql Server group by 10 27
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
I have a large data set and a SSIS package. How can I load this file in multi threading?
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question