Yes, it would be much better, but our client doesn't
seem to think so. it seems so pointless to store all these files when the hard disk is the perfect repository.
michael
Comment on Re: Re: storing files with dbi & sqlserver
Ah, I see. You should really try to convince the client otherwise. You, after all, are the one with the experience and knowledge; they shouldn't be telling you what is best.
In any case, sorry I can't help. I don't do work with Microsoft products and haven't ever stored files in a DB. If you were using MySQL though, you'd probably want to use a blob for the column type. I believe it can hold binary or ASCII data. I don't know if MSSQL has that type.