Saving Audio Files

Hi !
You can do this in sql server, with textcopy utility. You have to follow the following steps. (Don't bother with name, you can copy any file not only image but pdf, wav, jpg or any)

[1] Create a table in your database. For example -
create table table01 ( id int , audio_file image)
[2] Insert a value into it.
insert into table01 values ( 1 , 0x0 )
Note : Do not put NULL or other thing instead of 0x0.

[3] Type the following command in command. (Change Server, Database name )

(1) Insert into database -
TEXTCOPY.exe /S(local) /Uuser_name /Ppassword /D DB_NAME /T Table01
/C audio_file /F "C:\temp\wav001.wav" /W"where id=1" /I (2) Out to a file from database -
TEXTCOPY.exe /S(local)
/Uuser_name /Ppassword /D DB_NAME /T Table01 /C audio_file /F
"C:\temp\wav002.wav" /W"where id=1" /O ===============
I think you can do it well. If you can not do it, tell me soon.

Reply soon..

- Som Dutt

Thank you So much for that. I will try it tomorrow 13 June, and let you know before the end of the week. But thanx allot