October 30, 2007 at 10:53 pm
Hi,
Kindly provide solution for ,,,,,,,,,,,
How to store Audio files in SQL Server 2000
regards
pavan
November 1, 2007 at 4:19 am
Im not sure, but storing audio files in sql server 2000 is not supported.
You can do the following
Store the audio files into a folder (eg: D:\songs)
Then store the filename and the exact path in sql server table
You can use this table to retrive the filename and path using the table so that you can have access to the audio files
Regards..Vidhya Sagar
SQL-Articles
November 1, 2007 at 6:44 am
Vidhya, I would not be so hasty in claiming that. SQL Server is an OLEDB Server, which means it can hold any type of files, and I am sure there are many many organisations who hold their movies, music, and pictures directly on SQL Server.
If I am wrong I hope someone will put me right.
November 2, 2007 at 4:24 am
It's a few years since I did this (and my memory might be failing me) but I worked on a project where we stored Excel files within the database and returned then to the client application using Append Chunk (to upload) and Get Chunk (to download). The files were stored in an image field. I see no reason why you couldn't store any type of file in an image field.
Jez
November 2, 2007 at 4:59 am
You can use the BLOB datatypes to store & retrive the information.
But the recommanded solution is,
- Store the Binary Objects in Common Server
- Store the Path of the file in the SQL Server Table
- Retrive the path information from table
- Retrive the orginal file from the table's path
It is more efficient than storing the values in the Database.
It will reduce your database maintanance cost & improve your performance too...
November 2, 2007 at 6:15 am
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply