MP3 FILES INTO SQL2000

  • Hi,

    This the scenario:

    Two clients, one WIN98 & the other WIN2000 (SQL2000 installed on the latter). All MP3 files are stored on WIN98 client.

    Using SQL 2000, DTS or replication can those MP3 files being stored within an SQL database called MyMusic and have regular updates from WIN98 into WIN2000?

    Could I then run a SELECT statement to view the contents of the table as you would with any other SQL database?

    Where could I find examples of scripts & methods? Someone mentioned 'blob' but how do I start?

    thanks

    vas

  • This was removed by the editor as SPAM

  • If you look at the routines to handle the data type of image that might help you understand a "blob" better. The basic idea is to *chunk* the information into and out of the database.

    If you don't find the samples in Books OnLine, reply and I will try to dig up some of the routines we used in a previous project.

    Guarddata-

  • Hey Diamond V,

    Tim Cartwright has an answer in another forum. Check out this URL

    http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B180368

    Guarddata-

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply