Help me how to insert audio or wave files into sql server database and what data type do i have to use..?
Give me samples.....
And also I want to know how to retrieve them?
Thanx.......... .
10  2567  iburyak 1,017
Recognized Expert Top Contributor
I would save full path to wave files not files themselves.
Retrieve full path from the database and go to the file and retrieve it.
Good Luck.
I would save full path to wave files not files themselves.
Retrieve full path from the database and go to the file and retrieve it.
For another option, have a look at the Tips & Tricks thread, at the top of the VB forum. Among other things, it includes instructions on how to store and retrieve images in a BLOB ( Binary Large Object) field. Should also work for sound files. You can also use an OLE field.
Note, this relates to Access - I'm not sure how closely SQL Server resembles it.
Ya thanx.. But I know how to store in Access but I need it in SQL Server...
What data type do i have to use?
I used OLE object datatype for Access but what for sql server?
MMcCarthy 14,534
Recognized Expert Moderator MVP
Ya thanx.. But I know how to store in Access but I need it in SQL Server...
What data type do i have to use?
I used OLE object datatype for Access but what for sql server?
All Access is doing is storing the path to a linked file or the full file if it's embedded. Storing embedded files is not recommended. In Access it is the OLE Object properties that determine how access treats this file and what application it uses to open it. As far as I'm aware this is not a feature of SQL Server.
Mary
All Access is doing is storing the path to a linked file or the full file if it's embedded. Storing embedded files is not recommended. In Access it is the OLE Object properties that determine how access treats this file and what application it uses to open it. As far as I'm aware this is not a feature of SQL Server.
Thanks, Mary.
Presumably SQL Server has an equivalent to BLOBs, though? Arunbalait might need to go to simply storing the audio as a chunk of data and dumping it into a temp file to play it, much like the image thing I referred to earlier. Seems crude, but may be unavoidable.
MMcCarthy 14,534
Recognized Expert Moderator MVP
Thanks, Mary.
Presumably SQL Server has an equivalent to BLOBs, though? Arunbalait might need to go to simply storing the audio as a chunk of data and dumping it into a temp file to play it, much like the image thing I referred to earlier. Seems crude, but may be unavoidable.
I know BLOB's are used for image files so there is probably a way of doing it for audio files also. Unfortunately, not my area of expertise. I have asked someone else to have a look at this who may have more experience in this area.
Mary
Ya me too heard abut BLOB. But I want exact syntax for using BLOB...
Give me an example like
insert into tab1 values(?,?)
to insert audio data....
Also for creating table regarding this..
give me exact sample code plz...
thanx
I already got answer to store the audio data into Access. Its simply like storing image files using OLE object type. But I want to know about SQL Server. What datatype to use, how to insert etc., In access we can give the path to store. I used the same procedure in SQL but its not working...
I used varbinary data type in sql server
Finally I got the answer... I used image datatype in sql server to store wav files..
Thanx for u all...
Then anybody know abut .dss extension audio files?
Thank you
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: David |
last post by:
Hey,
I'm looking for a code that can insert live audio, just like live
video using Netmeeting as a host. The code I have for video is:
<HTML><OBJECT ID="NetMeeting"
CLASSID="CLSID:3E9BAF2D-7A79-11d2-9334-0000F875AE17"><PARAM
NAME="MODE" VALUE="RemoteNoPause"></OBJECT><SCRIPT>NetMeeting.CallTo("callto:90.0.0.185+type=ip");</SCRIPT></HTML>
If there is one that can apply the same type of function, but using a
|
by: consulttech2004 |
last post by:
Folks,
Someone I know is using Microsoft Access 2003 to create a Data Access
Page. They have inserted a Quick Time Movie. When they view the page
(the HTML version of the page) and run the film, the audio sound plays,
but not the video.
I have searched Technet, as well as the resources found here on Google
Groups. I have not been able to find anything about this. Any help
would be appreciated. Thanks in advance.
|
by: ViperCB |
last post by:
Hello from a newbie,
I am trying to do some research on an upcoming project that involves reading
in audio files of various formats and using the audio signal as a source of
noise to generate pretty pictures. (like windows media player visual plugins.
I will be developing in C++ and was wondering if there are any packaged
libraries out there that I can use to read audio files encoded in different
formats and lets me easily access the...
|
by: jim shirreffs |
last post by:
Hello, I am trying to put together a Java system for playing audio CDs on a
large CD player, I have most of it working But entering all the data like
Artist, Title, track name, track length (seconds) is a real pain in the
butt. What I would like to do is write a java class that would extrack that
info from an audio CD placed in the computers CDROM drive. I have looked and
looked and looked and looked, but I can not find any exambles of how...
|
by: positivebalance41m |
last post by:
I have been searching how to do sound capture (record audio input) in
VB.NET for days now.
I find some references to "winmm.dll" calls, but they give VB5 or VB6
examples which won't code convert upgrade to VB.NET without warnings
errors that I can understand how to fix.
There's some ActiveX and OCX's floating around, some free some not, but
in all cases they don't explain or give me access to the raw PCM data
in some kind of familiar...
| | |
by: arunbalait |
last post by:
Anybody know how to insert wav data into sql server...
What data type do I have to use create table for storing wav data?
And how to insert them?
Please give me syntax for all. And also to retrieve.
wav means .wav files for audio or sound
|
by: Udhay |
last post by:
Sir,
I want to read the data of an audio file in c++ (Windows).
What is the API which helps to read the data of an audio file.
I want to read BitRate,Audio Sample Size,Audio Sample rate and Channel
udhay
|
by: Carlos Leite |
last post by:
Is there any other option to analyze audio frequencies?
Or
Any here try to use pymedia to a simple audio FingerPrint.
A cant understand what the information the asBands() really giveme.
The Docs, say that asBands() return a List of tupples grouped by
frquenciy, and the first two values are frquency limits. But I dont
thonk so ! Its not seems to be correct!
|
by: AWW |
last post by:
Using XP and VB 2005, it seemed like a good idea to
save audio in the clipboard and then play it with backgroundworker.
Cannot find a good Clipboard audio example anywhere - just SetAudio
and GetAudio. And an example seems to do a SwapAudio which makes no
sense.
Basically I want to spool or simulate spooling of audio.
So is this reasonable for asynchronous audio clip play? or alternate?
Any thoughts or pointers to other sources? Thanks.
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
