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.

Sample database Installation

Is anyone running SQL Server 2005 on XP Media PC? I did install the program but even though I selected an installation of sample db's, they didn't install. Also, the option to install 'reporting services' was not available to be checked. I'm new at this and believe I need IIS installed. I looked and saw all kinds of IIS 'things' in a search. I don't know what I'm looking for.

thx,

Kat

hi kat,

to install IIS

start>run>control>add remove programs>Add remove windows component>Internet information server(iis)

please have your windows xp installer ready

reporting services available only with enterprise edition

sample programs are available at

http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

if it doesn't install automatically on the server you can attach it with sql server magement studio express(MS). plese refer to your other post for SQL-MS

regards

joey

|||

Right now I am running on my old Dell Latitude with SQL 2000. It has 2000 professional edition but I think 2005 will die on this pc. I'm getting my bios rewritten on my newer laptop which has Windows xp on it. Someone said that I could install the developer edition on this new pc and that I could do something with reporting services in the developer edition.

NOTE: This is a standalone laptop with no access to a server. Will any of this work IIS configuration, Web services, Report Services with the developer edition of 2005? I'm getting so frustrated with this. Everyone wants Reporting experience but how do you get it if you aren't working in a position that has this all set up.

I thought I could install reporting services, IIS, etc for 2000 on this standalone pc with sql 2000, is that a yes or no. I would like this to go out to everyone.

thx,

Kat

|||reporting services runs only on the enterprise edition of sql server 2000|||

I was told it would also run on the developer edition. This will all be easier when I get my laptop back (xp pro) and I can install 2005 developer edition... maybe then it'll be easier to find out what you guys already know.

thx,

kat

|||

sql server 2000 rs runs only on enterprise edition of sql server

if you want to run rs on XP

I recommend you use 2005 developer edition

|||

Hi Joey,

thanks, I should get my xp pro laptop back this week, then I will install the Developer edition of SQL Server 2005 and get to work.

Kat

Sample database Installation

Is anyone running SQL Server 2005 on XP Media PC? I did install the program but even though I selected an installation of sample db's, they didn't install. Also, the option to install 'reporting services' was not available to be checked. I'm new at this and believe I need IIS installed. I looked and saw all kinds of IIS 'things' in a search. I don't know what I'm looking for.

thx,

Kat

hi kat,

to install IIS

start>run>control>add remove programs>Add remove windows component>Internet information server(iis)

please have your windows xp installer ready

reporting services available only with enterprise edition

sample programs are available at

http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

if it doesn't install automatically on the server you can attach it with sql server magement studio express(MS). plese refer to your other post for SQL-MS

regards

joey

|||

Right now I am running on my old Dell Latitude with SQL 2000. It has 2000 professional edition but I think 2005 will die on this pc. I'm getting my bios rewritten on my newer laptop which has Windows xp on it. Someone said that I could install the developer edition on this new pc and that I could do something with reporting services in the developer edition.

NOTE: This is a standalone laptop with no access to a server. Will any of this work IIS configuration, Web services, Report Services with the developer edition of 2005? I'm getting so frustrated with this. Everyone wants Reporting experience but how do you get it if you aren't working in a position that has this all set up.

I thought I could install reporting services, IIS, etc for 2000 on this standalone pc with sql 2000, is that a yes or no. I would like this to go out to everyone.

thx,

Kat

|||reporting services runs only on the enterprise edition of sql server 2000|||

I was told it would also run on the developer edition. This will all be easier when I get my laptop back (xp pro) and I can install 2005 developer edition... maybe then it'll be easier to find out what you guys already know.

thx,

kat

|||

sql server 2000 rs runs only on enterprise edition of sql server

if you want to run rs on XP

I recommend you use 2005 developer edition

|||

Hi Joey,

thanks, I should get my xp pro laptop back this week, then I will install the Developer edition of SQL Server 2005 and get to work.

Kat