It worked and its working fine now.

Thanks for your help.

and i really appreciate the support extended by you.

Thanks indeed.

Take Care

-------------------------------------file.asp---------------------------------

<%

   ' Retrieves binary files from the database

   Response.Buffer = True

   ' ID of the file to retrieve

   Dim ID

      ID = Request("ID")

   If Len(ID) < 1...

iam also using asp application (Front End) .

File data is shown in junk format.

I used image datatype, the problem is word,excel and powerpoint file data is shown as junk representation.

What might be the reason...

Thanks

I did used image datatype previously but its best suited if iam storing only image files.

but i want something which can store any format of file (.doc,.ppt,.xls,.pdf etc)