Saving a sound file into database?

Hi guys,

Can anyone help me in uploading a sound file(abt 3MB) into the DB from the client side and play them later using embedded windows media player?

Thks in advance,

PSK

Why do you want to store them in a database? Why not just save them on the file system? Putting large files in a Database has some gotchas.|||

I could save them to database ( blob) but I dont know how to retrieve them and play in Win media player.

I can also go with file system but how do I transfer the file to the server ?( I know the full path of the file in the client end as I save it in a temp directory. The client doesnt require to select the path of file ).Now how do I upload it to server when submit button is clicked.

Thanks,

PSk

|||

but how do I transfer thefile to the server ?The client doesnt require to select the path of file ?

I don't think this can be achieved.Do you think it is secure If you upload client files into the server without noticing the user?

For security reasons ,filepath only can be selected by users.

|||Indeed, there is no way using ASP.NET or HTML to copy a file to a server without a browse for file dialog.|||

I apologize for the off-topic post, but I haven't received a response to my email to you, Kevin, and I'm guessing that it's something you wouldn't mind talking to me about, see my .sig. :-)

Thanks,
Steve Dybing
MVP Lead | ASP.NET | Infrastructure Architect | Solutions Architect
steve.dybing@.microsoft.com
https://mvp.support.microsoft.com/

|||

The user speech is recorded in the client end by an ActiveX control and stored in a default location and then I transfer them to the database or file system in the server. I have obtained the filepath and now how should I transfer the file to the server?

Sorry for the late reply

Thanks,

PSK

|||Actually , the active X control saves in a temporary location. I then obtain the file path from that location.

Thanks,

PSK

|||

There is no way to transfer a file to a server without "prompting" the user for the file. It cannot be done without another ActiveX control.

|||Okay. So,What if I will pass the file path as a parameter to ASP.Net file upload control and then prompt the user to click the submit button(ie Upload button)?If it can be done, can the file be transfered then?And also wat is the size of the file that I can transfer?I wan to transfer a file size from 1MB to 4MB.Thanks,PSk|||You cannot upload a file without the browse file dialog, and there is no way to preset the file that will be uploaded to my knowledge. You can upload a file as big as you want, but the server will have to be configured for it. ASP.NET has a 4MB maximum response size, so 4MB is the max by default.

Save The Newbie! SQL help

Hey guys. I have been given the task of converting from oracle to microsoft SQL syntax.

I have this oracle code:
CREATE OR REPLACE PROCEDURE BA_DROP_TABLE (p_TableName IN varchar2) IS
i int;
BEGIN
select count(*) into i from user_tables where table_name = p_TableName;
IF i=1 THEN
EXECUTE IMMEDIATE 'DROP TABLE ' || p_TableName || ' CASCADE CONSTRAINTS';
END IF;
END;
/

I tried to convert it, and this is what I came up with:
if (object_id ('BA_DROP_TABLE') is not null)
drop proc BA_DROP_TABLE
go

CREATE PROCEDURE BA_DROP_TABLE @.p_TableName varchar(30)
AS
DECLARE @.i integer
BEGIN
select @.i = count(*) from user_tables where table_name = p_TableName
IF @.i=1
DROP TABLE p_TableName
END

This doesn't work. I think the problem has something to do with not being able to drop the table because its a parameter. I've heard talk of dynamic sql.

Someone PLEASE help a guy out!

Thanksreplace "DROP TABLE p_TableName" with "exec ('drop table ' + @.p_TableName)

Make sure the user has DROP OBJECTS permission.|||Now I get this error:

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'BA_DROP_TABLE'. The stored procedure will still be created.

SAN and RAID

Hi Guys,
I have question regarding RAID and SAN. For disk arry, does SAN use RAID in
the disk array? what is relationship between them? Thank.A SAN uses RAID technology as part of a storage solution. Unlike
direct-attached storage, a SAN provides storage virtualization and features
to improve availability, manageability, scalability, fault tolerance and
performance.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:118414DA-40AF-4016-A932-B7FD61DCE559@.microsoft.com...
> Hi Guys,
> I have question regarding RAID and SAN. For disk arry, does SAN use RAID
> in
> the disk array? what is relationship between them? Thank.
>|||Thanks, Dan. BTW, what RAID does SAN use? RIAD 10 or RAID 5? Or we can setup
which RAID a SAN can use? Thanks.
"Dan Guzman" wrote:
> A SAN uses RAID technology as part of a storage solution. Unlike
> direct-attached storage, a SAN provides storage virtualization and features
> to improve availability, manageability, scalability, fault tolerance and
> performance.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> http://weblogs.sqlteam.com/dang/
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:118414DA-40AF-4016-A932-B7FD61DCE559@.microsoft.com...
> > Hi Guys,
> > I have question regarding RAID and SAN. For disk arry, does SAN use RAID
> > in
> > the disk array? what is relationship between them? Thank.
> >
> >
>|||> Thanks, Dan. BTW, what RAID does SAN use? RIAD 10 or RAID 5? Or we can
> setup
> which RAID a SAN can use? Thanks.
The RAID level and configurability depends on the features of the specific
SAN. A SAN is proprietary solution but the ones I've worked with support
RAID 5 and 10.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:32B1177B-5BF6-4CE3-9B72-8DFFDD122B1D@.microsoft.com...
> Thanks, Dan. BTW, what RAID does SAN use? RIAD 10 or RAID 5? Or we can
> setup
> which RAID a SAN can use? Thanks.
>
> "Dan Guzman" wrote:
>> A SAN uses RAID technology as part of a storage solution. Unlike
>> direct-attached storage, a SAN provides storage virtualization and
>> features
>> to improve availability, manageability, scalability, fault tolerance and
>> performance.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> http://weblogs.sqlteam.com/dang/
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:118414DA-40AF-4016-A932-B7FD61DCE559@.microsoft.com...
>> > Hi Guys,
>> > I have question regarding RAID and SAN. For disk arry, does SAN use
>> > RAID
>> > in
>> > the disk array? what is relationship between them? Thank.
>> >
>> >|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:805751D3-8066-4728-999B-6E831E363690@.microsoft.com...
>> Thanks, Dan. BTW, what RAID does SAN use? RIAD 10 or RAID 5? Or we can
>> setup
>> which RAID a SAN can use? Thanks.
> The RAID level and configurability depends on the features of the specific
> SAN. A SAN is proprietary solution but the ones I've worked with support
> RAID 5 and 10.
To be clear, you can use both in the same SAN.
I think Network Appliances even uses RAID 4.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> http://weblogs.sqlteam.com/dang/
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:32B1177B-5BF6-4CE3-9B72-8DFFDD122B1D@.microsoft.com...
>> Thanks, Dan. BTW, what RAID does SAN use? RIAD 10 or RAID 5? Or we can
>> setup
>> which RAID a SAN can use? Thanks.
>>
>> "Dan Guzman" wrote:
>> A SAN uses RAID technology as part of a storage solution. Unlike
>> direct-attached storage, a SAN provides storage virtualization and
>> features
>> to improve availability, manageability, scalability, fault tolerance and
>> performance.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> http://weblogs.sqlteam.com/dang/
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:118414DA-40AF-4016-A932-B7FD61DCE559@.microsoft.com...
>> > Hi Guys,
>> > I have question regarding RAID and SAN. For disk arry, does SAN use
>> > RAID
>> > in
>> > the disk array? what is relationship between them? Thank.
>> >
>> >
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Iter, it sounds to me like you are considering (or have already) purchasing
a SAN for use with SQL Server. You REALLY REALLY should get professional
help in setting this up correctly since you appear to be a newbie with them.
Configuring this yourself will lead to VERY suboptimal performance,
guaranteed. You simply cannot learn what you need to do this from a few (or
even many) forum posts.
Note that (in my esperience) most SAN-vendor-employed-consultants know VERY
little about how to properly configure a SAN for SQL Server usage.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:32B1177B-5BF6-4CE3-9B72-8DFFDD122B1D@.microsoft.com...
> Thanks, Dan. BTW, what RAID does SAN use? RIAD 10 or RAID 5? Or we can
> setup
> which RAID a SAN can use? Thanks.
>
> "Dan Guzman" wrote:
>> A SAN uses RAID technology as part of a storage solution. Unlike
>> direct-attached storage, a SAN provides storage virtualization and
>> features
>> to improve availability, manageability, scalability, fault tolerance and
>> performance.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> http://weblogs.sqlteam.com/dang/
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:118414DA-40AF-4016-A932-B7FD61DCE559@.microsoft.com...
>> > Hi Guys,
>> > I have question regarding RAID and SAN. For disk arry, does SAN use
>> > RAID
>> > in
>> > the disk array? what is relationship between them? Thank.
>> >
>> >