Hi
I don’t want to change my name or anything :) but I wish I was able to save Sound into SQL server and retrieve it
So my question is How do you save a wav file into a SQL server and how do you retrieve it
Thanks so much
Lisa Jone
19  3838 
This article shows you how to store images, but a blob is a blob http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp
However, whether or not you want to do this is another story. You'll find
quite a few people with tales of woe trying to store a lot of BLOB data in a
DB only to find it killed performance...
"Lisa Jones" <an*******@disc ussions.microso ft.com> wrote in message
news:7D******** *************** ***********@mic rosoft.com... Hi
I don't want to change my name or anything :) but I wish I was able to
save Sound into SQL server and retrieve it.
So my question is How do you save a wav file into a SQL server and how do
you retrieve it?
Thanks so much
Lisa Jones
Why not store the file path to the DB and then save the file to the path. This would help to keep the DB Size down and speed up DB lookups
Glenn
I'm with you 100%. I posted a link on how to do it but I really think it's
ill advised unless it's a loooowww traffic db, and even then, it's a lot
easier to store it on a drive and you get the side benefit of being able to
access it without writing a good bit of code.
"Glenn Wilson" <an*******@disc ussions.microso ft.com> wrote in message
news:64******** *************** ***********@mic rosoft.com... Why not store the file path to the DB and then save the file to the path.
This would help to keep the DB Size down and speed up DB lookups.
Glenn
We have implemented this on several of our systems, and I am now in the process of writing some stored proces and adding fields so that we can refference the files if they are stored on backup tapes
As I work in a telephony Company storing hundreds of thousands of messages we need to have them stored on disk for easy access, but as time goes on these files are not needed straight away. I am writing a process that will remove the path of the file but leave the name, and then add two fields to the records that store a bit value if it is on tape, and then another that lists the tape name. This way the app (Which is also being moderfied) can return what tape needs to be access to find the record
Glenn
Cool, thanks for the post
"Glenn Wilson" <an*******@disc ussions.microso ft.com> wrote in message
news:8A******** *************** ***********@mic rosoft.com... We have implemented this on several of our systems, and I am now in the
process of writing some stored proces and adding fields so that we can
refference the files if they are stored on backup tapes. As I work in a telephony Company storing hundreds of thousands of messages
we need to have them stored on disk for easy access, but as time goes on
these files are not needed straight away. I am writing a process that will
remove the path of the file but leave the name, and then add two fields to
the records that store a bit value if it is on tape, and then another that
lists the tape name. This way the app (Which is also being moderfied) can
return what tape needs to be access to find the record.
Glenn
Hi
Yes I was thinking of storing only the path but there is only one problem and that is security. These are for medical transcripts. So if i store it as file how would i address the security consideration
Thank
Lis
Remember that the database is not really that secure, anyone with admin access to the database could view them, and if the database files (SQLServer) are detatched and moved any one can restore them to another DB and open them
One way to secure it would be to encrypt the stream as you save the file, Then the file would just be jiberish and only the app and a proper key could retrive them. As a side note you could also use component ones classes (Availible from the resource kit) to zip or compress the stream as you save it, this would add to the security and also give you a saving on disk space
Glenn
Thanks i might just do that.
Hi Lisa,
I agree with Glen and I agree with you.
However the most I agree with you that saving it in a database gives for
your purpose in my opinion a more certain way to manage it.
The wav file is a very old hugh sound format, did you ever thought on a more
modern compact sound format.
Cor
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: forums_mp |
last post by:
I've got an STL class (see below) with two functions to store and
retrieve data - msg structs.
The "Store" function when called will copy the received message
(depending on which message) into the appropriate array. For instance
if I receive a RCVD_MSG1, I'll copy into msg1 . Upon receipt of
the next RCVD_MSG1. I'll copy into msg1 ....
|
by: Senthil Kannan |
last post by:
Hi all,
Currently i have a FORM_BASED Authentication of tomcat5.0 to
store and retrieve passwords in my homepage.Now when i try to Store my
password in a encrypted form i am having some problems,i am listing
the problems here.do help me to fix this.
when a new user signup to my homepage his datas are to be stored in
database.while storing...
|
by: Darryl Kerkeslager |
last post by:
I frequently use OpenArgs to pass a value to a form; it would be nice if
there was a similarly easy way to return a value from a called form.
Darryl Kerkeslager
|
by: Roy Gourgi |
last post by:
Hi,
I am used to working in Visual FoxPro and I would like to be able to create
a database and store and retrieve information from it. What is the simplest
way to do it and what should I be using as there are many choices to choose
from.
My database will contain a lot of records.
TIA
|
by: Rudy |
last post by:
Hello all!
I am amazed how many posts I have read to store an image in SQL, and just as
many against it. So I learned how to store an image in a SQL db and retrieve
the image. A little tricky, but not too bad. But then I thought I wanted to
try the other way, by putting the file location in SQL and storing the actual
image in another...
| | |
by: Solution Seeker |
last post by:
I want to Store the String value with Single Quotes in the Field of
Database where if i try to Store the String value with Single Quotes
(as it is) then it is throwing the error as SQL String Truncated.
so we need a solution to store and retrieve user Entered value along
with single quotes into the Database.
i am using the String variable...
|
by: martin1 |
last post by:
Hi, All,
The app retrieve sound.wav file from my loacal C drive, is there anyway the
sound file can be stored in the app? then when building, it goes with app
rather than sending sound file seperate with app when deploying the app.
Thanks
|
by: JM |
last post by:
Before storing information from a form in database I perform follwing
operations on it :
$path =
mysql_real_escape_string(strip_tags(trim(urldecode($_POST))));
$summary =
mysql_real_escape_string(strip_tags(trim(urldecode($_POST))))
When I look in database I see '\r\n' in the text for the summary
wherever I pressed return-key.
When i...
|
by: angel1982 |
last post by:
I have this requirement where I have to store outlook mails into database and retrieve as necessary. The mail has to be retrieved back in outlook window itself, and not in any other format. The intention is to give him all the features available in the outlook.
So can someone please guide me as how to store the .msg file in the database and...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
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...
|
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...
|
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...
|
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...
|
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.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
